+

Search Tips   |   Advanced Search

Properties file: db.config.properties


Table of contents

  1. Properties used for DB2 database creation
  2. Properties used for DB2 performance tuning
  3. Properties used for DB2 bufferpools


Parent: Configuration properties reference


1. Properties used for DB2 database creation

shared.db2.comment

Description
Default IBM WPLC
Examples None available

shared.db2.CODESET

Description
Default UTF-8
Examples None available

shared.db2.TERRITORY

Description
Default US
Examples None available

shared.db2.PAGESIZE

Description
Default 8192
Examples None available


2. Properties used for DB2 performance tuning

shared.db2.DB2_RR_TO_RS

Description
Default YES
Examples None available

shared.db2.DB2_EVALUNCOMMITTED

Description
Default YES
Examples None available

shared.db2.DB2_INLIST_TO_NLJN

Description
Default YES
Examples None available

shared.db2.query_heap_sz

Description
Default 32768
Examples None available

shared.db2.maxagents

Description
Default 500
Examples None available

shared.db2.sheapthres

Description sheapthres suggested setting: db2 v9: 0 db2 v8: 50000
Default 0
Examples None available

shared.db2.applheapsz

Description
Default 4096
Examples None available

shared.db2.app_ctl_heap_sz

Description
Default 1024
Examples None available

shared.db2.stmtheap

Description
Default 16384
Examples None available

shared.db2.dbheap

Description
Default 2400
Examples None available

shared.db2.locklist

Description
Default 1000
Examples None available

shared.db2.logfilsiz

Description
Default 4000
Examples None available

shared.db2.logprimary

Description
Default 12
Examples None available

shared.db2.logsecond

Description
Default 20
Examples None available

shared.db2.logbufsz

Description
Default 32
Examples None available

shared.db2.avg_appls

Description
Default 5
Examples None available

shared.db2.locktimeout

Description
Default 30
Examples None available

shared.db2.AUTO_MAINT

Description
Default off
Examples None available


3. Properties used for DB2 bufferpools

This section includes bufferpool names, sizes, pagesizes, prefetch and extent.

shared.db2.lwp.32k.bufferpool.name

Description
Default WPLC32K
Examples None available

shared.db2.lwp.8k.bufferpool.name

Description
Default WPLC8K
Examples None available

shared.db2.lwp.4k.bufferpool.name

Description
Default WPLC4K
Examples None available

shared.db2.lwp.32k.bufferpool.size

Description
Default 500
Examples None available

shared.db2.lwp.8k.bufferpool.size

Description
Default 500
Examples None available

shared.db2.lwp.4k.bufferpool.size

Description
Default 500
Examples None available

shared.db2.lwp.32k.bufferpool.pagesize

Description
Default 32 K
Examples None available

shared.db2.lwp.8k.bufferpool.pagesize

Description
Default 8 K
Examples None available

shared.db2.lwp.4k.bufferpool.pagesize

Description
Default 4 K
Examples None available

shared.db2.lwp.32k.bufferpool.prefetch

Description
Default 32
Examples None available

shared.db2.lwp.8k.bufferpool.prefetch

Description
Default 8
Examples None available

shared.db2.lwp.4k.bufferpool.prefetch

Description
Default 4
Examples None available

shared.db2.lwp.32k.bufferpool.extent

Description
Default 32
Examples None available

shared.db2.lwp.8k.bufferpool.extent

Description
Default 8
Examples None available

shared.db2.lwp.4k.bufferpool.extent

Description
Default 4
Examples None available