PI63408: BATCH ACCOUNTING IMPROVEMENTS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Batch Accounting Improvements:
  1. Field ASYNCH CF REQUESTS TIME/EVENT is not shown up in unit
  of seconds.
  2. Accounting data of threads with QUERY PARALLELISM AND DDF or
  RRSAF is not being processed.
  3. Planname DISTSERV is not being replaced correctly.
  4. A particular joining of Accounting tables is no longer
  possible.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component                           *
  *                 - Batch Reporting                            *
  *                 - PDB                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. ASYNCH CF REQUESTS TIME/EVENT not    *
  *                      shown up in milliseconds.               *
  *                      2. Threads are not processed if they    *
  *                      are QUERY PARALLELISM AND DDF or RRSAF. *
  *                      3. Joining of Accouting Save GENERAL    *
  *                      table and Accounting detail tables      *
  *                      using columns CLIENT_TRANSACTION,       *
  *                      CLIENT_WSNAME, CLIENT_ENDUSER may fail. *
  *                      The reason is that string values        *
  *                      stored in those columns in Accounting   *
  *                      Save GENERAL table exceed the data      *
  *                      type length of corresponding column     *
  *                      definitions in Accounting detail        *
  *                      tables.                                 *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF.                              *
  ****************************************************************
  PROBLEM SUMMARY:
  1. ASYNCH CF REQUESTS TIME/EVENT not
  shown up in milliseconds.
  2. Threads are not processed if they
  are QUERY PARALLELISM AND DDF or RRSAF.
  3. Joining of Accouting Save GENERAL
  table and Accounting detail tables
  using columns CLIENT_TRANSACTION,
  CLIENT_WSNAME, CLIENT_ENDUSER may fail.
  The reason is that string values
  stored in those columns in Accounting
  Save GENERAL table exceed the data
  type length of corresponding column
  definitions in Accounting detail
  tables.
  
  PROBLEM CONCLUSION:
  1. Correct code in order to show ASYNCH CF REQUESTS TIME/EVENT
  in unit of seconds.
  2. Correct code for processing of QUERY PARALLELISM AND DDF or
  of RRSAF data.
  3. Columns CLIENT_EUWN_SHORT, CLIENT_EUTX_SHORT,
  CLIENT_EUID_SHORT added to Accounting meta data for
  Accounting Save GENERAL table.
  For example:
  SELECT *
    FROM DB2PMSACCT_GENERAL,DB2PMSACCT_BUFFER
    WHERE
    ...
    AND DB2PMSACCT_GENERAL.CLIENT_EUTX_SHORT
        = DB2PMSACCT_BUFFER.CLIENT_TRANSACTION
    AND DB2PMSACCT_GENERAL.CLIENT_EUWN_SHORT
        = DB2PMSACCT_BUFFER.CLIENT_WORKSTATION
    AND DB2PMSACCT_GENERAL.CLIENT_EUID_SHORT
        = DB2PMSACCT_BUFFER.CLIENT_ENDUSER
    ...
    ;
  4. TKO2SAMP member DGOAUPDB has been updated with ALTER TABLE
  commands for the new columns.
  
  KEYWORDS:
  ASYNCH CF REQUESTS TIME/EVENT QUERY PARALLELISM DDF
  RRSAF CLIENT_EUWN_SHORT CLIENT_EUTX_SHORT
  CLIENT_EUID_SHORT CLIENT_ENDUSER CLIENT_WSNAME
  CLIENT_TRANSACTION ACCOUNTING GENERAL TABLE JOIN
  

Problem conclusion

• 1. Correct code in order to show ASYNCH CF REQUESTS TIME/EVENT
  in unit of seconds.
  2. Correct code for processing of QUERY PARALLELISM AND DDF or
  of RRSAF data.
  3. Columns CLIENT_EUWN_SHORT, CLIENT_EUTX_SHORT,
  CLIENT_EUID_SHORT added to Accounting meta data for
  Accounting Save GENERAL table.
  For example:
  SELECT *
    FROM DB2PMSACCT_GENERAL,DB2PMSACCT_BUFFER
    WHERE
    ...
    AND DB2PMSACCT_GENERAL.CLIENT_EUTX_SHORT
        = DB2PMSACCT_BUFFER.CLIENT_TRANSACTION
    AND DB2PMSACCT_GENERAL.CLIENT_EUWN_SHORT
        = DB2PMSACCT_BUFFER.CLIENT_WORKSTATION
    AND DB2PMSACCT_GENERAL.CLIENT_EUID_SHORT
        = DB2PMSACCT_BUFFER.CLIENT_ENDUSER
    ...
    ;
  4. TKO2SAMP member DGOAUPDB has been updated with ALTER TABLE
  commands for the new columns.
  

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:

  UI38952

Modules/Macros

• DGOAACUM DGOABORD DGOABORE DGOABSGE DGOACALC DGOACMER DGOACOMP
  DGOACREC DGOACSGE DGOADIST DGOADSGE DGOAEXIT DGOAEX20 DGOAFORM
  DGOAIREC DGOAIREP DGOALSGE DGOAMTRC DGOARCAL DGOAREDB DGOAREDC
  DGOAREDD DGOAREDG DGOAREDI DGOAREDM DGOAREDP DGOAREDR DGOAREDX
  DGOATRAC DGOATREC DGOAUPDB DGOAZMER DGOAZREC DGOBARAL DGOBARDD
  DGOBARLK DGOBARLO DGOBARPK DGOBARPO DGOBARPT DGOBARRI DGOBARRL
  DGOBARSH DGOBARSP DGOBARSQ DGOBARTE DGOBARTM DGOBATAL DGOBATDD
  DGOBATLK DGOBATLO DGOBATPK DGOBATPO DGOBATPT DGOBATRI DGOBATRL
  DGOBATSH DGOBATSP DGOBATSQ DGOBATTM DGOBGENL DGOFPRIC DGORAEXT
  DGORIREP DGORPACC DGORUACC DGORZREP FPEUCBPR
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R530 PSY UI38952

     UP16/06/29 P F606

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.