Progress Database Admin - PowerPoint PPT Presentation

progress database admin n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Progress Database Admin PowerPoint Presentation
Download Presentation
Progress Database Admin

play fullscreen
1 / 291
Progress Database Admin
194 Views
Download Presentation
keagan
Download Presentation

Progress Database Admin

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Progress Database Admin Darren P. Rhoads - Engineering Support Consultant (drhoads@nxtrend.com)

  2. Introduction:

  3. Agenda: • Lecture - Database Concepts • Lunch • Database Workshop (hands-on)

  4. NxTrend’s Expectation Of A Database Admin

  5. NxTrend’s Expectation Of A Database Admin: • Maintenance • Crash Recovery • Troubleshooting • Scheduled Work

  6. Database Admin Maintenance: • Disconnecting users • Verify Backup Logs • Monitor/maintain extent structure – dbstats.log • Purging Database log files • Promon • Maintaining Scripts • Maintain .pf files • Maintain library file

  7. Database Admin Crash Recovery: • Brokers – start & stop • Removing .lk files • Clearing shared memory • Removing processes • Disconnecting users • Truncating BI files • Error messages in log files

  8. Database Admin Scheduled Work: • Dump/loads • Progress upgrades/patches

  9. NxTrend & Progress: • NxTrend & Progress • NxTrend runs on products we sell.

  10. What Is Progress? • Not an O/S • Database engine • 4GL Programming language

  11. Progress Database Concepts: • Physical Parts of a Database • .db - database • .bi – before image file • .lg – log file • .lk – lock file (only there when Broker is up)

  12. .db .bi .lg

  13. Starting The Database Broker • Unix Process • Shared memory • virtual tables • lock file (.lk)

  14. _mprosrv .db .bi .lg

  15. Shared Memory _mprosrv .db .bi .lg

  16. Shared Memory Virtual tables User id TTY PID Lock

  17. Shared Memory Virtual tables u t p l _mprosrv .db .bi .lg

  18. Shared Memory Virtual tables u t p l _mprosrv .db .bi .lg .lk

  19. User Login • Unix Process • Logs into virtual tables • Logged in the log file (.lg)

  20. User 1 Shared Memory Virtual tables u t p l _mprosrv .db .bi .lg .lk

  21. User 1 _progres Shared Memory Virtual tables u t p l _mprosrv .db .bi .lg .lk

  22. User 1 _progres Shared Memory Virtual tables u t p l u1 _mprosrv .db .bi .lg .lk

  23. Shared Memory Virtual tables User id TTY PID Lock User 1 tty/01 12345

  24. User 1 _progres Shared Memory Virtual tables u t p l u1 _mprosrv .db .bi .lg .lk

  25. User 1 _progres Shared Memory Virtual tables u t p l u1 _mprosrv .db .bi .lg .lk

  26. Data-Flow Discussion • Data gets pulled into memory • User reads from memory • User never read from the database

  27. User 1 _progres Shared Memory Virtual tables u t p l u1 _mprosrv a b c .db .bi .lg .lk

  28. User 1 _progres Shared Memory Virtual tables u t p l a b c u1 _mprosrv a b c .db .bi .lg .lk

  29. User 1 _progres Shared Memory Virtual tables a b c u t p l a b c u1 _mprosrv a b c .db .bi .lg .lk

  30. Data-Flow Discussion • User Updates data • lock table

  31. User 1 _progres Shared Memory Virtual tables a b d u t p l a b c u1 c _mprosrv a b c .db .bi .lg .lk

  32. User 1 _progres Shared Memory Virtual tables a b d u t p l a b d u1 _mprosrv a b c .db .bi .lg .lk

  33. Data-Flow Discussion • Before-Image File • BIW • Data gets written to disk (.bi file)

  34. User 1 _progres Shared Memory Virtual tables a b d u t p l a b d u1 _mprosrv a b c .db .bi .lg .lk

  35. User 1 _progres Shared Memory Virtual tables a b d u t p l a b d u1 _mprosrv a b c .db biw .bi .lg .lk

  36. User 1 _progres Shared Memory Virtual tables a b d u t p l a b d u1 _mprosrv a b c .db biw .bi bt .lg .lk

  37. User 1 _progres Shared Memory Virtual tables a b d u t p l a b d u1 _mprosrv a b c .db biw .bi bt c .lg .lk

  38. User 1 _progres Shared Memory Virtual tables a b d u t p l a b d u1 _mprosrv a b c .db biw .bi bt c .lg .lk

  39. User 1 _progres Shared Memory Virtual tables a b d u t p l a b d u1 _mprosrv a b c .db biw .bi bt c d .lg .lk

  40. User 1 _progres Shared Memory Virtual tables a b d u t p l a b d u1 _mprosrv a b c .db biw .bi bt c d et .lg .lk

  41. Data-Flow Discussion • Review

  42. User 1 _progres Shared Memory Virtual tables a b d u t p l a b d u1 _mprosrv a b c .db biw .bi bt c d et .lg .lk

  43. User 1 _progres Shared Memory Virtual tables a b d u t p l a b d u1 _mprosrv a b c .db biw .bi bt c d et .lg .lk

  44. User 1 _progres Shared Memory Virtual tables a b d u t p l a b d u1 _mprosrv a b c .db biw .bi bt c d et .lg .lk

  45. User 1 _progres Shared Memory Virtual tables a b d u t p l a b d u1 _mprosrv a b c .db biw .bi bt c d et .lg .lk

  46. User 1 _progres Shared Memory Virtual tables a b d u t p l a b d u1 _mprosrv a b c .db biw .bi bt c d et .lg .lk

  47. Data-Flow Discussion • After-Imaging File • AIW

  48. User 1 _progres Shared Memory Virtual tables a b d u t p l a b d u1 _mprosrv a b c .db biw .ai .bi bt c d et .lg .lk

  49. User 1 _progres Shared Memory Virtual tables a b d u t p l a b d u1 _mprosrv aiw a b c .db biw .ai .bi bt c d et .lg .lk

  50. Data-Flow Discussion • Asynchronous Page Writer • APW • Data gets written to .db