DB2配置步骤.docx

1、DB2配置步骤安装WINDOWS版DB2创建数据库CREATE DATABASE XDP_HIS AUTOMATIC STORAGE YES ON C:;CONNECT TO XDP_HIS;CALL sysinstallobjects(policy, C, null, null);-以下命令使用 C:policy20100914143003.xml 文件。CALL POLICY_INSTALLOC(U, DB2CommonMED, NOP, CommonPolicy, C:policy20100914143003.xml);CONNECT RESET;UPDATE DB CFG FOR XD

2、P_HIS USING AUTO_MAINT ON;UPDATE DB CFG FOR XDP_HIS USING AUTO_TBL_MAINT ON;UPDATE DB CFG FOR XDP_HIS USING AUTO_RUNSTATS ON;UPDATE DB CFG FOR XDP_HIS USING AUTO_REORG ON;UPDATE DB CFG FOR XDP_HIS USING AUTO_DB_BACKUP ON;UPDATE ALERT CFG FOR DATABASE ON XDP_HIS USING db.db_backup_req SET THRESHOLDSC

3、HECKED YES;UPDATE ALERT CFG FOR DATABASE ON XDP_HIS USING db.tb_reorg_req SET THRESHOLDSCHECKED YES;UPDATE ALERT CFG FOR DATABASE ON XDP_HIS USING db.tb_runstats_req SET THRESHOLDSCHECKED YES;创建缓冲池CONNECT TO XDP;CREATE BUFFERPOOL XDP8K IMMEDIATE SIZE 250 AUTOMATIC PAGESIZE 8 K ;CONNECT RESET;注：系统默认创建4K缓冲池。需要手动分别创建8K和32K缓冲池。创建表空间CONNECT TO XDP;CREATE REGULAR TABLESPACE TS8K PAGESIZE 8 K MANAGED BY AUTOMATIC STORAGE EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16 TRANSFERRATE 0.14 BUFFERPOOL XDP8K DROPPED TABLE RECOVERY ON;CONNECT RESET;注：系统默认创建4K表空间。需要手动分别创建8K和32K表空间。