PM67084: RUNSTATS . SYSTABLEPART IS MISSING IN SAMP MEMBER ADBRUNSV

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• RUNSTATS . SYSTABLEPART is missing in SAMP member ADBRUNSV
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the 'UR - Update Runstats'   *
  *                      line command to update RUNSTATS on      *
  *                      panel ADB21SPH 'SYSTABLEPART Hist for   *
  *                      table_space', the following error       *
  *                      message is displayed:                   *
  *                                                              *
  *                      'Object does not exist'                 *
  *                                                              *
  *                      After creating RUNSTATS.SYSTABLEPART,   *
  *                      then executing the UPDATE RUNSTATS      *
  *                      statement on panel ADB21SPH             *
  *                      'Update RUNSTATS information',          *
  *                      a SQLCODE=-151 / SQLCODEN151            *
  *                      error is displayed:                     *
  *                                                              *
  *                      DSNT408I SQLCODE = -151 ERROR: THE      *
  *                               UPDATE OPERATION IS INVALID    *
  *                               BECAUSE THE CATALOG            *
  *                               DESCRIPTION OF COLUMN          *
  *                               RUNSTATS.SYSTABLEPART.SPACE    *
  *                               INDICATES THAT IT CANNOT BE    *
  *                               UPDATED                        *
  *                      DSNT418I SQLSTATE = 42808 SQLSTATE      *
  *                               RETURN CODE                    *
  *                      DSNT415I SQLERRP = DSNXOST SQL          *
  *                               PROCEDURE DETECTING ERROR      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using the 'UR - Update Runstats' line command to update
  RUNSTATS on panel ADB21SPH 'SYSTABLEPART Hist for table_space',
  the following error message is displayed:
  
  'Object does not exist'
  
  After creating RUNSTATS.SYSTABLEPART, then executing the UPDATE
  RUNSTATS statement on panel ADB21SPH 'Update RUNSTATS
  information', a SQLCODE=-151 / SQLCODEN151 error is displayed:
  
  DSNT408I SQLCODE = -151 ERROR: THE
           UPDATE OPERATION IS INVALID
           BECAUSE THE CATALOG
           DESCRIPTION OF COLUMN
           RUNSTATS.SYSTABLEPART.SPACE
           INDICATES THAT IT CANNOT BE
           UPDATED
  DSNT418I SQLSTATE = 42808 SQLSTATE
           RETURN CODE
  DSNT415I SQLERRP = DSNXOST SQL
           PROCEDURE DETECTING ERROR
  

Problem conclusion

• SAMP library member ADBRUNSV has been changed to add the
  missing create RUNSTATS.SYSTABLEPART statement.
  
  Panel ADB21SPU has been modified to show the column that has
  been updated.
  
  To resolve the following problem:
  When using the 'UR - Update Runstats' line command to update
  RUNSTATS on panel ADB21SPH 'SYSTABLEPART Hist for table_space',
  the following error message is displayed:
  
  'Object does not exist'.
  
  Run SAMP lib member ADB2RUNSV, which contains the
  following DDL:
  
  CREATE VIEW RUNSTATS.SYSTABLEPART AS
     SELECT *
       FROM SYSIBM.SYSTABLEPART
     WHERE IXCREATOR IN(CURRENT SQLID, USER)
      WITH CHECK OPTION;
  
    GRANT SELECT,UPDATE
       ON TABLE RUNSTATS.SYSTABLEPART TO PUBLIC;
  

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:

  UK81366

Modules/Macros

•    ADBRUNSV ADBRUN01 ADB21SPU
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK81366

     UP12/08/30 P F208

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.