PI21635: DB2 ADMINISTRATION TOOL FOR Z/OS WHEN PROCESSING LONG VARCHAR COLUMN RESULTS IN IBM0342S ONCODE=340 SIZE CONDITION MESSAGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS when processing long
  VARCHAR column results in IBM0342S ONCODE=340
  The SIZE condition was raised message instead of clear
  explanation of the problem
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison           *
  *                 Tool for z/OS and DB2 Administration         *
  *                 Tool for z/OS.                               *
  ****************************************************************
  * PROBLEM DESCRIPTION: When the user runs Compare, the source  *
  *                      or target DDL contains a CREATE TABLE   *
  *                      statement and specify an invalid        *
  *                      length for the VARCHAR type.            *
  *                                                              *
  *                      For a new table, the user specified     *
  *                      a column as:                            *
  *                                                              *
  *                      REC_DATA   VARCHAR(100000) NOT NULL     *
  *                                                              *
  *                      The compare job fails with Oncode=      *
  *                      340 / ONCODE340:                        *
  *                                                              *
  *                      Error occurred processing DDL           *
  *                      statement                               *
  *                                                              *
  *                      Length of stmt:    142                  *
  *                      1   CREATE TABLE                        *
  *                          >schema<.>table_name<               *
  *                      (LOG_TID TIMESTAMP NOT NULL,            *
  *                      REC_DATA                                *
  *                      73   CHAR(100000) NOT NULL,             *
  *                      col2 CHAR(1) NOT NULL) IN               *
  *                      >dbname<.>tsname<                       *
  *                      An ONCODE condition  340 has            *
  *                      been detected from location             *
  *                      CATREC_COLDEF..                         *
  *                      IBM0342S ONCODE=340  The SIZE           *
  *                      condition was raised.                   *
  *                      From entry point CATREC_COLDEF          *
  *                      at statement 10918 at compile unit      *
  *                      offset >offset< at entry offset         *
  *                      >offset< at address >address<.          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When the user runs Compare, the source or target DDL contains a
  CREATE TABLE statement and specify an invalid length for the
  VARCHAR type.
  

Problem conclusion

• Problem has been resolved.
  
  When the source or target DDL contains a CREATE TABLE statement
  and specify an invalid length for VARCHAR type, the Compare
  job will fail with RC=8 / Return Code 8 and issue a new error
  message ADB7776E / msgadb7776e:
  
  ADB7776E
  The length specification of the VARCHAR string is invalid.
  
  Explanation:
  The length attribute of the VARCHAR string must be between
  1 and 32704.
  
  System action
  Processing stops.
  
  User response
  Fix the DDL with supported SQL statements and try the
  operation again.
  

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:

  UI25927 UI25928

Modules/Macros

•    ADBCDTS  ADB7000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI25927

     UP15/03/17 P F503

• RB10 PSY UI25928

     UP15/03/17 P F503

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.