| Autore |
Bruni Paolo
|
| Edizione | [1st ed.] |
| Pubbl/distr/stampa |
[San Jose, Calif.], : IBM, International Technical Support Organization, 2002
|
| Descrizione fisica |
1 online resource (150 p.)
|
| Disciplina |
005.75/65
|
| Altri autori (Persone) |
DuboisFlorence
NacamatsuClaudio
|
| Collana |
Redbooks
|
| Soggetto topico |
Database management
|
| Formato |
Materiale a stampa  |
| Livello bibliografico |
Monografia |
| Lingua di pubblicazione |
eng
|
| Nota di contenuto |
Front cover -- Contents -- Figures -- Tables -- Examples -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Chapter 1. Introduction -- 1.1 Evolution of DB2 V7 -- 1.2 Contents of this redbook -- Chapter 2. FICON -- 2.1 Description -- 2.2 Performance measurement environment -- 2.3 Performance measurement results -- 2.3.1 DB2 transaction workload -- 2.3.2 DB2 logging -- 2.3.3 DB2 queries -- 2.3.4 DB2 utilities -- 2.3.5 Summary -- 2.4 VSAM striping -- Chapter 3. Enhanced Instrumentation Facility -- 3.1 DBM1 storage monitoring -- 3.1.1 z/Architecture and DB2 for z/OS -- 3.1.2 Storage manager pool statistics -- 3.1.3 DB2 PM statistics report: DBM1 storage statistics -- 3.1.4 DB2 PM record trace: storage manager pool summary -- 3.2 Other new IFCIDs -- 3.2.1 IFCID 0234 -- 3.2.2 IFCID 0334 -- 3.3 Changed IFCIDs -- 3.4 DB2 PM workstation interface enhancements -- 3.4.1 New Workstation Online Monitor functions -- 3.4.2 The Performance Warehouse function -- Chapter 4. Java support -- 4.1 JDBC and SQLJ -- 4.1.1 JDBC overview -- 4.1.2 SQLJ overview -- 4.2 SQLJ versus JDBC -- 4.2.1 Reasons to use SQLJ -- 4.2.2 Reasons to use JDBC -- 4.2.3 SQLJ and JDBC inter-operability -- 4.3 Enhancements to JDBC/SQLJ driver -- 4.4 Guidelines for high performance when using JDBC/SQLJ -- 4.4.1 Design guidelines for applications -- 4.4.2 Identifying the system levels -- 4.4.3 Environment tuning -- 4.5 Analyzing performance -- 4.6 Performance results -- 4.6.1 WebSphere Application Server -- 4.6.2 Summary -- Chapter 5. CICS interface -- 5.1 CICS TS V2.2 -- 5.2 Tuning the CICS/DB2 attachment -- 5.2.1 Architecture -- 5.2.2 Monitoring -- 5.2.3 Performance and tuning considerations -- 5.2.4 Conclusion -- 5.3 CICS/DB2 attachment in CICS TS V2.2 -- 5.3.1 OTE -- 5.3.2 Group attach -- 5.3.3 Usability enhancement.
5.3.4 RMI PURGE enhancement -- 5.3.5 Other DB2 complementary functions -- Chapter 6. Real time statistics -- 6.1 Description -- 6.2 Enabling RTS on your system -- 6.3 How real time statistics work -- 6.3.1 Create real time statistics objects -- 6.3.2 Set interval for writing statistics -- 6.3.3 Start the real time statistics database -- 6.4 Operation considerations -- 6.4.1 When real time statistics are externalized -- 6.4.2 When real time statistics are updated -- 6.4.3 Real time statistics and DB2 utilities -- 6.4.4 Real time statistics and non-DB2 utilities -- 6.4.5 Real time statistics in data sharing -- 6.4.6 Accuracy of the statistics -- 6.5 DSNACCOR stored procedure -- 6.6 Performance considerations -- Chapter 7. DB2 OLAP Server on zSeries -- 7.1 DB2 OLAP Server introduction -- 7.2 V1.1 to V7.1 performance comparisons -- 7.2.1 Measurement environment -- 7.2.2 Measurement results -- 7.3 Throughput and scalability measurements -- 7.3.1 Measurement environment -- 7.3.2 Measurement results -- 7.4 Summary -- Appendix A. Recent performance and availability maintenance -- A.1 DB2 for OS/390 V5 APARs -- A.2 DB2 for OS/390 V6 APARs -- A.3 DB2 for OS/390 V7 APARs -- A.4 DB2 PM V7 -- A.5 SDK -- A.6 OS/390 and z/OS APARs -- Abbreviations and acronyms -- Related publications -- IBM Redbooks -- Other resources -- Referenced Web sites -- How to get IBM Redbooks -- IBM Redbooks collections -- Index -- Back cover.
|
| Record Nr. | UNINA-9910820961603321 |
Info
DB2 for z/OS DM and OS/390 Version 7 [[electronic resource] ] : selected performance topics / / [Paolo Bruni, Florence Dubois, Claudio Nacamatsu]
