1 / 30

Progress Database Admin

Progress Database Admin. Jeffrey A. Brown – Engineering Support, Technical Consultant (Jeffrey.Brown@infor.com). Introduction. Agenda. Infor Installation Standards Log Files Progress Properties Files Progress Explorer Tool Start / Query / Stop environment Crash Recovery.

daria-parks
Download Presentation

Progress Database Admin

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Progress Database Admin Jeffrey A. Brown – Engineering Support, Technical Consultant (Jeffrey.Brown@infor.com)

  2. Introduction

  3. Agenda • Infor Installation Standards • Log Files • Progress Properties Files • Progress Explorer Tool • Start / Query / Stop environment • Crash Recovery

  4. Infor Installation Standards

  5. Infor Filesystem Standards • File Systems • /db (striped filesystem) • /rd (striped filesystem)

  6. Directories /db • /db/nxt.db • /db/nxt.bi • /db/nxt.lg • /db/nxt.lk

  7. Directories /db/sort • /db/sort/DBI* • /db/sort/lbi* • /db/sort/srt*

  8. Directories /rd • /rd/bin • /rd/opsys/*.pf • /rd/dlc • /rd/dlc/bin • /rd/appsrv/code • /rd/tmp

  9. Infor Standard Ports • Most are defined in MARC • Should be defined in the /etc/services file • Test ports are the same using 7200 range

  10. Infor Standard Ports nxt 7100/tcp # SX database appsrv 7120/tcp # SX appserver twl 7160/tcp # TWL twlappsrv 7161/tcp # TWL appserver twlsxappsrv 7162/tcp # TWL SX appserver nxtadmsrv 7180/tcp # adminserver port nxtadmsrvadmin 7181/tcp # adminserver admin port nxtnamesrv 7182/udp # nameserver port

  11. Progress 9.x Log Files

  12. Progress 9.x Log Files • New log files in Progress 9.x • $DLC/bin/proenv • $WRKDIR • exit out when done • Most logs are found in /rd/tmp • Some are in /db/sort

  13. Progress 9.x Log Files • admserv.log • exceptions.log • default.log • AdminServerSystemOut.log • NS1.ns.log • appsrv.broker.log / appsrv.server.log • rptlog#### • rptmgr.err

  14. Progress 9.x Log Files • dbstats.log • Summary • Empty blocks • Free blocks

  15. Progress 9.x Properties Files

  16. Progress 9.x Properties Files • No database parameter files for Progress 9.x • Admin server reads from “properties” files. • The properties files are stanza based. • You may use Marc or the Progress Explorer Tool to make modifications. • DO NOT edit these files by hand!

  17. Progress 9.x Properties Files • V8 used many parameter files (/rd/opsys/nxtdb.pf) • $DLC/properties/conmgr.properties • Database Broker • All Databases Registered • $DLC/properties/ubroker.properties • Admin Server • Name Server • App Broker • Etc. • DO NOT edit these files by hand!

  18. Progress 9.x Properties Files • Utilities to help validate your changes: ubconfig nsconfig asconfig (-name appsrv) dbconfig • These utilities are in $DLC/bin

  19. Database Workshop Working With Databases (hands-on)

  20. Working With Databases • Setup Progress environment variables • Progress Explorer tool • Progress configuration files • ubroker.properties • conmgr.properties

  21. Working With Databases • Starting the Admin Server • Validating startup of Admin Server • Validating startup of Nameserver

  22. Working With Databases • Start broker • Validate database broker startup • shared memory • Unix process • lock file • Stop broker

  23. Working With Databases • emergency shutdown • log file • progress editor (errors messages)

  24. Working With Databases • start APW • start BIW

  25. Working With Databases • crash recovery • truncate bi file

  26. Dump & Load

  27. Dump & Load – Exercise (hands-on) Data - .bd Structure - .df File - .db

  28. Review • Question & Answer Session

  29. Questions ? ? ? ? ? ? ? ? ? ? ? ?

  30. Progress Database Admin

More Related