PI18410: DB2 ADMIN RETURNS SQLCODEN406 PANEL ADB2314T TS MAINTENANCE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS returns SQLCODEN406 when using
  'Table Space maintenance recommendations' panel ADB2314T
  DSNT408I SQLCODE = -406, ERROR:  A CALCULATED OR DERIVED NUMERIC
  VALUE IS NOT WITHIN THE RANGE OF ITS OBJECT COLUMN
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use Table Space maintenance         *
  *                 recommendations.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: When entering option '14 - Table Space  *
  *                      maintenance recommendations' on panel   *
  *                      ADB23 'DB2 Performance Queries', and    *
  *                      on panel ADB2314T 'Input Parameters     *
  *                      for Real-Time Statistics' to get Table  *
  *                      Space maintenance recommendations,      *
  *                      then pressing the ENTER key, DB2 Admin  *
  *                      fails with a SQLCODE=-406 /             *
  *                      SQLCODEN406:                            *
  *                                                              *
  *                      DSNT408I SQLCODE = -406,                *
  *                      ERROR:  A CALCULATED OR                 *
  *                      DERIVED NUMERIC VALUE                   *
  *                      IS NOT WITHIN THE RANGE OF              *
  *                      ITS OBJECT COLUMN                       *
  *                      DSNT418I SQLSTATE   = 22003             *
  *                      SQLSTATE RETURN CODE                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When entering option '14 - Table Space maintenance
  recommendations' on panel ADB23 'DB2 Performance Queries',
  and on panel ADB2314T 'Input Parameters for Real-Time
  Statistics' to get Table Space maintenance recommendations,
  then pressing the ENTER key,  DB2 Admin fails with a
  SQLCODE=-406 / SQLCODEN406.
  

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:

  UI24424 UI24425

Modules/Macros

•    ADB2314T
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI24424

     UP15/01/18 P F501

• RB10 PSY UI24425

     UP15/01/18 P F501

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.