#UPDATE DATABASE MANAGER CONFIGURATION USING AGENT_STACK_SZ 16 ;
#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 ANY ;
#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 ;
#CONNECT TO SAMPLE;
ALTER BUFFERPOOL IBMDEFAULTBP SIZE 250 ;
#SET CURRENT QUERY OPTIMIZATION = 5;
#COMMIT;
#CONNECT RESET;
# ====================================================================
# ====================================================================
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING APPLHEAPSZ 256 AUTOMATIC;
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING CATALOGCACHE_SZ 398 ;
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING CHNGPGS_THRESH 80 ;
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING DBHEAP 1995 AUTOMATIC;
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING DFT_DEGREE 1 ;
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING DFT_EXTENT_SZ 32 ;
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING DFT_PREFETCH_SZ AUTOMATIC;
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING LOCKLIST 2048 AUTOMATIC;
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING LOGBUFSZ 100 ;
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING LOGFILSIZ 1024 ;
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING LOGSECOND 6 ;
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING MAXAPPLS 40 AUTOMATIC MAXLOCKS 60 AUTOMATIC;
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING MINCOMMIT 1 ;
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING NUM_IOCLEANERS 1 AUTOMATIC;
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING NUM_IOSERVERS 6 AUTOMATIC;
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING PCKCACHESZ 2557 AUTOMATIC;
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING LOGPRIMARY 23 ;
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING SOFTMAX 920 ;
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING SORTHEAP 4118 AUTOMATIC;
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING STMTHEAP 4096 AUTOMATIC;
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING STAT_HEAP_SZ 4384 AUTOMATIC;
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING UTIL_HEAP_SZ 443776 ;
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING SELF_TUNING_MEM ON ;
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING AUTO_MAINT ON ;
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING AUTO_DB_BACKUP OFF ;
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING AUTO_TBL_MAINT ON ;
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING AUTO_RUNSTATS ON ;
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING AUTO_STATS_PROF OFF ;
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING AUTO_REORG OFF ;
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING AUTO_PROF_UPD OFF ;
UPDATE DATABASE CONFIGURATION FOR SAMPLE USING SHEAPTHRES_SHR 82377 AUTOMATIC;
UPDATE DATABASE MANAGER CONFIGURATION USING AGENT_STACK_SZ 16 ;
UPDATE DATABASE MANAGER CONFIGURATION USING ASLHEAPSZ 15 ;
UPDATE DATABASE MANAGER CONFIGURATION USING FCM_NUM_BUFFERS 4096 AUTOMATIC;
UPDATE DATABASE MANAGER CONFIGURATION USING I