SYGSYWDB01:/ywdata/aicmis$>db2 get db cfg for bas | grep MAX Percent. of lock lists per application (MAXLOCKS) = 30 Package cache size (4KB) (PCKCACHESZ) = (MAXAPPLS*8) Catalog cache size (4KB) (CATALOGCACHE_SZ) = (MAXAPPLS*5) Max number of active applications (MAXAPPLS) = AUTOMATIC(1252) Max DB files open per application (MAXFILOP) = 61440 Percent max primary log space by transaction (MAX_LOG) = 0 Percent log file reclaimed before soft chckpt (SOFTMAX) = 100
SYGSYWDB01:/ywdata/aicmis$>db2 get db cfg for biz | grep MAX Percent. of lock lists per application (MAXLOCKS) = 30 Max number of active applications (MAXAPPLS) = AUTOMATIC(1627) Max DB files open per application (MAXFILOP) = 61440 Percent max primary log space by transaction (MAX_LOG) = 0 Percent log file reclaimed before soft chckpt (SOFTMAX) = 520
SYGSYWDB01:/ywdata/aicmis$>db2 get db cfg for wsnj | grep MAX Percent. of lock lists per application (MAXLOCKS) = 60 Max number of active applications (MAXAPPLS) = AUTOMATIC(678) Max DB files open per application (MAXFILOP) = 61440 Percent max primary log space by transaction (MAX_LOG) = 0 Percent log file reclaimed before soft chckpt (SOFTMAX) = 520
SYGSYWDB01:/ywdata/aicmis$>db2 get dbm cfg | grep MAX Max number of coordinating agents (MAX_COORDAGENTS) = AUTOMATIC(200) Max number of client connections (MAX_CONNECTIONS) = AUTOMATIC(MAX_COORDAGENTS) Number of pooled fenced processes (FENCED_POOL) = AUTOMATIC(MAX_COORDAGENTS) SPM resync agent limit (SPM_MAX_RESYNC) = 20 Maximum query degree of parallelism (MAX_QUERYDEGREE) = ANY Max number of node connection retries (MAX_CONNRETRIES) = 5 Max time difference between nodes (min) (MAX_TIME_DIFF) = 60