DB2 for z/OS DM and OS/390 Version 7 : selected performance topics / / [Paolo Bruni, Florence Dubois, Claudio Nacamatsu]

• Autore: Bruni Paolo
• Pubblicazione: [San Jose, Calif.], : IBM, International Technical Support Organization, 2002
• Edizione: 1st ed.
• Descrizione fisica: 1 online resource (150 p.)
• Disciplina: 005.75/65
• Soggetto topico: Database management
• Altri autori: DuboisFlorence NacamatsuClaudio
• Note generali: "November 2002."; "SG24-6894-00."
• Nota di bibliografia: Includes bibliographical references (p. 119-121) and index.
• 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.
• Sommario/riassunto: Performance measurements are ongoing during the life of each release of DB2 for OS/390. DB2 for z/OS and OS/390 Version 7 (DB2 V7 throughout this document) has introduced several enhancements in the areas of performance and availability, and other enhancements are currently being added. Most of these enhancements and the related performance measurements implemented in the Silicon Valley Laboratory have been documented in the IBM Redbooks publication DB2 for z/OS and OS/390 Version 7 Performance Topics, SG24-6129. However, information on new DB2 functions and their synergy with the evolving zSeries platform is of great value for strategic investments, and more performance measurements are under way. Currently these measurements have included topics such as FICON, Java support, CICS interface, and DB2 OLAP Server. This book is meant to provide an update on the new measurements that have been implemented, and to point out the performance related maintenance that has been shipped after general availability of DB2 for z/OS Version 7. The information here contained is intended to help managers and professionals understand and evaluate the applicability to their environment of these recent functions of DB2 V7. This book replaces the IBM Redpaper that was made available in February 2002, with the same title, and provides more up-to-date information.
• Titolo autorizzato: DB2 for z
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Lingua di pubblicazione: Inglese
• Record Nr.: 9910820961603321
• Lo trovi qui: Univ. Federico II
• Serie: IBM redbooks.