1、DB29.7支持64GB內存的版本有哪些？ 企業版和高級企業版肯定支持，工作組版本呢？有條件的支持！但是需要Fix Pack 3a。否則無法支持64G，即使支持了64GB後超出部分依然不支持。
例如，您可以將 DB2 Workgroup 安裝到具有 128 GB RAM 的服務器上，但是該軟件只能用 64GB 的 RAM。
注意：要利用新的 64 GB 的限制，需要用到 DB2 9.7 Fix Pack 3a。Fix Pack 3a 之前的版本的內存限制為 16 GB。如果無法獲得 DB2 9.7 Fix Pack 3a 並需要利用這個新的 RAM 限制，請聯系 IBM 代表。
2、無論你的內存有多大，都要設置虛擬內存。即使我的PC已經配置了至強E3 1230的CPU,DDR3 1600規格的16GB內存，在處理DB2的時候，由於DB2要求的緣故，我依然需要將虛擬內存進行分配，分配為32768M。
否則在進行某些數據庫操作時，會報存儲器資源不足的錯誤。
#This report is generated at: 2012年3月21日 下午10時14分36秒
#Parameters used to calculate recommneded values:
#Server target memory: 7362 Megabytes, 45%
#Workload type: Mixed
#Average number of SQL statements per unit of work: More than 10 (long transactions)
#Number of transactions per minute (estimate): 60
#Optimize for: Both
#Is the database populated with data: Yes
#Average number of connected local applications: 0
#Average number of connected remote applications: 10
#Isolation level (row locking): Cursor stability (many locks of short duration)
# ====================================================================
# ====================================================================
#UPDATE DATABASE CONFIGURATION FOR SAMPLE USING APPLHEAPSZ 256 AUTOMATIC;
#UPDATE DATABASE CONFIGURATION FOR SAMPLE USING CATALOGCACHE_SZ -1 ;
#UPDATE DATABASE CONFIGURATION FOR SAMPLE USING CHNGPGS_THRESH 60 ;
#UPDATE DATABASE CONFIGURATION FOR SAMPLE USING DBHEAP 600 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 50 ;
#UPDATE DATABASE CONFIGURATION FOR SAMPLE USING LOGBUFSZ 8 ;
#UPDATE DATABASE CONFIGURATION FOR SAMPLE USING LOGFILSIZ 1000 ;
#UPDATE DATABASE CONFIGURATION FOR SAMPLE USING LOGSECOND 2 ;
#UPDATE DATABASE CONFIGURATION FOR SAMPLE USING MAXAPPLS 40 AUTOMATIC MAXLOCKS 22 ;
#UPDATE DATABASE CONFIGURATION FOR SAMPLE USING MINCOMMIT 1 ;
#UPDATE DATABASE CONFIGURATION FOR SAMPLE USING NUM_IOCLEANERS 7 AUTOMATIC;
#UPDATE DATABASE CONFIGURATION FOR SAMPLE USING NUM_IOSERVERS 3 AUTOMATIC;
#UPDATE DATABASE CONFIGURATION FOR SAMPLE USING PCKCACHESZ -1 ;
#UPDATE DATABASE CONFIGURATION FOR SAMPLE USING LOGPRIMARY 3 ;
#UPDATE DATABASE CONFIGURATION FOR SAMPLE USING SOFTMAX 100 ;
#UPDATE DATABASE CONFIGURATION FOR SAMPLE USING SORTHEAP 256 ;
#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 5000 ;
#UPDATE DATABASE CONFIGURATION FOR SAMPLE USING SELF_TUNING_MEM OFF ;
#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 5000 ;
#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 INTRA_PARALLEL OFF ;
UPDATE DATABASE MANAGER CONFIGURATION USING MAX_QUERYDEGREE 4 ;
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 665664 ;
SET CURRENT QUERY OPTIMIZATION = 5;
COMMIT;
CONNECT RESET;
CONNECT TO SAMPLE;
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
UNQUIESCE DATABASE;
CONNECT RESET;
UPDATE DB CFG FOR SAMPLE USING logarchmeth1 LOGRETAIN logprimary 3 logsecond 2 logfilsiz 1000;
BACKUP DATABASE SAMPLE TO "C:\" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 COMPRESS WITHOUT PROMPTING;
CONNECT TO SAMPLE;
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
UNQUIESCE DATABASE;
CONNECT RESET;
UPDATE DB CFG FOR SAMPLE USING logarchmeth1 LOGRETAIN logprimary 100 logsecond 6 logfilsiz 1024;
BACKUP DATABASE SAMPLE TO "C:\db2samplelog" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 COMPRESS WITHOUT PROMPTING;
CONNECT TO XJM;
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
UNQUIESCE DATABASE;
CONNECT RESET;
UPDATE DB CFG FOR XJM USING logarchmeth1 LOGRETAIN logprimary 13 logsecond 4 logfilsiz 1024;
BACKUP DATABASE XJM TO "C:\db2data_xjm" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 COMPRESS WITHOUT PROMPTING;
作者 jaminwm
