What's new & PDFs
This section summarizes general information provided for the documentation.
To find the most current updates for individual information units and sections presented in this Knowledge Center, refer to:
This page lists the Program Directories and the most current versions of the available product publications including updates to these books. The supported file type is PDF.
What's new in Version 5.4.0
IBM® Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V5.4.0 (5655-W38) delivers day one support for DB2 for z/OS, V12. In addition, this new release rolls up features delivered in the service stream to functions in previous releases of DB2, the IBM DB2 Analytics Accelerator, and various other enhancements requested by clients.
- Support for DB2 12, including key DB2 features like LOB compression, dynamic plan stability, lifted partition limits, and so on
- Updates to DB2 Analytics Accelerator monitoring capabilities
- Removal of the CUA interface to reduce complexity and cost of ownership in the monitoring environment
- Latest update - February 2017
The following recent changes (Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS (PDFs and Techdocs on DB2 Tools Product Page)) have been published in this Knowledge Center:
- ACCTG - Near-term history data collection options keyword: The list of possible values for the near-term history data collection options keyword ACCTG from 1,2,3,7,8,10 to 1,2,3,7,8,10,11.
- Changes to PARMGEN workflow and panel navigation in Installing OMEGAMON XE for DB2 PE from scratch with the most basic configuration, Configuring Near-Term History with system variable support, Configuring InfoSphere Optim Performance Manager and Performance Expert Client, and Completing the configuration for z/OS components.
- The following information has been updated:
- Existing panels and descriptions have been refreshed.
- Migration information has been updated to describe how to migrate to Version 5.4.0.
- Information about how to upgrade in an existing PARMGEN runtime environment to enable support for DB2 12 is described in Basic Upgrade Requirements and SMP/E maintenance and upgrade scenarios.
- Buffer Pool Analyzer is now delivered with IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS only, it is no longer available as a standalone product.
- S System Statistics (KDPSUBSM) has been updated to include DSQL (DB2 Dynamic SQL Cache Filter Options KDPDSQLF).
- Panels and descriptions have been refreshed:
- Changes to the following panels to reflect new wait times in IFCID 316 and 401:
- DB2 12 provides
an improved in-memory buffer pool:
- Buffer Pool Detail (ZBP)
- Buffer Pool Statistics Detail (ZHBPD)
- Fast insert algorithm functionality is now available:
- Thread Detail (ZTDTL)
- Package Detail (ZPDK)
- Thread History Detail (ZHTACT)
- Thread History Package Detail (ZHTPKD)
- DB2
supports the ability to stabilize and reuse the runtime structures for dynamic SQL:
- Current SQL Counts (ZTSCNT)
- Thread History SQL Counts (ZHTSQLS)
- EDM Pool Information (ZEDMP)
- EDM Pool Statistics Detail (ZHEDD)
- EDM Snapshot Dynamic SQL Cache Statement Statistics Detail (ZEDD3)
- DB2 Command Statistics (ZCMDS)
- DB2 Command Statistics Detail (ZHCMD)
- SQL/RID Pool/Parallelism/Stored Procedure Information (ZSQLC)
- SQL/RID Pool/I/O Parallelism Statistics Detail (ZHSQD)
- Changes
to DSNZPARM panels to support DB2 12:
- DSNZPARM Thread Parameters (ZPSYS)
- DSNZPARM Logging Parameters (ZPLOG)
- DSNZPARM Authorization, RLF and DDF Parameters (ZPCTL)
- DSNZPARM Storage Parameters (ZPSTL)
- DSNZPARM Data set and Database Parameters (ZPDSN)
- DSNZPARM Data Sharing Parameters (ZPSHR)
- DSNZPARM Utility Parameters (ZPUTL)
- DSNZPARM Data Parameters (ZPDAT)
- DSNZPARM Performance and Optimization Parameters (ZPPFM)
- New class 3 wait thread status:
- Thread analysis - changes to:
- DSQL/SSQL summary panels now display accelerator eligibility and DPS flags:
- Existing block samples and descriptions have been refreshed.
- OMEGAMON XE for DB2 PE version 5.4 supports DB2 10 or later. References to DB2 9 have been removed.
- The following sections of the SQL Activity Report and Trace Blocks have been updated:
- The following IFCID descriptions have been updated:
- IFCID 001 - DB2 Command Data
- IFCID 001 - DDF Data by Location
- IFCID 001 - QVLS Data
- IFCID 002 - Accelerator Data - Accelerator Perspective V4 or later
- IFCID 002 - Accelerator Data - Prior to V4
- IFCID 002 - Buffer Pool Activity
- IFCID 002 - Data Manager Data
- IFCID 002 - Data Sharing Locking Data
- IFCID 002 - Dynamic SQL Statement
- IFCID 002 - EDM Pool Data
- IFCID 002 - Locking Data
- IFCID 002 - Group Buffer Pools Activity Data
- IFCID 002 - Miscellaneous
- IFCID 002 - Query Parallelism
- IFCID 002 - RID List Processing
- IFCID 002 - Service Controller Data
- IFCID 003 - Buffer Manager Accounting Data
- IFCID 003 - DDF Data by Location
- IFCID 003 - Dynamic SQL Statement
- IFCID 003 - Initial Client/Server Correlation Data
- IFCID 003 - Instrumentation Accounting Data
- IFCID 003 - Instrumentation Accounting Data Overflow
- IFCID 003 - Locking Data
- IFCID 006 - Read I/O Start
- IFCID 007 - Read I/O Stop
- IFCID 018 - Scan End
- IFCID 021 - Lock Detail
- IFCID 029 - EDM Request Start
- IFCID 030 - EDM Request End
- IFCID 044 - Lock Suspend
- IFCID 053 - SQL Describe/Commit/Rollback/Remote Statement
- IFCID 058 - End SQL
- IFCID 062 - DDL Start
- IFCID 106 - Data Sharing Parameters
- IFCID 106 - Distributed Data Facility Parameters
- IFCID 106 - Log Initialization Parameters (Part 1)
- IFCID 106 - Miscellaneous Installation Parameters
- IFCID 106 - System Initialization Parameters
- IFCID 127 - Page Wait I/O In Prog (Start)
- IFCID 128 - Page Wait I/O In Prog (End)
- IFCID 147 - Data Sharing Accounting Data
- IFCID 147 - Distributed Header Data
- IFCID 147 - Instrumentation Accounting Data
- IFCID 147 - Instrumentation Accounting Data Overflow
- IFCID 147 - Logging
- IFCID 147 - Monitor Detail Data
- IFCID 147 - Thread Correlation Data
- IFCID 150 - Lock Resource Data
- IFCID 172 - Deadlock Header
- IFCID 172 - Unit of Work - Resource
- IFCID 196 - Timeout Header
- IFCID 198 - Buffer Manager Page Access
- IFCID 202 - Buffer Pool Attributes
- IFCID 217 - Storage Manager Pool Statistics
- IFCID 217 - Agent Local Storage Pool Sizes
- IFCID 223 - Lock Avoidance Detail
- IFCID 225 - Address Space Summary - DIST
- IFCID 225 - IRLM Pool Statistics
- IFCID 226 - Page Latch Contention Start
- IFCID 227 - Page Latch Contention End
- IFCID 239 - Buffer Manager Accounting Data
- IFCID 239 - Locking Data
- IFCID 239 - Package/DBRM Accounting Data
- IFCID 305 - Table Check Constraint
- IFCID 316 - SQL Statement Statistics
- IFCID 346 - Package/DBRM Detail
- IFCID 369 - Aggregated Accounting Statistics
- IFCID 376 - Incompatible Functions Executed
- IFCID 390 - IBM Service Record (new)
- IFCID 391 - IBM Service Record (new)
- IFCID 401 - Static Statements in EDM Pool
- IFCID 404 - IBM Service Record (new)
- IFCID 413 - Beginning of Wait for Pipe Suspend (new)
- IFCID 414 - End of Wait for Pipe Suspend (new)
- The following descriptions of System Parameters reports have been updated:
- Application Programming Defaults Panel 1 (DSNTIPF)
- Application Programming Defaults Panel 2 (DSNTIP4, DSNTIP41)
- Alter Buffer Pool Command Issued
- Buffer Pool Parameters
- Buffer Pool Parameters (DSNTIP1)
- DB2 Catalog and Directory Panel (DSNTIPA2)
- DB2 Utilities Parameters (DSNTIP6, DSNTIP61, DSNTIP62)
- DB2 Version Install (DSNTIPA1)
- Define Group or Member (DSNTIPK)
- Distributed Data Facility Panel 1 (DSNTIPR)
- Example of the System Parameters Report
- Install DB2 - Resource Limit Facility (DSNTIPO4) (DB2 12) (new for DB2 12)
- IRLM Installation Parameters (DSNTIPI)
- Lock Escalation Parameters (DSNTIPJ)
- Operator Functions Installation Parameters (DSNTIPO)
- Other System Parameters
- Performance and Optimization (DSNTIP8, DSNTIP81)
- Query Accelerator Preferences (DSNTIP82)
- Routine Parameters (DSNTIPX)
- Sizes Panel 1 (DSNTIPD)
- SQL Object Defaults Panel (DSNTIP7, DSNTIP71, DSNTIP72)
- SQL Object Defaults Panel (DSNTIP7, DSNTIP71, DSNTIP72)
- Storage Sizes Installation Parms (DSNTIPC, DSNTIPE, DSNTIPE1)
- Tracing, Checkpoint & Pseudo-Close Parameters (DSNTIPN)
- Workfile Database Panel (DSNTIP91)
- The following descriptions of Accounting report and trace blocks have been updated:
- Accounting Trace - Long
- Accounting Trace - Short
- Accounting Report - Long
- Accounting Report - Short
- Buffer Pool Activity
- Distributed Activity - Requester
- Distributed Activity Requester (Short Report)
- Distributed Activity Requester (Short Trace)
- Distributed Activity - Server
- Distributed Activity Server (Short Report)
- Distributed Activity Server (Short Trace)
- Dynamic SQL Statement (new)
- General (Short Report)
- General (Short Trace)
- Highlights - Report
- Highlights - Trace
- Initial DB2 Common Server or Universal JDBC Driver Correlation
- Initial DB2 Common Server Correlation
- Locking
- Times - Class 2 - DB2 Time
- Times - Class 3 - Suspensions
- Package Buffer Pool Activity - Class 10
- Package Locking Activity - Class 10
- Package Times - Class 8 - Suspensions
- Query Parallelism
- RID List
- The following descriptions of Statistics report and trace blocks have been updated:
- Accelerator Data - Prior to Version 4
- Accelerator Data - Version 4 or later
- Aggregated Accounting Statistics
- Buffer Pool General
- Buffer Pool Read
- Buffer Pool Write
- DB2 Commands
- DBM1 and MVS Storage Below 2 GB
- DIST and MVS Storage Below 2 GB
- DRDA Remote Locations
- Dynamic SQL Statement
- EDM Pool Activity
- Group Buffer Pool Activity
- Latch Counters
- Locking Activity
- Open/Close Activity
- Query Parallelism
- RID List Processing
- Workfile Database
- The following sections have been updated:
- Several samples have been updated.
- Using ACCOUNTING REDUCE subcommand options to balance performance and data set space has been updated because the OPTIMIZE subcommand option is no longer supported for the ACCOUNTING REDUCE command.
- Update of the sample in Creating a System Parameters report.
- The following sections have been updated:
- ACCOUNTING command with REDUCE subcommand has been updated because the OPTIMIZE subcommand option is no longer supported for the ACCOUNTING REDUCE command.
- The following sections are updated:
- The TOP subcommand option supports a new keyword MAXWRKF:
- The description of the following sections provide migration updates:
- In OMEGAMON XE for DB2 PE, DB2 9 is no longer supported.
- Online Monitor field table has been updated.
- The following main menu functions are not supported for DB2 11 or later:
- Display Thread Activity (option 3.1)
- Display Statistics (option 3.2)
- Display System Parameters (option 3.3)
- Buffer Pool Analyzer messages
- Updated messages:
- Accounting report set messages (FPEA)
- Updated message: FPEA0801S
- Online Monitor messages (FPEM)
- Updated message: FPEM138
- Data Server messages (FPEV)
- Migrate/Convert function messages (FPEZ)
- New messages:
- VTAM Display Logic messages (KO2O)
- New message:
- OMEGAMON PE Subsystem messages (KO2Z)