PK51791: UNKNOWN ATF ATSI DB2 CALL TYPE CLASSIC SQL INDEX

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Customer sees on Classic tool a DB2 Call Type UNKNOWN on
  APPLICATION TRACE SQL INDEX (ATSI) panel
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   Classic Interface                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: ATF panel ZATSI does display "UNKNOWN"  *
  *                      in the column "Call type"               *
  ****************************************************************
  * RECOMMENDATION: APPLY THIS PTF.                              *
  ****************************************************************
  ATF panel ZATSI does display "UNKNOWN" in the column "Call type"
  

Problem conclusion

• The following call types were flagged as "UNKNOWN" in ZATSI and
  are now showing up properly for the respective DB2 releases
  
  For DB2 V7+:
  ------------
    CREATE ALIAS
    DROP ALIAS
    DECLARE GLOBAL TEMPORARY TABLE (DCL GLOB TEMP TB)
    CREATE FUNCTION
    ALTER FUNCTION
    DROP FUNCTION
    CREATE PROCEDURE
    ALTER PROCEDURE
    DROP PROCEDURE
    CREATE (DISTINCT) TYPE (CREATE TYPE)
    DROP (DISTINCT) TYPE (CREATE TYPE)
    CREATE TRIGGER
    DROP TRIGGER
    CREATE AUXILIARY TABLE
    DROP PACKAGE
    ALTER DATABASE
    CREATE JAR
    DROP JAR
    HOLD LOCATOR
    FREE LOCATOR
  
  For DB2 V8+:
  ------------
    CREATE SEQUENCE
    ALTER SEQUENCE
    DROP SEQUENCE
    ALTER VIEW
  
  For DB2 9:
  ----------
    RENAME INDEX
    CREATE ROLE
    DROP ROLE
    CREATE TRUSTED CONTEXT (CREATE TRUST CTX)
    ALTER TRUSTED CONTEXT (ALTER TRUST CTX)
    DROP TRUSTED CONTEXT (DROP TRUST CTX)
    ALTER JAR
  
  KEYWORDS : ZATSI UNKNOWN
  

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:

  PK51932 UK28707

Modules/Macros

•    KO2ARSBA KO2ARSBS KO2ARSB2 KO2ASUBA KO2ASUBS
  KO2ASUB2
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R410 PSY UK28707

     UP07/08/31 P F708

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.