A fix is available
APAR status
Closed as new function.
Error description
In DB2 V11 CM , DB2 Admin Tool V11 doesn't allow to alter the bufferpool variables SPSIZE nor SPSEQT. SPSIZE and SPSEQT were added to DB2 V11 by APAR PI22091. Up to now it's not possible to specfiy these options in ALTER BUFFER POOL panel ADB2ZBA8 of DB2 Administration Tool.
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool for * * z/OS who use Alter Buffer Pool with DB2 11 * * for z/OS. * **************************************************************** * PROBLEM DESCRIPTION: DB2 11 for z/OS added two new options * * SPSIZE and SPSEQT for the ALTER * * BUFFERPOOL command, but DB2 Admin * * did not list options SPSIZE and * * SPSEQT on panel ADB2ZBA2 'Alter * * Buffer Pools' and ADB2ZBA8 'Alter * * Buffer Pool'. * **************************************************************** * RECOMMENDATION: * **************************************************************** DB2 11 for z/OS added two new options SPSIZE and SPSEQT for the ALTER BUFFERPOOL command, but DB2 Admin did not list options SPSIZE and SPSEQT on panel ADB2ZBA2 'Alter Buffer Pools' and ADB2ZBA8 'Alter Buffer Pool'.
Problem conclusion
Temporary fix
Comments
The following are delivered: 1. Add a primary command called 'VIEW' on panel ADB2ZBA2. Column SPSIZE and SPSEQT are displayed by issuing the primary command 'VIEW' on panel ADB2ZBA2. 2. Add option SPSIZE and SPSEQT on panel ADB2ZBA8. 3. Remove column VPXPSEQT from panel ADB2ZBA2, and remove option VPXPSEQT from panel ADB2ZBA8, since VPXPSEQT is obsolete starting with DB2 11 for z/OS. 4. Add the following for panel columns on help panel ADBHZBA2 'HELP: Alter Buffer Pools' as below. Panel Explanation: The table display panel shows the attributes that you can alter on buffer pools. The panel columns are: VPSIZE The buffer pool size. VPSIZEMIN The minimum size for the buffer pool. VPSIZEMAX The maximum size for the buffer pool. AUTOSIZE Specifies whether the buffer pool adjustment is turned on or off. No - Specifies that DB2 does not use Workload Manager (WLM) services for automatic buffer pool size adjustment. This value is the default. Yes - Specifies that DB2 uses WLM services, if available, to automatically adjust the buffer pool size as appropriate. FRAMESIZE The frame size for the buffer pool. Possible values are 2G,1M,or 4K. PGFIX Whether the buffer pool is fixed in real storage when it is used. YES - The buffer pool is fixed in real storage. YES also indicates that the PGFIX value for the current allocation (Current value) and the value for the next allocation (Pending value) are the same. NO - The buffer pool is not fixed in real storage. NO also indicates that the PGFIX value for the current allocation and the value for the next allocation are the same. YES* - Indicates that the PGFIX value for the current allocation is NO but the value for the next allocation is YES. The Pending value YES will be displayed in the PGFIX field on the following panel after entering an AL line command on a buffer pool. NO* - Indicates that the PGFIX value for the current allocation is YES but the value for the next allocation is NO. The Pending value NO will be displayed in the PGFIX field on the following panel after entering an AL line command on a buffer pool. PGSTEAL The page-stealing algorithm that DB2 uses for the buffer pool. The initial default is PGSTEAL(LRU). LRU - Specifies that the buffer pool buffers are managed according to the rules of a least recently used (LRU) algorithm. FIFO - Specifies that the buffer pool buffers are managed according to the rules of a first-in-first-out (FIFO) algorithm. This option reduces the cost of maintaining the information about which buffers are least-recently used. NONE - Specifies that no page stealing occurs if the buffer pool is large enough to contain all assigned open objects. Under this option, DB2 pre-loads the buffer pools when the objects are opened. VPSEQT The sequential steal threshold for the buffer pool. The value of integer must be 0 - 100. VPPSEQT The parallel sequential threshold for the buffer pool. The valid values range is 0 - 100. DWQT The buffer pool's deferred write threshold. The valid values range is 0 - 90. VDWQT The buffer pool's vertical deferred write threshold. Vertical DWQT, integer1: The vertical deferred write threshold for the buffer pool. The valid values range is 0 - 90. Vertical DWQT, integer2: The vertical deferred write threshold for the buffer pool. The value of integer-2 can range from 0-9999. The default value is 0. SPSIZE The simulated buffer pool size. SPSEQT The sequential steal threshold for the simulated buffer pool. The value must be between 0 and 100. Valid line commands: AL - Alter buffer pool attributes. DIS - Display buffer pool incremental statistics. Valid commands: VIEW - Display SPSIZE and SPSEQT.
APAR Information
APAR number
PI48358
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
B10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2015-09-09
Closed date
2015-12-14
Last modified date
2016-01-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI33781 UI33782
Modules/Macros
ADBHZBA2 ADB2Z ADB2ZBA ADB2ZBA2 ADB2ZBA8
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
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":"11.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 January 2016