Altering group buffer pools
You can alter the information for group buffer pools that are in Db2 data sharing.
Procedure
-
On the DB2 Administration Menu
(ADB2) panel, specify
Z, and press Enter.
The System Administration (ADB2Z) panel is displayed.
-
Specify option GA, and press Enter.
The Alter Group Buffer Pools (ADBPZGA2) panel is displayed, as shown in the following figure.
Figure 1. Alter Group Buffer Pools (ADBPZGA2) panel ADBPZGA2 ------------ DB2X Alter Group Buffer Pools ------- Row Command ===> Scr Line commands: AL - Alter buffer pool DIS - Display buffer pool GBP GBP GBP GBP Sel Name Cache Autorec Ratio Classt1 Classt2 Poolt Chkpt * * * * * * * * --- -------- ----- ------- ----- ------- -------- ----- ------ GBP0 YES Y 5 89 32766 30 4 GBP1 YES Y 5 5 1000 30 4 GBP2 YES Y 5 5 10000 30 4 GBP3 YES Y 5 5 0 30 4 GBP4 YES Y 5 5 0 30 4 GBP5 YES Y 5 5 0 30 4 GBP6 YES Y 5 5 0 30 4 GBP7 YES Y 5 5 0 30 4 GBP8 YES Y 5 5 0 30 4 GBP9 YES Y 5 5 0 30 4 GBP10 YES Y 5 5 0 30 4
The following columns are available on this panel:
- Sel
- Input field where you enter one of the line commands that are listed on the panel.
- GBPName
- Group buffer pool name.
- GBPCache
- Shows the pending group buffer pool cache attribute. The value Yes indicates that the group buffer pool is used for both caching and cross-invalidation.
- Autorec
- Indicates whether automatic recovery is specified for the group buffer pool.
- Classt1
- Shows a percentage that indicates the degree to which data entries fill the data pages in the group buffer pool.
- GBPPoolt
- Displays the castout threshold for a group buffer pool. When the threshold is met, the data in the group buffer pool is cast out to disk.
- GBPChkpt
- Shows the checkpoint interval for a group buffer pool.
-
Choose one group buffer pool, and specify the line command AL in the
Sel column.
The Alter Group Buffer Pools (ADBPZGA8) panel is displayed, as shown in the following figure.
Figure 2. Alter Group Buffer Pools (ADBPZGA8) panel ADBPZGA8 ----------------- DB2A Alter Group Buffer Pool ---------------- 23:57 Command ===> -ALTER GROUPBUFFERPOOL Name . . . . . . . . . . GBP3 > (GBP0-49, GBP8K0-9, GBP16K0-9, GBP32K-9 or structure name) GBPCACHE . . . . . . . . YES (Yes/No) AUTOREC . . . . . . . . Y (Yes/No) RATIO . . . . . . . . . 5 (1.0-255) CLASST1 . . . . . . . . 5 (0-90) CLASST2 . . . . . . . . 0 (0-32767) GBPOOLT . . . . . . . . 30 (0-90) GBPCHKPT . . . . . . . . 4 (1-999999)
- Optional: Change the group buffer pool parameters.
The following fields are available on this panel for you to alter:
- Name
- Group buffer pool name.
- GBPCache
- Specifies whether group buffer pool is to be used for both caching data and cross-invalidation, or just for cross-invalidation.
- Autorec
- Specifies whether automatic recovery by Db2 takes place when a structure failure occurs, or when the connectivity to all members of the group buffer pool is lost.
- Classt1
- A percentage of the number of data entries and can be an integer 0 - 90, inclusive. The default is 5.
- Classt2
- An absolute number of pages.
- GBPPoolt
- The threshold at which data in the group buffer pool is cast out to disk.
- GBPChkpt
- Changes the time interval, in minutes, between successive checkpoints of the group buffer pool.
- Press Enter to run the ALTER GROUPBUFFERPOOL command.
The Statement Execution Prompt (ADB2PSTM) panel is displayed.
Figure 3. Statement Execution Prompt (ADB2PSTM) panel ADB2PSTM --------------- DB2A Statement Execution Prompt --------------- 23:59 Option ===> 1 DB2 Admin is about to execute the statement below. You have asked to be prompted before DB2 Admin executes this type of statement. What do you want to do now: 1 - Execute the statement 2 - Edit the statement 3 - Create a batch job with the statement 4 - Add the statement to the work statement list CAN - Cancel Work statement list dsn ===> 'SYSADM.AANECM.WSL' Work statement list name ===> C0000001 Action ===> A (Append or Replace) More: + Statement that is about to be executed (first 28 lines): -ALTER GROUPBUFFERPOOL(GBP3) GBPCACHE(NO) AUTOREC(NO) RATIO(3.14) CLASST (55,22222) GBPOOLT(66) GBPCHKPT(149527)
- After the command runs, return to the Alter Group Buffer Pools (ADBPZGA2) panel to see the changes that you made.