PM91200: WSL CLONE COMMAND FAILS WITH ADBQ901E ERROR INTERPRETING STATEMENT OR COMMAND WITH TYPE OF DB2.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' 'Q - Clone' command on
  panel ADB2W1 'Work Statement List Library' fails with a message:
  SQL stmt not completely parsed
  TOKEN_INDEX=             4;, Token=(
  ADBQ901E: Error interpreting statement or command with TYPE of
  DB2 . The follow
  ing text string was cloned as is with TYPE of ERR :
  -STO PROC(>procname<)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who clone a Work statement list (WSL)   *
  *                 which has STOP PROCEDURE, START PROCEDURE,   *
  *                 STOP FUNCTION SPECIFIC or START FUNCTION     *
  *                 SPECIFIC statements.                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      'Q - Clone' command on panel ADB2W1     *
  *                      'Work Statement List Library' fails     *
  *                      with a message, for example in the case *
  *                      where the WSL contains a -STO PROC      *
  *                      statement:                              *
  *                                                              *
  *                      SQL stmt not completely parsed          *
  *                      TOKEN_INDEX=             4;,            *
  *                      Token=()                                *
  *                      ADBQ901E: Error interpreting            *
  *                      statement or command with TYPE          *
  *                      of DB2. The following text string       *
  *                      was cloned as is with TYPE of ERR:      *
  *                                                              *
  *                      -STO PROC(>procname<)                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Clone WSL does not support the statements.
  

Problem conclusion

• Support has been added for the following DB2 statements:
  
  '-STO PROC(>procname<)'
  '-STA PROC(>procname<)'
  '-STO FUNC SPEC(>func_name<)'
  '-STA FUNC SPEC(>func_name<)'
  

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:

  UK96766 UK96767

Modules/Macros

• ADB2PA4
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK96766

     UP13/08/20 P F308

• RA20 PSY UK96767

     UP13/08/20 P F308

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.