PM46459: DURING LOAD PROCESSING, SQLCODE104 MAY OCCUR IF CREATE TABLE STATEMENT IS LONGER THAN 454 LINES.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• During LOAD processing, while creating a table from the DDFILE,
  negative SQLCODE104 may occur if the CREATE TABLE statement is
  longer than 454 lines and contains a string column after the
  454th line defined with NOT NULL, but without a DEFAULT
  specified.
  In pre-V8 DB2, the SQL statement maximum limit was 32764 bytes.
  This limit forced Log Analysis to break down CREATE TABLE
  statements that exceeded this limit into smaller SQL statements.
  Any NOT NULL string column after the 454th line of the CREATE
  TABLE statement could lead to a negative SQLCODE104 error if the
  column did not specify a DEFAULT value.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Log Analysis Tool.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: During LOAD processing, while creating  *
  *                      a table from the DDFILE, negative       *
  *                      SQLCODE104 may occur if the CREATE      *
  *                      TABLE statement is longer than 454      *
  *                      lines and contains a string column      *
  *                      after the 454th line defined with NOT   *
  *                      NULL, but without a DEFAULT specified.  *
  *                      In pre-V8 DB2, the SQL statement        *
  *                      maximum limit was 32764 bytes. This     *
  *                      limit forced Log Analysis to break      *
  *                      down CREATE TABLE statements that       *
  *                      exceeded this limit into smaller SQL    *
  *                      statements. Any NOT NULL string column  *
  *                      after the 454th line of the CREATE      *
  *                      TABLE statement could lead to a         *
  *                      negative SQLCODE104 error if the        *
  *                      column did not specify a DEFAULT value. *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

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:

  UK74839

Modules/Macros

•    ALAESQL
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R320 PSY UK74839

     UP12/01/04 P F201

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.