PQ75113: PANEL ADB21XA ALTER INDEX ERROR CONDITION WAS RAISED ZERRMSG ADB252S PROGRAM IS STOPPED DUE TO AN INTERNAL ERROR ONCODE = 9

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 'ERROR' condition was raised
  Traceback of user routines:
  Compile Unit   Entry          Statement  CU offset   Entry
  offset  Address
  ADBMAIN        CHECK_SCANVARS 3214       +0001BEAA   +00000C96
  1C2C8F72
  ADBMAIN        DISPLAY_TABLE  2787       +00017F8C   +00000E68
  1C2C5054
  ADBMAIN        SELECT_STMT    2350       +00013610   +00000D4C
  ...
  Zerrmsg: ADB252S
  Zerrsm : Program Error
  Zerrlm : Program is stopped due to an internal error, oncode= 9
  ...
  Above errors were encountered after an ALTER INDEX from Storage
  Management.
  

Local fix

• Use ALTER from somewhere else in ADMIN or SQL
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 ADMIN TOOL who use panel        *
  *                 ADB21XA may be affected.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: An 'ERROR' condition was raised:        *
  *                      Zerrmsg: ADB252S                        *
  *                      Zerrsm : Program Error                  *
  *                      Zerrlm : Program is stopped due to      *
  *                               an internal error, oncode= 9   *
  *                      Above errors were encountered after an  *
  *                      ALTER INDEX from Storage Management     *
  *                      ( panel ADB21XA ).                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  PANEL ADB21XA ALTER INDEX ERROR CONDITION WAS RAISED ZERRMSG
  ADB252S PROGRAM IS STOPPED DUE TO AN INTERNAL ERROR ONCODE = 9
  

Problem conclusion

• The reported problem is fixed in panel ADB21XP .
  

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

•    ADB21XP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R410 PSY UQ77809

     UP03/06/20 P F306

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.