PH03241: DB2 ADMIN TOOL - PANEL ADB23 "PERFORMANCE QUERIES" OPTION 2 GETSSQLCODE -802

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When specifying Option 2 - "Table spaces with more than 10
  percent relocated rows" on panel ADB23 "Performance Queries",
  SQLCODE -802 / SQLCODEN802 may be returned.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLCODE=-802 / SQLCODEN802 when         *
  *                      specifying Option 2 - "Table spaces     *
  *                      with more than xx percent relocated     *
  *                      rows" on panel ADB23 "Performance       *
  *                      Queries".                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  SQLCODE=-802 is caused by a calculation overflow for large
  relocated rows.
  
  SQLCODE : -802 DSNTIAR CODE : 0
  
  DSNT408I SQLCODE = -802, ERROR: EXCEPTION ERROR FIXED POINT
  OVERFLOW HAS OCCURRED DURING MULTIPLICATION OPERATION
  ON INTEGER DATA, POSITION
  DSNT418I SQLSTATE = 22003 SQLSTATE RETURN CODE
  

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:

  UI60215 UI60216

Modules/Macros

•    ADB23
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI60215

     UP18/12/14 P F812

• RC10 PSY UI60216

     UP18/12/14 P F812

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.