A fix is available
APAR status
Closed as program error.
Error description
In panel ZATSI, omegamon stops displaying more SQL statements when the total count reaches 9999. For example: ================================================================ > APPLICATION TRACE SQL INDEX ATSI + Planname=DB2001 Connid=BATCH Corrid=D88LIST + + Call Type Stm# Program Count InDB2 Time MRet Rws Pc + ---------------- ----- -------- ----- ------------ ---- ------ + OPEN CURSOR 1065 DB2001 1 00:00.00001 0 0 + FETCH 1141 DB2001 1 00:00.00039 100 0 + CLOSE CURSOR 1068 DB2001 1 00:00.00001 0 0 + OPEN CURSOR 1071 DB2001 1 00:03.64083 0 16372 + FETCH 1203 DB2001 9995 00:05.62353 0 9995 . ---- stops after total = 9999
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM * * users of component: * * - Classic Interface * **************************************************************** * PROBLEM DESCRIPTION: ZATSI PANEL STOPPED DISPLAYING SQL * * STMTS AFTER TOTAL COUNT REACH 9999. * * * **************************************************************** * RECOMMENDATION: Apply this PTF * * * **************************************************************** PROBLEM SUMMARY: CHECK ON MAXIMUM SQL STATEMENTS IS REMOVED. PROBLEM CONCLUSION: CODE CHANGED TO FIX THIS PROBLEM.
Problem conclusion
CODE CHANGED TO FIX THIS PROBLEM. KEYWORDS: INCORROUT ZATSI PANEL 9999 LIMIT
Temporary fix
Comments
APAR Information
APAR number
PM26385
Reported component name
OM XE DB2PE/PM
Reported component ID
5655OPE00
Reported release
420
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2010-11-09
Closed date
2011-01-17
Last modified date
2017-02-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK63984 UK63985
Modules/Macros
KO2ARSBA KO2ARSBS KO2ARSB2 KO2ARS0A KO2ARS0K KO2ARS02
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"420"}]
Document Information
Modified date:
30 March 2021