PH02763: INCORRECT LONG ENDUSER, WSNAME AND TRANSACTION IN LOAD DATA TO PDB

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Customer is running Accounting REDUCE SAVE - Convert. The
  resulting load data does not have valid values for the long
  fields.
  
  CLIENT_ENDUSER POSITION(947) VARCHAR,
  CLIENT_WSNAME POSITION(1597) VARCHAR,
  CLIENT_TRANSACTION POSITION(1337) VARCHAR,
  which are the long fields for these fields
  CLIENT_EUID_SHORT POSITION(181) CHAR(16),
  CLIENT_EUWN_SHORT POSITION(197) CHAR(18),
  CLIENT_EUTX_SHORT POSITION(215) CHAR(32))
  
  This affects the following performance database tables
  SACCT_BUFFER, SACCT_DDF and SACCT_GBUFFER
  
  DB2_REL DB2 Release value incorrect in accounting table
  

Local fix

• apply PTF when available
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2 PM                *
  *                 users of components                          *
  *                 - Batch Reporting                            *
  *                 - PDB                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. ACCOUNTING REDUCE SAVE / CONVERT     *
  *                      failed to provide CLIENT_ENDUSER,       *
  *                      CLIENT_WSNAME, CLIENT_TRANSACTION long  *
  *                      values for PDB tables SACCT_BUFFER,     *
  *                      SACCT_DDF and SACCT_GBUFFER.            *
  *                                                              *
  *                      2. ACCOUNTING REDUCE SAVE / CONVERT     *
  *                      produces incorrect DB2_REL value for    *
  *                      Db2 V12 data.                           *
  *                                                              *
  *                      3. AUDIT REPORT may encounter ABEND0C4  *
  *                      in FPEUFLN2 due to processing an        *
  *                      invalid IFCID 145 record.               *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  1. The PDB tables SACCT_BUFFER, SACCT_DDF and SACCT_GBUFFER have
  empty CLIENT_ENDUSER, CLIENT_WSNAME, CLIENT_TRANSACTION columns.
  This is due to the data not being properly externalized to the
  file.
  
  2. The DB2_REL value for Db2 V12 data may either be empty or
  have an incorrect value in ACCOUNTING SAVE / CONVERT PDB tables
  due to a CONVERT utility code defect.
  
  3. An ABEND0C4 in FPEUFLN2 may occur during AUDIT REPORT
  processing when an IFCID 145 record that is missing its QW0145
  data section is processed.
  

Problem conclusion

• Code changed to correctly externalize CLIENT_ENDUSER,
  CLIENT_WSNAME, CLIENT_TRANSACTION column contents and to set
  the correct DB2_REL value for Db2 V12 records.
  
  A check was added to ignore invalid IFCID 145 records and print
  a FPEC4220W message indicating an invalid record was bypassed.
  
  Search Keywords:
  INCORROUT BATCH ACCOUNTING SAVE CONVERT PDB ABEND0C4 IFCID145
  

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:

  UI60045

Modules/Macros

• DGOAREDC DGOAREDX DGONTRAC DGOPACNV DGOXCREC FPECHATS FPECHE15
  FPEUMSGS
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R540 PSY UI60045

     UP18/12/04 P F812

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.