PK49118: THE LENGTH OF COLUMN STMT_TEXT IN TABLE DB2PMFAUDT_SQLTEXT IS TOO SHORT (3712) TO HANDLE LARGE SQL STATEMENTS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A LOAD utility gets following error when loading data into the
  table for audit :
   DSNU338I- -DF11 DSNURWBF - INVALID COLUMN SPECIFICATION FOR
  STMT_TEX
   DSNU017I--- DSNUGBAC - UTILITY DATA BASE SERVICES MEMORY
  EXECUTION
   ABENDED, REASON=X'00E40323'
  The table was created referencing the DGOXCSQL.
  MODULE-NAME      = DGOXCSQL
  DESCRIPTIVE-NAME = Sample SQL for creating a DB2 table
  (Audit)
  
  FUNCTION = sample SQL for creating a DB2 table to store
  DB2PM data from the Audit file relating to Authorization
  text
  

Local fix

• Change VARCHAR(3712) to VARCHAR(4000) in  DGOXCSQL
  Recreate the table DB2PMFAUDT_SQLTEXT in a 8K tablespace
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   Batch Reporting                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: Error when loading SQL text longer than *
  *                      3712 bytes into Audit table of          *
  *                      Performance Database.                   *
  *                      Audit Report and Trace do not show SQL  *
  *                      text up to the length of 4000 bytes.    *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  The data model of the Audit table was not suitable to support
  the maximum SQL_TEXT length. For Report/Trace the internal
  buffer is not sufficient.
  

Problem conclusion

• The data model of the Audit table was changed. STMT_TEXT has be
  now as VARCHAR(4000) to be able to support the maximum
  text length. Audit Report and Trace processing has been changed,
  too.
  
  KEYWORDS : AUDIT SQL TEXT VARCHAR LENGTH 3712 4000 PERFORMANCE
             DATABASE TABLE DB2PMFAUDT_SQLTEXT
  

Temporary fix

Comments

APAR Information

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

  PK45730

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

  UK27846 UK27845

Modules/Macros

•    DGOXBASS DGOXBSQL DGOXCREC DGOXCREP DGOXCSQL
  DGOXDSQL DGOXD000 DGOXFSQL DGOXF000 DGOXF001 DGOXF002 DGOXF003
  DGOXF004 DGOXF005 DGOXF006 DGOXF007 DGOXF008 DGOXPCON DGOXR000
  DGOXSPRT DGOXS001 DGOXS002 DGOXS003 DGOXS004 DGOXS005 DGOXS006
  DGOXS007 DGOXT000 DGOXT001 DGOXT002 DGOXT003 DGOXT004 DGOXT005
  DGOXT006 DGOXT007
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R310 PSY UK27845

     UP07/08/08 P F708

• R410 PSY UK27846

     UP07/08/08 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.