PI45215: DB2 ADMIN DET COMMMAND FOR PKG ABEND SOC1 / ONCODE8091 AFTER HITTING PF8 KEY.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS when using DET commmand for a
  package on Panel ADB21K and scroll down with PF8 key may result
  in Abend S0C1 when displaying details of package and message
  msgIBM0531S (IBM0531S) ONCODE=8091  Operation  exception
  From entry point FORMATSQLSTMT at statement nnnn at compile
  unit offset +xxxxx at entry offset +xxxxx
  at address  xxxxxx
  

Local fix

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 6197 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 6197 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

• ž**** PE15/12/08 PTF IN ERROR. SEE APAR PI51949  FOR DESCRIPTION
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI30638

Modules/Macros

•    ADBDK
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI30638

     UP15/08/29 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.