Buffer Pool Parameters (DSNTIP1)

This topic shows detailed information about "System Parameters - Buffer Pool Parameters (DSNTIP1)".

This block shows the default buffer pools for user data and indexes.

System Parameters - Buffer Pool Parameters (DSNTIP1)

The field labels shown in the following sample layout of "System Parameters - Buffer Pool Parameters (DSNTIP1)" are described in the following section.

BUFFER POOL PARAMETERS (DSNTIP1)                               
--------------------------------                               
DEFAULT  4-KB BUFFER POOL FOR USER DATA (TBSBPOOL)..........BP2
DEFAULT  8-KB BUFFER POOL FOR USER DATA (TBSBP8K).........BP8K0
DEFAULT 16-KB BUFFER POOL FOR USER DATA (TBSBP16K).......BP16K0
DEFAULT 32-KB BUFFER POOL FOR USER DATA (TBSBP32K)........BP32K
DEFAULT BUFFER POOL FOR USER LOB DATA (TBSBPLOB)............BP0
DEFAULT BUFFER POOL FOR USER XML DATA (TBSBPXML).........BP16K0
DEFAULT BUFFER POOL FOR USER INDEXES (IDXBPOOL).............BP3

DEFAULT 4-KB BUFFER POOL FOR USER DATA (TBSBPOOL)

The name of the 4 KB buffer pool for user table spaces.

Install parameter DEFAULT BUFFER POOL FOR USER DATA on installation panel DSNTIP1, or ZPARM TBSBPOOL in DSN6SYSP.

Field Name: QWP1TBPL

DEFAULT 8-KB BUFFER POOL FOR USER DATA (TBSBP8K)

The default 8 KB buffer pool for:

Table spaces with an 8 KB page size in implicitly created databases
Explicitly created table spaces with an 8 KB page size, but without a buffer pool clause that is specified in the create table space statement.

Install parameter DEFAULT 8-KB BUFFER POOL FOR USER DATA on panel DSNTIP1 or ZPARM TBSBP8K in DSN6SYSP.

Field Name: QWP1TP8

DEFAULT 16-KB BUFFER POOL FOR USER DATA (TBSBP16K)

The default 16 KB buffer pool for:

Table spaces with a 16 KB page size in implicitly created databases
Explicitly created table spaces with a 16 KB page size, but without a buffer pool clause that is specified in the create table space statement.

Install parameter DEFAULT 16-KB BUFFER POOL FOR USER DATA on panel DSNTIP1 or ZPARM TBSBP16K in DSN6SYSP.

Field Name: QWP1TP16

DEFAULT 32-KB BUFFER POOL FOR USER DATA (TBSBP32K)

The default 32 KB buffer pool for:

Table spaces with a 32 KB page size in implicitly created databases
Explicitly created table spaces with a 32 KB page size, but without a buffer pool clause that is specified in the create table space statement.

Install parameter DEFAULT 32-KB BUFFER POOL FOR USER DATA on panel DSNTIP1 or ZPARM TBSBP32K in DSN6SYSP.

Field Name: QWP1TP32

DEFAULT BUFFER POOL FOR USER LOB DATA (TBSBPLOB)

The name of the buffer pool that is used for implicitly created LOB table spaces. This field corresponds to field default buffer pool for USER LOB DATA on installation panel DSNTIP1. The ZPARM name is TBSBPLOB in DSN6SYSP.

Field Name: QWP1TPLB

DEFAULT BUFFER POOL FOR USER XML DATA (TBSBPXML)

The name of the buffer pool that is used for XML table spaces. This field corresponds to field default buffer pool for USER XML DATA on installation panel DSNTIP1. The ZPARM name is TBSBPXML in DSN6SYSP.

Field Name: QWP1TPXM

DEFAULT BUFFER POOL FOR USER INDEXES (IDXBPOOL)

The name of the 4 KB buffer pool used for indexes on user data.

Install parameter DEFAULT BUFFER POOL FOR USER INDEXES on installation panel DSNTIP1, or ZPARM IDXBPOOL in DSN6SYSP.

Field Name: QWP1IXPL

Feedback