PM99280: DISCREPANCY IN ACCT TRACES OUTPUT WHEN USING INCL(PLANNAME) VS INCL(PACKAGE). LONG NAME HANDLING IN BATCH SQLACTIVITY REPORTS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Accounting trace produces different output for INCLUDE(PLANNAME)
  and INCLUDE(PACKAGE) commands
  
  === <CASE1 : INCLUDE(PLANNAME(SG5O613))>
  =============================
  GLOBAL
      FROM (08/10/13,11:49:48.00)
      TO   (08/10/13,11:51:03.00)
      INCLUDE(PLANNAME(SG5O613))
  ACCOUNTING
      TRACE
      LAYOUT(LONG)
  .
  EXEC
  ---- IDENTIFICATION ----------------------------------
  ACCT TSTAMP: 08/10/13 11:50:02.51    PLANNAME: SG5O613
  BEGIN TIME : 08/10/13 11:49:48.82    PROD TYP: N/P
  END TIME   : 08/10/13 11:50:02.51    PROD VER: N/P
  REQUESTER  : LOCDBPG                 CORRNAME: SG5O613
  MAINPACK   : PYFD031A                CORRNMBR: 0004
  PRIMAUTH   : T1S4540A                CONNTYPE: IMS-MPP
  ORIGAUTH   : T1S4540A                CONNECT : IM11
  .
  PGSSP22                   TOTAL    PG5O613
  TOTAL
  -------------------    --------    -------------------
  --------
  BPOOL HIT RATIO (%)          53    BPOOL HIT RATIO (%)
  -9
  GETPAGES                     15    GETPAGES
  333185
  BUFFER UPDATES                0    BUFFER UPDATES
  0
  SYNCHRONOUS WRITE             0    SYNCHRONOUS WRITE
  0
  SYNCHRONOUS READ              7    SYNCHRONOUS READ
  1548
  SEQ. PREFETCH REQS            0    SEQ. PREFETCH REQS
  0
  LIST PREFETCH REQS            0    LIST PREFETCH REQS
  0
  DYN. PREFETCH REQS            0    DYN. PREFETCH REQS
  11361
  PAGES READ ASYNCHR.           0    PAGES READ ASYNCHR.
  363526
  
  
  === <CASE2 : INCLUDE(PACKAGE(PG*))>
  =================================
  GLOBAL
      FROM (08/10/13,11:49:48.00)
      TO   (08/10/13,11:51:03.00)
      INCLUDE(PACKAGE(PG*))
  ACCOUNTING
      TRACE
      LAYOUT(LONG)
  EXEC
  .
  ACCT TSTAMP: 08/10/13 11:50:02.51    PLANNAME: SG5O613
  BEGIN TIME : 08/10/13 11:49:48.82    PROD TYP: N/P
  END TIME   : 08/10/13 11:50:02.51    PROD VER: N/P
  REQUESTER  : LOCDBPG                 CORRNAME: SG5O613
  MAINPACK   : PYFD031A                CORRNMBR: 0004
  PRIMAUTH   : T1S4540A                CONNTYPE: IMS-MPP
  ORIGAUTH   : T1S4540A                CONNECT : IM11
  .
  PGSSP22                   TOTAL    PG5O613
  TOTAL
  -------------------    --------    -------------------
  --------
  BPOOL HIT RATIO (%)          -9    BPOOL HIT RATIO (%)
  55
  GETPAGES                 333185    GETPAGES
  9
  BUFFER UPDATES                0    BUFFER UPDATES
  0
  SYNCHRONOUS WRITE             0    SYNCHRONOUS WRITE
  0
  SYNCHRONOUS READ           1548    SYNCHRONOUS READ
  4
  SEQ. PREFETCH REQS            0    SEQ. PREFETCH REQS
  0
  LIST PREFETCH REQS            0    LIST PREFETCH REQS
  0
  DYN. PREFETCH REQS        11361    DYN. PREFETCH REQS
  0
  PAGES READ ASYNCHR.      363526    PAGES READ ASYNCHR.
  0
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component                           *
  *                 - Batch Reporting                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Invalid assignment of Class 10       *
  *                         package detail BUFFERPOOL IDs to     *
  *                         data in Batch ACCOUNTING.            *
  *                      2. FILTERING for PACKAGE does not work  *
  *                         correctly for Batch ACCOUNTING.      *
  *                      3. Missing support of long CLIENT       *
  *                         ENDUSER and other fields in          *
  *                         SQLACTIVITY.                         *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  PROBLEM SUMMARY:
  1. Invalid assignment of Class 10 package detail BUFFERPOOL
     IDs to data in Batch ACCOUNTING.
  2. FILTERING for PACKAGE does not work correctly for Batch
     ACCOUNTING.
  3. Missing support of long CLIENT ENDUSER and other fields
     in SQLACTIVITY.
  
  PROBLEM CONCLUSION:
  The filtering code for PACKAGE has been changed for Batch
  Accounting.
  Long names in the CLIENT ENDUSER INFO fields ENDUSER, WSNAME,
  and TRANSACT cause a correct indication by '>' in Batch
  SQLACTIVITY TRACE and REPORT, and the long names are shown
  completely after the data block where the value is truncated.
  Same for PRIMAUTH and ORIGAUTH long names.
  
  KEYWORDS:
  CLASS 10 PACKAGE DETAILS BUFFERPOOL ID FILTERING
  CLIENT ENDUSER INFO ENDUSER WSNAME TRANSACT PRIMAUTH
  ORIGAUTH
  

