A fix is available
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 number
PM67084
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-06-18
Closed date
2012-08-28
Last modified date
2012-09-05
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
05 September 2012