PI51949: DB2 ADMIN TOOL COMMAND DET PANELID ADBPD GETS IBM0531S ONCODE=8091 FROM ENTRY POINT FORMATSQLSTMT 15/12/08 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When issuing the 'DET - Package
  details' line command against a
  package on panel ADB21K
  'Packages', the user encounters an
  ONCODE 8091 / ONCODE8091
  condition error when scrolling
  down to see the SQL statements of the
  package:
  
  IBM0531S ONCODE=8091  Operation
  exception
  
     From entry point FORMATSQLSTMT
  at statement 6197 at compile unit
  offset >offset< at entry offset
  >offset< at address >address<.
  
  and an ABENDS0C1 error:
  
  Abend 0C1000 hex occurred processing
  command 'DSN     '
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who issue the 'DET - Package details'   *
  *                 line command to display a detailed report    *
  *                 on packages.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: When issuing the 'DET - Package         *
  *                      details' line command against a         *
  *                      package on panel ADB21K 'Packages',     *
  *                      the user encounters an ONCODE 8091 /    *
  *                      ONCODE8091 condition error when         *
  *                      scrolling down to see the SQL           *
  *                      statements of the package:              *
  *                                                              *
  *                      IBM0531S ONCODE=8091  Operation         *
  *                      exception                               *
  *                                                              *
  *                         From entry point FORMATSQLSTMT       *
  *                      at statement >statement< at compile     *
  *                      unit offset >offset< at entry offset    *
  *                      >offset< at address >address<.          *
  *                                                              *
  *                      and an ABENDS0C1  error:                *
  *                                                              *
  *                      Abend 0C1000 hex occurred processing    *
  *                      command 'DSN     '.                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When issuing the 'DET - Package details' line command
  against a package on panel ADB21K 'Packages', the user
  encounters an ONCODE 8091 / ONCODE8091 condition error
  when scrolling down to see the SQL statements of the
  package:
  
  IBM0531S ONCODE=8091  Operation exception
  
   From entry point FORMATSQLSTMT at statement >statement< at
  compile unit offset  >offset< at entry offset >offset< at
  address >address<.
  
  and an ABENDS0C1 error:
  
  Abend 0C1000 hex occurred processing command 'DSN     '.
  

Problem conclusion

• The problem has been resolved. The user should be able to see
  the package details, including SQL statements without error.
  

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:

  UI33974

Modules/Macros

•    ADBDK
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI33974

     UP15/12/23 P F512

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.