1 / 17

Progress Database Internals

Progress Database Internals. Duc Chu. Shared Memory. Servers. Shared Memory. DB Broker. BIW. APW. Before Image. Database. Version 8 Data Processes. Database: _mprosrv App Server: _proapsv Before Image Writer: _mproshut Asyncrhonous Page Writer: _mproshut User: _progres.

blaise
Download Presentation

Progress Database Internals

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 Internals Duc Chu

  2. Shared Memory Servers Shared Memory DB Broker BIW APW Before Image Database

  3. Version 8 Data Processes • Database: _mprosrv • App Server: _proapsv • Before Image Writer: _mproshut • Asyncrhonous Page Writer: _mproshut • User: _progres

  4. Version 8 Data Files • Database • trhead.db • trhead.d1, trhead.d2, trhead.d3, … • Before Image • trhead.bi • trhead.b1, trhead.b2, trhead.b3, … • Log file • trhead.lg • License file • trhead.lic • Lock file • trhead.lk

  5. Version 8 Data Files trhead.db trtrans.db trhead.d1 trtrans.d1 trhead.d2 trtrans.d2 trhead.bi trtrans.bi trhead.b1 trtrans.b1 trhead.b2 trtrans.b2

  6. Databases vs. Storage Areas • Why six databases? • Previous processor issues • Administrative ease (dump & load, idxrebuilds, etc.) • Why storage one database? • Ease in tuning • Data affinity in cache • Not for every version 8 database • What are storage areas? • Logical database “areas” • Separate database schema from data • Restores ease of administration (dump&load, etc.)

  7. Version 9 Data Files • Data files (dbname_sa#.ext#) • Data Storage Areas (trhead, trlines, trother, trsm, trstat, trtrans, trcust) • Index Storage Area (trhead_idx, trlines_idx, trother_idx, trsm_idx, trstat_idx, trtrans_idx, trcust_idx) • Before Image file – nxt.bi, nxt.b1, ... • Log file - nxt.lg • License file - nxt.lic • Lock file – nxt.lk

  8. nxt.bi nxt.b1 nxt.b2 nxt_7.d1 nxt_19.d1 nxt_19.d1 nxt_19.d2 nxt_19.d2 nxt_7.d2 nxt_8.d2 Nxt_8.d2 Version 9 Data Files nxt.db trhead trcust trcust_idx trhead_idx

  9. Version 9 Data Processes • Database: _mprosrv • App Server: _proapsv • Before Image Writer: _mproshut • Asyncrhonous Page Writer: _mproshut • User: _progres • Admin Server: $DLC/jre/…Admin • Name Server: $DLC/jre/…Name

  10. Progress 8 Framework User Database Server Db Application Server Bus Logic

  11. Progress 9 Framework Name Server User Database Server Db Application Server Bus Logic

  12. Progress 9 Framework Admin Server Name Server User Database Server Db Application Server Bus Logic

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

  14. Administration Commands • Historical V8 Commands • proserve, proapsv, proshut • procopy, proutil, prostrct • New V9 Commands • dbman, asbman, proshut • procopy, proutil, prostrct • proadsv, nsman, adaptman • Not all commands are compatible!!! • proserve (default) vs. dbman • old scripts should be modified / checked

  15. SQL/ODBC Access • SQL89 (v8 & v9) • OIBroker • Merant Driver • SQL92 (v9) • New Engine • Progress/Merant Driver • New Security Model

  16. Progress v9 Hints • Dump & Load prior to upgrade • Remember the Operating System • AIX > 4.3.2 • HP/UX > 11.0 • Storage Areas • Useful but not required • Java, Java, Java!!! • Required for ODBC • Helpful for Admin Framework • Version ( AIX = 1.1.8, HP/UX = 1.1.7)

  17. Questions?

More Related