1 / 262

Progress Database Admin

Progress Database Admin. Jeffrey A. Brown – Engineering Support, Technical Consultant (Jeffrey.Brown@infor.com). Introduction. Agenda. Lecture - Database Concepts Lunch Database Workshop (hands-on). Infor’s Expectation Of A Database Admin. Infor’s Expectation Of A Database Admin.

mckile
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 • Lecture - Database Concepts • Lunch • Database Workshop (hands-on)

  4. Infor’s Expectation Of A Database Admin

  5. Infor’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

  7. Database Admin Crash Recovery • Brokers – start & stop • Disconnecting users • Truncating BI files • Error messages in log files

  8. Database Admin Pre-Arranged Work • Dump/loads • Progress upgrades/patches

  9. Infor & Progress • Infor & Progress • Infor 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 • Broker 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 • User 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 • Changes get 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 • Changes get written to .db

More Related