PM04469: DB2 LOG ANALYSIS TOOL FAST APPLY SQL UNABLE TO HANDLE SOME SQL STATEMENTS WITH ONE VERY LARGE COLUMN STRING

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Log Analysis can output SQL that contain column strings that
  are over 32,000 bytes. If a statement with such a string also
  has long table names and long column names, it is possible for
  Fast Apply SQL to issue a return code of 8 with a "Failed
  parsing SQL statement." message because the input buffer size
  was not large enough for the SQL.
  
  Additionally, variation 9 type log records supporting these
  large SQL stmts may be generated with separate UNDO and REDO log
  records, which required modifications as these log records are
  documented as occurring in one log record only.
  Prior to this modification, a PUT error on the ROWDATA file
  could occur.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Log Analysis Tool.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Log Analysis can output SQL that    *
  *                      contain column strings that are over    *
  *                      32,000 bytes. If a statement with such  *
  *                      a string also has long table names and  *
  *                      long column names, it is possible for   *
  *                      Fast Apply SQL to issue a return code   *
  *                      of 8 with a "Failed parsing SQL         *
  *                      statement." message because the input   *
  *                      buffer size was not large enough for    *
  *                      the SQL.                                *
  *                                                              *
  *                      Additionally, variation 9 type log      *
  *                      records supporting these large SQL      *
  *                      stmts may be generated with separate    *
  *                      UNDO and REDO log records, which        *
  *                      required modifications as these log     *
  *                      records are documented as occurring     *
  *                      in one log record only. Prior to this   *
  *                      modification, a PUT error on the        *
  *                      ROWDATA file could occur.               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Apply the PTF.
  

Problem conclusion

• Apply the PTF.
  

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:

Modules/Macros

•    ALA@FSP
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R310 PSY UK63904

     UP11/01/19 P F101

• R320 PSY UK63905

     UP11/01/19 P F101

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.