DSNZPARM Buffer Pool Parameters
This panel shows information about the parameters that affect Db2 buffer pool default settings. It shows the name of the DSNZPARM module that is specified for Db2 startup and the date on which the module is assembled. It also shows a list of the default values of the Db2 application.
If a field is not available for the current Db2 release, the string N/A is displayed. For other conditions, for example,
if specific Db2 traces are not started or control block data
is not available, the string N/P is displayed.
________________ ZPBPL VTM O2 V540./C DB11 S 10/11/12 22:06:37 2
> Help PF1 Back PF3 Left PF10 Right PF11
> R.H.P
> DSNZPARM INFORMATION: Enter a selection letter on the top line.
> A-THREAD B-TRACE C-LOGGING D-ARCHIVING E-AUTH/RLF/DDF F-IRLM
> G-STORAGE H-DATASET I-DDCS J-DATA SHARING K-STORED PROC L-UTIL
> M-APPL N-DATA O-PERF *-BUFFERPOOL Q-OTHERS
===============================================================================
> BUFFERPOOL DSNZPARM PARAMETERS
ZBPL
+ Collection Interval: REALTIME SNAPTIME: 10/11/12 20:00:20.56
+
+ DSNZPARM Module DSNZPARM
+ Assembly Date 10/10/12
+ Initial Module DSNZPARM
+ Assembly Date 10/10/12
+ Previous Module DSNZPARM
+ Assembly Date 10/10/12
+
+ DSNTIP1-Buffer Pools
+------------------------------------
+ 4KBP for User Data (TBSBPOOL) BP2
+ 8KBP for User Data (TBSBP8K) BP8K0
+ 16KBP for User Data (TBSBP16K) BP16K0
+ 32KBP for User Data (TBSBP32K) BP32K
+ BP for LOB Data (TBSBPLOB) BP9
+ BP for XML Data (TBSBPXML) BP16K0
+ BP for INDEXES (IDXBPOOL) BP1 Navigation
For additional information about
- related topics, select one of the options on the top of the panel.
- other topics, use the PF keys.
Fields
The DSNZ command displays the following lines to reflect the usage of the DB2 SET SYSPARM command. To each of these lines, the corresponding date on which this particular module is assembled is displayed.
- DSNZPARM Module
- The name of the DSNZPARM module that is specified for Db2 startup.
- Initial Module
- The name of the initial DSNZPARM load module.
- Previous Module
- The name of the previous DSNZPARM load module.
- Assembly Date
- The date on which this module was assembled.
DSNTIP1-Buffer Pools
- 4KBP for User Data (TBSBPOOL)
- Default 4KB Buffer Pool for:
- Table spaces with a 4KB page size in implicitly created databases
- Explicitly created table spaces with a 4KB page size and no buffer pool clause specified in the CREATE TABLESPACE statement.
- 8KBP for User Data (TBSBP8K)
- Default 8KB Buffer Pool for:
- Table spaces with a 8KB page size in implicitly created databases
- Explicitly created table spaces with a 8KB page size and no buffer pool clause specified in the CREATE TABLESPACE statement.
- 16KBP for User Data (TBSBP16K)
- Default 16KB Buffer Pool for:
- Table spaces with a 16KB page size in implicitly created databases
- Explicitly created table spaces with a 16KB page size and no buffer pool clause specified in the CREATE TABLESPACE statement.
- 32KBP for User Data (TBSBP32K)
- Default 32KB Buffer Pool for:
- Table spaces with a 32KB page size in implicitly created databases
- Explicitly created table spaces with a 32KB page size and no buffer pool clause specified in the CREATE TABLESPACE statement.
- BP for LOB Data (TBSBPLOB)
- Name of the buffer pool that is used for implicitly created LOB table spaces.
- BP for XML data (TBSBPXML)
- Name of the buffer pool that is used for XML table spaces.
- BP for indexes (IDXBPOOL)
- Default buffer pool for user index spaces.