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

Loading in 2 Seconds...

play fullscreen
1 / 179
klaus

Progress Database Admin - PowerPoint PPT Presentation

128 Views
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. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

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

  1. Progress Database Admin Jeffrey A. Brown - Technical Support Consultant (jefbrown@nxtrend.com) 1

  2. Introduction: 2

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

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

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

  6. Licensing • Enterprise DB • Appserver • 4GL • Provision (PC Client side) • Client Networking • Query/Results (being replaced by SX.explorer) • Merant (ODBC) 6

  7. 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) 7

  8. .db .bi .lg 8

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

  10. _mprosrv .db .bi .lg 10

  11. Shared Memory _mprosrv .db .bi .lg 10

  12. Shared Memory Virtual tables User id Lock TTY PID 11

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

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

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

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

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

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

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

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

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

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

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

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

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

  26. Data-Flow Discussion • User Updates data • lock table 19

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

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

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

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

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

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

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

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

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

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

  37. Data-Flow Discussion • Review 23

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

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

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

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

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

  43. Data-Flow Discussion • After-Imaging File • AIW 25

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

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

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

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

  48. Data-Flow Discussion • Final Review 29

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

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