DB2 - Problem description
Problem IC79237 | Status: Closed |
ADD VMSTAT -P IN DB2COS_PERF ON SOLARIS | |
product: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problem description: | |
In Solaris system, pi/po columns from vmstat include Executable/Anonymous/FileSystem. In AIX/HP and Linux, we check pi/po column for evidence of system paging, however in Solaris, pi/po column shows the number including both process pages and file system pages. So in the current db2fodc code, we only capture "vmstat" output, and the pi/po will be misleading in Solaris since it doesn't only show process paging. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * DB2 * **************************************************************** * PROBLEM DESCRIPTION: * * In Solaris system, pi/po columns from vmstat include * * Executable/Anonymous/FileSystem. In AIX/HP and Linux, we * * check * * pi/po column for evidence of system paging, however in * * Solaris, * * pi/po column shows the number including both process pages * * and * * file system pages. So in the current db2fodc code, we only * * capture "vmstat" output, and the pi/po will be misleading in * * Solaris since it doesn't only show process paging. * **************************************************************** * RECOMMENDATION: * * Upgrade to v95fp9 * **************************************************************** | |
Local Fix: | |
Run vmstat -p manually in Solaris | |
available fix packs: | |
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows | |
Solution | |
In Solaris system, pi/po columns from vmstat include Executable/Anonymous/FileSystem. In AIX/HP and Linux, we check pi/po column for evidence of system paging, however in Solaris, pi/po column shows the number including both process pages and file system pages. So in the current db2fodc code, we only capture "vmstat" output, and the pi/po will be misleading in Solaris since it doesn't only show process paging. | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC80379 IC84195 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 14.10.2011 08.03.2012 08.03.2012 |
Problem solved at the following versions (IBM BugInfos) | |
9.5.FP9 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.5.0.9 |