Problem conclusion

• PROBLEM CONCLUSION:
  The filtering code for PACKAGE has been changed for Batch
  Accounting.
  Long names in the CLIENT ENDUSER INFO fields ENDUSER, WSNAME,
  and TRANSACT cause a correct indication by '>' in Batch
  SQLACTIVITY TRACE and REPORT, and the long names are shown
  completely after the data block where the value is truncated.
  Same for PRIMAUTH and ORIGAUTH long names.
  
  KEYWORDS:
  CLASS 10 PACKAGE DETAILS BUFFERPOOL ID FILTERING
  CLIENT ENDUSER INFO ENDUSER WSNAME TRANSACT PRIMAUTH
  ORIGAUTH
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  PM97502

• APAR is sysrouted TO one or more of the following:

  UI13091

Modules/Macros

•    DGOAACUM DGOABORD DGOABORE DGOACALC DGOACMER
  DGOACOMP DGOACREC DGOADIST DGOAEXIT DGOAEX20 DGOAFORM DGOAIREC
  DGOAIREP DGOAMTRC DGOARCAL DGOAREDB DGOAREDC DGOAREDD DGOAREDG
  DGOAREDI DGOAREDM DGOAREDP DGOAREDR DGOAREDX DGOATRAC DGOATREC
  DGOAZMER DGOAZREC DGOBGENL DGOFPDAT DGOFPRIC DGORAEXT DGORASCN
  DGORCREC DGORCREP DGORCRE2 DGORDIST DGORINEX DGORIREC DGORIREP
  DGOROADB DGORPACC DGORPCAP DGORPHIL DGORPHVA DGORPIND DGORPMIN
  DGORPPAR DGORPPKG DGORPRID DGORPRNT DGORPSCA DGORPSOR DGORPSUM
  DGORPUDF DGORQE15 DGORRCAP DGORRCOM DGORRDAT DGORRDDF DGORREXI
  DGORRHIL DGORRHVA DGORRIOA DGORRLOC DGORRMIS DGORRSOR DGORRSQL
  DGORRTHR DGORSRBY DGORUACC DGORUIND DGORUSUM DGORUWRK DGORZREC
  DGORZREP DGOTABRB DGOTAEOF DGOTAEXT DGOTAFPP DGOTAPVA DGOTARAD
  DGOTATRC DGOTAUTY DGOTAWKL DGOTBBRB DGOTBFMT DGOTBFPP DGOTBPRT
  DGOTBRAD DGOTBUTY DGOTBWKL DGOTCCHK DGOTCCOP DGOTCDIV DGOTCLOD
  DGOTCRCO DGOTCREB DGOTCREC DGOTCREO DGOTCREP DGOTCULD DGOTDIST
  DGOTINEX DGOTIREC DGOTIREP DGOTPBND DGOTPFMT DGOTPPHA DGOTPRNT
  DGOTPUPH DGOTQIEX DGOTQKEY DGOTZREC DGOTZREP FPECMDAT FPEUCBPR
  FPEUCXIE
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R520 PSY UI13091

     UP13/12/03 P F312

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.