PM68774: DB2 ADMINISTRATION TOOL FOR Z/OS ENCOUNTERS SQLCODE = -199 AKA SQLCODEN199 DURING ALTER OPERATION OF FK (FOREIGN KEY) OF TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS encounters SQLCODE = -199 aka
  SQLCODEN199 during ALTer operation of FK (Foreign Key) of table
  .
  The following error panel is displayed:
  .
  ADB2E1 in --------------------- DB2 Error Display 1
  ---------------------
  Command ===>
  Rollback done
     SQLCODE : -199                           DSNTIAR CODE :  0
  .
  DSNT408I SQLCODE = -199, ERROR:  ILLEGAL USE OF KEYWORD ORDER.
  TOKEN
           <ERR_STMT> <WNG_STMT> GET SQL SAVEPOINT HOLD FREE
  ASSOCIATE WAS
           EXPECTED
  DSNT418I SQLSTATE   = 42601 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNHPARS SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = 2  0  0  -1  5  506 SQL DIAGNOSTIC
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Alter (ALT) command on      *
  *                 panel ADB21TFK 'Foreign Keys of Table'.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Administration Tool for z/OS,    *
  *                      when using the ALT command to alter a   *
  *                      foreign key on panel ADB21TFK, the      *
  *                      alter failed with a                     *
  *                      SQLCODE -199 / SQLCODEN199:             *
  *                                                              *
  *                      DSNT408I SQLCODE = -199,                *
  *                      ERROR:  ILLEGAL USE OF                  *
  *                      KEYWORD ORDER.  TOKEN                   *
  *                      >ERR_STMT< >WNG_STMT<                   *
  *                      GET SQL SAVEPOINT HOLD FREE             *
  *                      ASSOCIATE WAS  EXPECTED                 *
  *                      DSNT411I SQLCAID    = SQLCAL            *
  *                      SQLCA IDENTIFIER                        *
  *                      DSNT418I SQLSTATE   = 42601             *
  *                      SQLSTATE RETURN CODE                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In DB2 Administration Tool for z/OS, when using ALT command
  to alter a foreign key on the foreign keys panel (ADB21TFK),
  the alter failed with a SQLCODE -199 / SQLCODEN199:
  
  DSNT408I SQLCODE = -199,
  ERROR:  ILLEGAL USE OF KEYWORD ORDER.  TOKEN
           >ERR_STMT< >WNG_STMT< GET SQL SAVEPOINT
           HOLD FREE ASSOCIATE WAS EXPECTED
  DSNT411I SQLCAID    = SQLCAL SQLCA IDENTIFIER
  DSNT418I SQLSTATE   = 42601 SQLSTATE RETURN CODE
  

Problem conclusion

• Problem has been resolved.
  

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:

  UK82094 UK82093

Modules/Macros

•    ADB27CAA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK82093

     UP12/09/27 P F209

• RA20 PSY UK82094

     UP12/09/27 P F209

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.