PM72154: ALT SQLCODEN104 DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL """". WHEN REMOVING COLUMN FROM TABLE AND PRIMARY KEY.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' ALT command built a
  CREATE TABLE statement with an invalid PRIMARY KEY clause
  resulting in a SQLCODE -104 / SQLCODEN104 error:
  sqlerror on CREATE     command, PREPARE    function
   DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL """". SOME
  SYMBOLS THAT MIGHT
            BE LEGAL ARE: <IDENTIFIER>
  DSNT418I SQLSTATE   = 42601 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNHSMUD SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = 13  0  0  -1  594  502 SQL DIAGNOSTIC
  INFORMATION
  DSNT416I SQLERRD    = X'0000000D'  X'00000000'  X'00000000'
  X'FFFFFFFF'
           X'00000252'  X'000001F6' SQL DIAGNOSTIC INFORMATION
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the 'Alter Table ALT' (ALT)     *
  *                 function to delete a column and the column   *
  *                 is the first column in the primary key       *
  *                 definition of the table.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Administration Tool for z/OS,    *
  *                      when using the ALT function to delete   *
  *                      a column from a table, and the column   *
  *                      is the first column in the primary key  *
  *                      of the table, the ALT APPLY job failed  *
  *                      with RC8 / return code 8 and an         *
  *                      SQLCODEN104 / SQLCODE = -104:           *
  *                                                              *
  *                      DSNT408I SQLCODE = -104,                *
  *                         ERROR:  ILLEGAL SYMBOL """".         *
  *                         SOME SYMBOLS THAT MIGHT              *
  *                         BE LEGAL ARE: >IDENTIFIER<.          *
  *                      ADB5185E The run is ending due to       *
  *                      errors.                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In DB2 Administration Tool for z/OS, when deleting a column
  which is the first column within the primary key definition of
  the table, the ALT APPLY job failed to apply changes and fails
  with a RC8 / return code 8 and SQLCODEN104 /
  SQLCODE = -104 because an illegal symbol """"  was
  found in the primary key definition.
  

Problem conclusion

• Problem has been resolved.
  Additionally, when using the ALT function to delete multiple
  columns from a table, including the column which is the last
  one in the primary key definition, the user may receive an
  ADBC200E error:
  
  ADBC200E Internal error.
     Max prim key seq  = #key cols
  
  This problem will be addressed in APAR PM78162.
  

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

•    ADBCCMM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK90401

     UP12/12/19 P F212

• RA20 PSY UK90402

     UP12/12/19 P F212

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.