PM26385: ZATSI PANEL STOPPED DISPLAYING SQL STMTS AFTER TOTAL COUNT REACH9999

Obtain the fix for this APAR.

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 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

• R420 PSY UK63984

     UP11/01/19 P F101

• R510 PSY UK63985

     UP11/01/19 P F101

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.