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

Format:

Book

Author/Creator:

Bruni, Paolo.

Contributor:

Dubois, Florence.

Nacamatsu, Claudio.

Series:

IBM redbooks.

Redbooks

Language:

English

Subjects (All):

Database management.

IBM Database 2.

OS/390.

z/OS.

Physical Description:

1 online resource (150 p.)

Edition:

1st ed.

Place of Publication:

[San Jose, Calif.] : IBM, International Technical Support Organization, 2002.

Language Note:

English

System Details:

text file

Summary:

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.

Contents:

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.

Notes:

"November 2002."

"SG24-6894-00."

Includes bibliographical references (p. 119-121) and index.

OCLC:

560315682