Konfiguration_DB2

Anlegen DB
Instanz, Tablespace, Bufferpool = 1GB


Memory Tuning
Aufruf und db2cc und Auswahl der Configuration Advisors gibt eine Basislist von Tuning Parametern. Diese werden dann weiter angepasst.
UPDATE DATABASE CONFIGURATION FOR db USING APPLHEAPSZ 256 AUTOMATIC;
UPDATE DATABASE CONFIGURATION FOR db USING CATALOGCACHE_SZ 1280;
UPDATE DATABASE CONFIGURATION FOR db USING CHNGPGS_THRESH 80 ;
UPDATE DATABASE CONFIGURATION FOR db USING DBHEAP 2716 AUTOMATIC;
UPDATE DATABASE CONFIGURATION FOR db USING DFT_DEGREE ANY ;
UPDATE DATABASE CONFIGURATION FOR db USING DFT_EXTENT_SZ 32 ;
UPDATE DATABASE CONFIGURATION FOR db USING DFT_PREFETCH_SZ  AUTOMATIC;
UPDATE DATABASE CONFIGURATION FOR db USING LOCKLIST 2048 AUTOMATIC;
UPDATE DATABASE CONFIGURATION FOR db USING LOGBUFSZ 131 ;
UPDATE DATABASE CONFIGURATION FOR db USING LOGFILSIZ 1024 ;
UPDATE DATABASE CONFIGURATION FOR db USING LOGSECOND 0 ;
UPDATE DATABASE CONFIGURATION FOR db USING MAXAPPLS 40 AUTOMATIC MAXLOCKS 61 AUTOMATIC
UPDATE DATABASE CONFIGURATION FOR db USING MINCOMMIT 1 ;
UPDATE DATABASE CONFIGURATION FOR db USING NUM_IOCLEANERS 1 AUTOMATIC;
UPDATE DATABASE CONFIGURATION FOR db USING NUM_IOSERVERS 8 AUTOMATIC;
UPDATE DATABASE CONFIGURATION FOR db USING PCKCACHESZ 2560 AUTOMATIC;
UPDATE DATABASE CONFIGURATION FOR db USING SOFTMAX 720 ;
UPDATE DATABASE CONFIGURATION FOR db USING LOGPRIMARY 18 ;
UPDATE DATABASE CONFIGURATION FOR db USING SORTHEAP 4439 AUTOMATIC;
UPDATE DATABASE CONFIGURATION FOR db USING STMTHEAP 4096 AUTOMATIC;
UPDATE DATABASE CONFIGURATION FOR db USING STAT_HEAP_SZ 4384 AUTOMATIC;
UPDATE DATABASE CONFIGURATION FOR db USING UTIL_HEAP_SZ 38840 ;
UPDATE DATABASE CONFIGURATION FOR db USING SELF_TUNING_MEM ON ;
UPDATE DATABASE CONFIGURATION FOR db USING AUTO_MAINT ON ;
UPDATE DATABASE CONFIGURATION FOR db USING AUTO_DB_BACKUP OFF ;
UPDATE DATABASE CONFIGURATION FOR db USING AUTO_TBL_MAINT ON ;
UPDATE DATABASE CONFIGURATION FOR db USING AUTO_RUNSTATS ON ;
UPDATE DATABASE CONFIGURATION FOR db USING AUTO_STATS_PROF OFF ;
UPDATE DATABASE CONFIGURATION FOR db USING AUTO_REORG OFF ;
UPDATE DATABASE CONFIGURATION FOR db USING AUTO_PROF_UPD OFF ;
UPDATE DATABASE MANAGER CONFIGURATION USING AGENT_STACK_SZ 1024 ;
UPDATE DATABASE MANAGER CONFIGURATION USING ASLHEAPSZ 15 ;
UPDATE DATABASE MANAGER CONFIGURATION USING FCM_NUM_BUFFERS 4096 AUTOMATIC;
UPDATE DATABASE MANAGER CONFIGURATION USING INTRA_PARALLEL OFF ;
UPDATE DATABASE MANAGER CONFIGURATION USING MAX_QUERYDEGREE 2 ;
UPDATE DATABASE MANAGER CONFIGURATION USING NUM_POOLAGENTS 100 AUTOMATIC;
UPDATE DATABASE MANAGER CONFIGURATION USING NUM_INITAGENTS 0 ;
UPDATE DATABASE MANAGER CONFIGURATION USING RQRIOBLK 32767 ;
UPDATE DATABASE MANAGER CONFIGURATION USING SHEAPTHRES 0 ;