PK29872: WSL CLONE FUNCTION RC=16 MESSAGE ADBQ901E TOKEN =DECIMAL FOR ALT ER STATEMENT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool Q CLONE WSL feature fails RC=16 with
  message:
  Invalid token after SET DATA TYPE clause - expected VARCHAR,
  CHARACTER, or CHAR keywords
  ADBQ901E: Error interpreting statement or command with TYPE of
  DDL. The following text string was cloned as is with TYPE of
  ERR :
  ALTER TABLE aaa.aaa ALTER aaa SET DATA TYPE DECIMAL(xx,x)
  .
  Additional symptoms: rc16 msgADBQ901E msgISPD117 ADB2W1QB
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users  of  DB2 Administration Tool, who      *
  *                 use WSL CLONE function, may be affected.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The CLONE  WSL  function  failed with a *
  *                      RC=16 and message:  Invalid token after *
  *                      SET DATA TYPE clause - expected VARCHAR *
  *                      CHARACTER, or CHAR keywords.            *
  *                      .*                                      *
  *                      The CLONE  WSL  function  failed with a *
  *                      RC=16 and message:  ADBQ901E for "ALTER *
  *                      TABLE  OA1A.TER011A1  ALTER ER01107 SET *
  *                      DATA TYPE DECIMAL(15, 8)"               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  WSL CLONE function failed with RC=16 and message ADBQ901E.
  

Problem conclusion

• Parser problem for ALTER TABLE ALTER column-alteration has
  been fixed.
  

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:

  UK18366 UK18367

Modules/Macros

•    ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R510 PSY UK18366

     UP06/10/05 P F610

• R710 PSY UK18367

     UP06/10/05 P F610

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.