PK14195: SQLCODE802 FROM SM OPERATION FOR TABLE SPACE ESTIMATOR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool, using SM command for Space Manager
  function and option 2 in panel adb2m to use Table Space
  Estimator function, can receive sqlcode802 for objects which
  have large cardf values.
  .
  Error occurs when cardf value exceeds integer value, such as:
    1863025, also expressed as: 1.863025000000000E+06
  .
  Panel ADB2MES displays messages: "No rows returned" and
    "No rows were fetched, SQL code=   802"
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of  DB2 Administration Tool,  who      *
  *                 use  Space Manager for Space Estimates,      *
  *                 are affected                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: Using  SM  command  for  Space  Manager *
  *                      function and option 2 in panel ADB2M to *
  *                      use Table Space Estimator function, can *
  *                      receive  SQLCODE802  for  objects which *
  *                      have  large  CARDF values. Error occurs *
  *                      when  CARDF value exceeds integer value *
  *                      .*                                      *
  *                      In  case of DB2 V7,  part  of  a SELECT *
  *                      statement  may have a resultant greater *
  *                      than INTEGER limits.                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  SQLCODE802 was received from SM operation for TABLE SPACE
  ESTIMATOR
  

Problem conclusion

• Apply the fix.
  

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

•    ADB2MESG ADB2MEXG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R510 PSY UK10135

     UP05/12/23 P F512

• R710 PSY UK10136

     UP05/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.