DB CFG parameters

Some useful Database Configuration for Database prod :

 Self tuning memory                    (SELF_TUNING_MEM) = ON

 Size of database shared memory (4KB)  (DATABASE_MEMORY) = AUTOMATIC(153080)

 Max storage for lock list (4KB)              (LOCKLIST) = AUTOMATIC(6200)

 Percent. of lock lists per application       (MAXLOCKS) = AUTOMATIC(60)

 Package cache size (4KB)                   (PCKCACHESZ) = AUTOMATIC(15124)

 Sort list heap (4KB)                         (SORTHEAP) = AUTOMATIC(2664)

  

 Database heap (4KB)                            (DBHEAP) = AUTOMATIC(1235)

 Catalog cache size (4KB)              (CATALOGCACHE_SZ) = 300

 Log buffer size (4KB)                        (LOGBUFSZ) = 256

 Utilities heap size (4KB)                (UTIL_HEAP_SZ) = 31706

 Buffer pool size (pages)                     (BUFFPAGE) = 250

 SQL statement heap (4KB)                     (STMTHEAP) = AUTOMATIC(2048)

 Default application heap (4KB)             (APPLHEAPSZ) = AUTOMATIC(256)

 Application Memory Size (4KB)             (APPL_MEMORY) = AUTOMATIC(10000)

 Statistics heap size (4KB)               (STAT_HEAP_SZ) = AUTOMATIC(4384)

  

 Interval for checking deadlock (ms)         (DLCHKTIME) = 10000

 Lock timeout (sec)                        (LOCKTIMEOUT) = 10

  

 Track modified pages                         (TRACKMOD) = ON

  

 Default number of containers                            = 1

 Default tablespace extentsize (pages)   (DFT_EXTENT_SZ) = 32

  

 Max number of active applications            (MAXAPPLS) = AUTOMATIC(40)

  

 Log file size (4KB)                         (LOGFILSIZ) = 1024

 Number of primary log files                (LOGPRIMARY) = 13

 Number of secondary log files               (LOGSECOND) = 4

 Changed path to log files                  (NEWLOGPATH) =

 Path to log files                                       = F:\DB2\NODE0000\SQL00001\SQLOGDIR\

 Overflow log path                     (OVERFLOWLOGPATH) =

 Percent log file reclaimed before soft chckpt (SOFTMAX) = 520

 Log retain for recovery enabled             (LOGRETAIN) = OFF

 User exit for logging enabled                (USEREXIT) = OFF

  HADR database role                                      = STANDARD

 HADR local host name                  (HADR_LOCAL_HOST) =

 HADR local service name                (HADR_LOCAL_SVC) =

 HADR remote host name                (HADR_REMOTE_HOST) =

 HADR remote service name              (HADR_REMOTE_SVC) =

 HADR instance name of remote server  (HADR_REMOTE_INST) =

 HADR timeout value                       (HADR_TIMEOUT) = 120

 HADR log write synchronization mode     (HADR_SYNCMODE) = NEARSYNC

 HADR peer window duration (seconds)  (HADR_PEER_WINDOW) = 0

 First log archive method                 (LOGARCHMETH1) = DISK:c:\db2\archs\

 Index re-creation time and redo index build  (INDEXREC) = SYSTEM (RESTART)

 Log pages during index build            (LOGINDEXBUILD) = OFF

 Currently Committed                        (CUR_COMMIT) = ON