PI41504: DB2 ADMIN TOOL SCROLLING THROUGH PACKAGE DETAILS (PANEL ADBPD) ENDS WITH A CEEDUMP

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• While scrolling through Package Details (Panel ADBPD) ends with
  a CEEDUMP.   Before abend, these messages were displayed:
  
    SQL stmt not completely parsed
     ADB2PA: The following statement could not be parsed :
     EXECUTE DYNSQL0 USING DESCRIPTOR : H FOR H ROWS
     Token number =      8, Token = :
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who use the 'DET - Package          *
  *                 details' line command to see package         *
  *                 details on panel ADB21K 'Packages'           *
  *                 and the package contains an 'EXECUTE         *
  *                 statement_name USING DESCRIPTOR              *
  *                 host_variable FOR host_variable              *
  *                 ROWS' statement.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the 'DET - Package details'  *
  *                      line command on a package, while        *
  *                      scrolling through panel ADBPD 'Details  *
  *                      for object(s)', a CEE3845I error is     *
  *                      observed:                               *
  *                                                              *
  *                      CEE3845I CEEDUMP Processing             *
  *                      started.                                *
  *                      PLIDUMP was called from statement       *
  *                      number 2562 at offset >offset< from     *
  *                      TOKEN_VALUE with entry address          *
  *                      >address<                               *
  *                      Information for enclave ADBMAIN         *
  *                                                              *
  *                      and before the abend, the following     *
  *                      messages were displayed:                *
  *                                                              *
  *                        SQL stmt not completely parsed        *
  *                         ADB2PA: The following statement      *
  *                         could not be parsed :                *
  *                         EXECUTE DYNSQL0 USING                *
  *                        DESCRIPTOR : H FOR H ROWS             *
  *                         Token number =      8, Token = :     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When scrolling on panel ADBPD a parser error is displayed.
  

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:

  UI29923

Modules/Macros

•    ADB2PA   ADB2PA3
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI29923

     UP15/08/06 P F508

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.