PM98585: CORRUPTED DATA FROM BATCH REPORTING USING FILE WITH AUDIT REPORT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2PE program produces corrupt data
  .
  When running DB2PE Batch reporting program to parse SMF data
  and produce a FILE with AUDIT data on it, the SQL statements are
  corrupted and not fully output to the file.
  .
  //SYSIN    DD *
  GLOBAL
    TIMEZONE(+4)
  INCLUDE(SUBSYSTEMID(DBUP))
  AUDIT
    FILE
      TYPE(ALL)
  EXEC
  .
  Sample SQL from Input Record:
  INSERT INTO AUDTSTDB.AUDTSTT0. .(DPT_ID,{ .DPT_DESC,.
  .DPT_USER_ID,. .
  DPT_ACTIVITY_TSP). .VALUESE )(1,'TEST1','E010692',CURRENT
  TIMESTAMP)
  .
  Sample SQL from Output FILE:
  INSERT INTO AUDTSTDB.AUDTSTT0 (DPT_ID, DPT_DESC,
  DP..............................................................
  ........
  (The periods show as x'00' in hex)
  .
  Some SQL looks fine and other SQL statements get truncated and
  show a bunch of x'00' values on the end.
  .
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component                           *
  *                 - Batch Reporting                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQL text is truncated when it's length  *
  *                      is greater than 256.                    *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  PROBLEM SUMMARY:
  SQL text is truncated when it's length is greater than 256.
  
  PROBLEM CONCLUSION:
  MVCL must be used instead of MVC.
  
  KEYWORDS:
  IFCID361 SQL TEXT AUDIT FILE
  

Problem conclusion

• MVCL must be used instead of MVC.
  
  KEYWORDS:
  IFCID361 SQL TEXT AUDIT FILE
  

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:

  UI13576 UI13577

Modules/Macros

• DGOXF000
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R511 PSY UI13576

     UP13/12/18 P F312

• R520 PSY UI13577

     UP13/12/18 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.