DB2 for z/OS DM and OS/390 Version 7 selected performance topics
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 thes...
| Autor principal: | |
|---|---|
| Otros Autores: | , |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
[San Jose, Calif.] :
IBM, International Technical Support Organization
2002.
|
| Edición: | 1st ed |
| Colección: | IBM redbooks.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627474506719 |
Tabla de Contenidos:
- 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.
