PK58666: ZSTPT ZRRSAT GARBAGE STORED PROCDURES/UDF NAME, PKGNAME, AUTHID

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 1.Incorrect udf and stored procedure name on ZSTPT/ZRRSAT panels
  and Enclave Information For a Thread workspace
  2.Incorrect thread pkgname and authid fields displayed when
  subsystem has UIFCID=YES
  3. trigger data is not displayed on ZTRIGT
  4. trigger count is not correct on System Status workspace
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   Common Collector                         *
  *                 -   Tivoli Enterprise Monitoring Agent       *
  *                 -   Classic Interface                        *
  *                 -   CUA Interface                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1.Incorrect udf and stored procedure    *
  *                      name on ZSTPT/ZRRSAT panels and         *
  *                      Detailed Thread Exception workspace     *
  *                      2.Incorrect thread pkgname and authid   *
  *                      fields displayed when subsystem has     *
  *                      UIFCID=YES                              *
  *                      3. Trigger data is not displayed on     *
  *                      ZTRIGT                                  *
  *                      4. Trigger count is not correct on      *
  *                      System Status workspace                 *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  PROBLEM SUMMARY:
  1. Schema and stored procedure/UDF name are not
  populated correctly from control block
  2. No Unicode conversion for pkgname and authid
  3,4. Threads with triggers are not identified
  
  PROBLEM CONCLUSION:
  1. Use IFCID 148 to populate UDF and stored procedure data.
  2. Convert pkgname and authid if subsystem is in Unicode
  3,4. Correctly identify threads with triggers
  

Problem conclusion

• 1. Use IFCID 148 to populate UDF and stored procedure data.
  2. Convert pkgname and authid if subsystem is in Unicode
  3,4. Correctly identify threads with triggers
  
  KEYWORDS :
  INCORROUT UDF STORED PROCEDURE TRIGGER ZSTPT ZTSOU ZBACKU ZENCU
  ZICLU PACKAGE NAME AUTHID ACTIVE TRIGGER COUNT SYSTEM STATUS
  WORKSPACE DETAILED THREAD EXCEPTION WORKSPACE
  

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:

  UK34408

Modules/Macros

•    KO2CDFSA KO2CDFSS KO2CDFS2 KO2CTHAA KO2CTHAS
  KO2CTHA2 KO2CTHSA KO2CTHSS KO2CTHS2 KO2CTH1A KO2CTH1S KO2CTH12
  KO2CTH5A KO2CTH5S KO2CTH52 KO2CTH6A KO2CTH6S KO2CTH62 KO2CTH9A
  KO2CTH9S KO2CTH92 KO2CT2IA KO2CT2IS KO2CT2I2 KO2OTHBB KO2OTHXB
  KO2XTHSA KO2XTHSS KO2XTHS2
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R410 PSY UK34408

     UP08/03/12 P F803

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.