Fixes are available
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
APAR status
Closed as program error.
Error description
The following views under the SYSIBMADM schema should not be viewable by public MON_BP_UTILIZATION MON_TBSP_UTILIZATION MON_LOCKWAITS MON_PKG_CACHE_SUMMARY MON_CURRENT_SQL MON_CURRENT_UOW MON_SERVICE_SUBCLASS_SUMMARY MON_WORKLOAD_SUMMARY MON_CONNECTION_SUMMARY MON_DB_SUMMARY
Local fix
Revoke SELECT privilege on each view from PUBLIC. Grant SELECT privilege to only those users that need access. By default, DBADM, SQLADM and DATAACCESS have SELECT privilege on these views.
Problem summary
**************************************************************** * USERS AFFECTED: * * All DB2 systems on all Linux, Unix and Windows platforms at * * service levels Version 9.7 Fix Pack 1 * **************************************************************** * PROBLEM DESCRIPTION: * * See error description. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.7 Fix Pack 3 or see "Local Fix" * * portion for other suggestions. * ****************************************************************
Problem conclusion
The complete fix for this problem first appears in DB2 Version 9.7 Fix Pack 3 and all the subsequent Fix Packs.
Temporary fix
Comments
APAR Information
APAR number
IC67819
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
970
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-04-12
Closed date
2010-09-16
Last modified date
2010-09-16
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
IC69495
Fix information
Fixed component name
DB2 FOR LUW
Fixed component ID
DB2FORLUW
Applicable component levels
R970 PSN
UP
Document Information
Modified date:
17 September 2021