PK31476: WSL CLONE FUNCTION RC16 MSGADBQ901E TOKEN =ADD FOR ALTER INDEX ADD COLUMN STATEMENT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool Q CLONE WSL feature fails RC16 with
  signal error and msgispt034 msgadbq901e similar to the
  following:
  .
  FUNCTION = ADB2W1QB , LINE 337 : signal error
  RC       = 16
  ZERRMSG  = ISPT034
  ZERRSM   = User error
  ZERRLM   = One or more statements not  successfully cloned.  If
             new work stmt list  XY01001Z  was created, it is
             incomplete.
  ISPD117  The initially invoked CLIST ended with a return code =
           16
  ...
  Invalid token after IER071A0  in CREATE INDEX statement --
  Error occured when parsing the following stmt :
  .
    ALTER INDEX OA1A.IER071A0..  ADD COLUMN (ER07103 ASC)
  .
  Token number = 00006, Token =ADD
  ADBQ901E: Error interpreting statement or command with TYPE of
            DDL .
            The following text string was cloned as is with TYPE
            of ERR :
    ALTER INDEX OA1A.IER071A0..  ADD COLUMN (ER07103 ASC)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool, who        *
  *                 use WSL CLONE, may be affected.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: WSL CLONE function encounters RC 16 and *
  *                      message  ADBQ901E  TOKEN =ADD FOR ALTER *
  *                      INDEX ADD COLUMN STATEMENT              *
  *                      .*                                      *
  *                      The Q CLONE WSL feature fails RC16 with *
  *                      signal error and MSGISPT034 MSGADBQ901E *
  *                      .*                                      *
  *                      NFM  syntax for  ALTER INDEX ADD COLUMN *
  *                      fails. Other WSL CLONE supports  of NFM *
  *                      NFM syntax may fail as well.            *
  *                      .* Note:                                *
  *                      The following syntax have been added or *
  *                      updated:                                *
  *                      ALTER INDEX .. ADD COLUNM               *
  *                      ALTER INDEX .. CLUSTER                  *
  *                      ALTER TABLE .. VOLATILE/NOT VOLATILE    *
  *                      optional COLUMN word in ALTER TABLE..   *
  *                      ADD COLUMN                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Apply the fix.
  

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

•    ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK20897

     UP06/12/30 P F612

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.