1、DB29.7支持64GB内存的版本有哪些? 企业版和高级企业版肯定支持,工作组版本呢?有条件的支持!但是需要Fix Pack 3a。否则无法支持64G,即使支持了64GB后超出部分依然不支持。
例如,例如,您可以将DB2Workgroup安装到具有128GBRAM的服务器上,但是该软件只能用64GB的RAM。
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;
相关推荐
它有多种不同的版本, 如: DB2工作组版(DB2 Workgroup Edition)、 DB2企业版(DB2 Enterprise Edition)、 DB2个人版(DB2 Personal Edition)和 DB2企业扩展版(DB2 Enterprise-Exended Edition)等,这些产品...
PDM workgroup教程PDM workgroup教程PDM workgroup教程PDM workgroup教程PDM workgroup教程PDM workgroup教程PDM workgroup教程
RELEASE NOTES FOR MICROSOFT(R) TCP/IP-32 FOR WINDOWS(TM) FOR WORKGROUPS 3.11 PLEASE READ THIS ENTIRE DOCUMENT General ------- This product is compatible with, and supported exclusively on, the ...
Windows for WorkGroup3.11 英文版原版。特殊设备适用,比如手持及智能设备,带网络支持。 MD5: E3CF1A784EDE7C9D5729FB1D274125CC SHA-1: 49840FB0107532A1349FD506353407F049FECC06 1994年2月15日微软公司发行了...
基于Macos10.9.5的workgroup manager, 可以对域账号管理与做偏好限制
Windows for WorkGroup 3.11 简体中文版
Microsoft SQL Server 2000 Workgroup Edition (Simplified Chinese) ,可做收藏、学习、研究。
SQL Server 2008 Workgroup Edition (Simplified Chinese)开发版/企业版/个人版/标准版/原版iso
SQL Server 2000 Workgroup Edition (Simplified Chinese)开发版/企业版/个人版/标准版/工作组版原版iso
Windows for WorkGroup3.11 英文版 怀旧专用。特殊设备适用,比如手持及智能设备。带网络支持。
windows 3.11 workgroup
SQL Server 2005 Workgroup Edition (Simplified Chinese)开发版/企业版/个人版/标准版/免费版
Workgroup Manager (WGM) 是一个 Windows 工作组管理工具,支持远程用户/组管理和工作组优化。 可以添加/编辑/删除用户和组,并且可以通过拖放将用户添加到组中。
workgroup无法访问的解决方法.docx
SQL Server 2005 Express与Workgroup:功能丰富,价格低廉.pdf
开源项目-Urban4M-go-workgroup.zip,My little sync.WaitGroup wrapper-package
简单教你使用TFS(Visual Studio 2005 Team Foundation Server Workgroup Edition) 网页随时带,过程图教你每一步
微软最后一个DOS操作系统,光盘镜像自动安装,集成和windows3.11for workgroup和中文windows3.2,如不想用,直接删除镜像中对应文件夹即可(分卷压缩part2)
微软最后一个DOS操作系统,光盘镜像自动安装,集成和windows3.11for workgroup和中文windows3.2,如不想用,直接删除镜像中对应文件夹即可(分卷压缩part1,共两卷)
虚拟机dos 下使用 ddi.com(内含) 将所有软盘镜像全部解压至任意一个目录,运行setup安装。内含中文系统,仅供怀旧,或者你有386老机器?