DB2 安装和配置1DB2 安装和配置1.1拷贝DB2安装包到OPT下[root@localhost opt]# scp DB2_WSE_97_Linux_x86.tar.gz************.1.239:/optThe authenticity of host '192.168.1.239 (192.168.1.239)' can't be established. RSA key fingerprint is 31:14:ff:22:04:6c:50:13:7d:a5:5d:ee:04:f3:56:c6.Are you sure you want to continue connecting (yes)? yesWarning: Permanently added '192.168.1.239' (RSA) to the list of known hosts.************.1.239's password:db2v82_32_linux_2.6_ESE.tar 100% 410MB 45.6MB/ s 00:091.2解压安装包到当前目录tar -xvf DB2_WSE_97_Linux_x86.tar.gz1.3检查并设置字符集安装DB2 8.7 时，应该用[root@localhost 334_ESE_LNX26_32_NLV]# vi /etc/sysconfig/i18n#LANG="zh_CN.UTF-8"LANG="zh_CN.GB18030"LANGUAGE="zh_CN.GB18030:zh_CN.GB2312:zh_CN"LC_C TYPE=zn_CN.GB18030lC_TIME=en_US.UTF-8[root@localhost ]# source /etc/sysconfig/i18n1.4安装DB2[root@localhost wse]# ./DB2_install指定下列一个或多个关键字（以空格分开）以安装DB2 产品。

选择否输入WAS注意必须完全一致，不能退格1.5创建组groupadd db2grp1groupadd db2fgrp1groupadd dasadm11.6创建用户useradd -g db2grp1 db2inst1useradd -g db2fgrp1 db2fenc1useradd -g dasadm1 dasusr11.7设置密码passwd db2inst1passwd db2fenc1passwd dasusr11.8创建实例cd /opt/IBM/db2/V8.1/instance/./db2icrt -p 50000 -u db2fenc1 db2inst1安装成功将显示：DBI1070I Program db2icrt completed successfully. 注释:1.9指定端口50000./dascrt -u dasusr1编辑/etc/services 添加一行：DB2_TMINST 50000/tcpsu db2inst1db2set db2comm = tcpipsu root1.10拷贝安装许可证到DB2目录license这是单独的许可证db2wse_c.liccp /opt/db2ese.lic /opt/IBM/db2/V8.1/license/su db2inst1db2licm -a /opt/IBM/db2/V8.1/license/db2ese.lic[db2inst1@localhost license]$ db2licm -a /opt/IBM/DB2/V8.1lib/ license/[db2inst1@localhost license]$ db2licm -a /opt/IBM/DB2/V8.1/License/DB2ese.lic DBI1402I License added successfully.DBI1426I This product is now licensed for use as specified inthe License Acceptance and License Informationdocuments pertaining to the licensed copy of thisproduct. USE OF THE PRODUCT CONSTITUTES ACCEPTANCE OFTHE TERMS OF THE IBM LICENSE ACCEPTANCE AND LICENSEINFORMATION DOCUMENTS, LOCATED IN THE FOLLOWINGDIRECTORY: /opt/IBM2/V8.1cense/zh_CN.gbk[db2inst1@localhost license]$2恢复DB2数据库王府井新门店2.1拷贝数据库备份启动数据库db2startchmod 777 [备份文件名]日志目录赋予777 权限。

例如/home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR SQL00001可能不同。

su db2inst1db2 restore db 【数据库名】（e.g. scmv3in1 for VIP1）from 【备份文件所在目录】taken at 20110924230103其中数据库名是指的是备份数据库文件的名称。

、20110924230103是备份出来的数据库文件的时间戳，如果还原数据库应以备份出来的数据库文件时间戳为准提示成功db2 rollforward db 【数据库名】to end of logs and stop当执行以上命令会出现解决办：把原来服务器商的日志复制到当前服务器的/home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/ 目录中，并设置权权限更改所有者以及所宿主使用chown db2inst1：dbgrp1 S0003553.LOG S0003554.LOG，然后在执行命令提示成功db2 rollforward db 【数据库名】complete已经完成恢复[db2inst1@localhost opt]$ db2 rollforward db scmv3in1 to end of logs Rollforward Status Input database alias = scmv3in1 Number of nodes have returned status = 1 Node number = 0 Rollforward status = DB working Next log file to be read = S0023101.LOG Log files processed = S0023101.LOG - S0023101.LOG Last committed transaction = 2011-11-28-15.11.05.000000DB20000I The ROLLFORWARD command completed successfully.[db2inst1@localhost opt]$ db2 rollforward db scmv3in1 complete Rollforward Status Input database alias = scmv3in1 Number of nodes have returned status = 1 Node number = 0 Rollforward status = not pending Next log file to be read = Log files processed = S0023101.LOG - S0023101.LOG Last committed transaction = 2011-11-28-15.11.05.000000DB20000I The ROLLFORWARD command completed successfully.测试数据库是否工作，连接数据库：db2 connect to scmv3in1 user scmuser using scmusering2.2恢复后设置字符集db2set db2codepage=1386db2 terminatedb2 connect to 【数据库名】user 【用户名】using 【密码】db2 connect to scmv2 user scmuser using scmusering查数据库字符集及其他信息[db2inst1@localhost ~]$ db2 get db cfg for scmv2Database Configuration for Database scmv2Database configuration release level = 0x0d00Database release level = 0x0d00Database territory = USDatabase code page = 1208Database code set = UTF-8Database country/region code = 1Database collating sequence = IDENTITYAlternate collating sequence (ALT_COLLATE) =Number compatibility = OFFVarchar2 compatibility = OFFDate compatibility = OFFDatabase page size = 4096Dynamic SQL Query management (DYN_QUERY_MGMT) = DISABLEStatement concentrator (STMT_CONC) = OFFDiscovery support for this database (DISCOVER_DB) = ENABLERestrict access = NODefault query optimization class (DFT_QUERYOPT) = 5Degree of parallelism (DFT_DEGREE) = 1Continue upon arithmetic exceptions (DFT_SQLMATHWARN) = NODefault refresh age (DFT_REFRESH_AGE) = 0Default maintained table types for opt (DFT_MTTB_TYPES) = SYSTEMNumber of frequent values retained (NUM_FREQVALUES) = 10Number of quantiles retained (NUM_QUANTILES) = 20Decimal floating point rounding mode (DECFLT_ROUNDING) = ROUND_HALF_EVEN Backup pending = NOAll committed transactions have been written to disk = YESRollforward pending = NORestore pending = NOMulti-page file allocation enabled = YESLog retain for recovery status = RECOVERYUser exit for logging status = NOSelf tuning memory (SELF_TUNING_MEM) = OFFSize of database shared memory (4KB) (DATABASE_MEMORY) = AUTOMATIC(28752) Database memory threshold (DB_MEM_THRESH) = 10Max storage for lock list (4KB) (LOCKLIST) = 100Percent. of lock lists per application (MAXLOCKS) = 10Package cache size (4KB) (PCKCACHESZ) = (MAXAPPLS*8)Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = 5000Sort list heap (4KB) (SORTHEAP) = 256Database heap (4KB) (DBHEAP) = AUTOMATIC(1200) Catalog cache size (4KB) (CATALOGCACHE_SZ) = (MAXAPPLS*5)Log buffer size (4KB) (LOGBUFSZ) = 8Utilities heap size (4KB) (UTIL_HEAP_SZ) = 5000Buffer pool size (pages) (BUFFPAGE) = 1000SQL statement heap (4KB) (STMTHEAP) = AUTOMATIC(2048) Default application heap (4KB) (APPLHEAPSZ) = AUTOMATIC(256) Application Memory Size (4KB) (APPL_MEMORY) = AUTOMATIC(10016) Statistics heap size (4KB) (STAT_HEAP_SZ) = AUTOMATIC(4384)Interval for checking deadlock (ms) (DLCHKTIME) = 10000Lock timeout (sec) (LOCKTIMEOUT) = -1Changed pages threshold (CHNGPGS_THRESH) = 60Number of asynchronous page cleaners (NUM_IOCLEANERS) = AUTOMATIC(1) Number of I/O servers (NUM_IOSERVERS) = AUTOMATIC(3) Index sort flag (INDEXSORT) = YESSequential detect flag (SEQDETECT) = YESDefault prefetch size (pages) (DFT_PREFETCH_SZ) = AUTOMATICTrack modified pages (TRACKMOD) = OFFDefault number of containers = 1Default tablespace extentsize (pages) (DFT_EXTENT_SZ) = 32Max number of active applications (MAXAPPLS) = AUTOMATIC(333) Average number of active applications (AVG_APPLS) = AUTOMATIC(1) Max DB files open per application (MAXFILOP) = 30720Log file size (4KB) (LOGFILSIZ) = 1000Number of primary log files (LOGPRIMARY) = 3Number of secondary log files (LOGSECOND) = 2Changed path to log files (NEWLOGPATH) =Path to log files =/home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/Overflow log path (OVERFLOWLOGPATH) =Mirror log path (MIRRORLOGPATH) =First active log file = S0005768.LOG Block log on disk full (BLK_LOG_DSK_FUL) = NOBlock non logged operations (BLOCKNONLOGGED) = NOPercent max primary log space by transaction (MAX_LOG) = 0Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0Group commit count (MINCOMMIT) = 1Percent log file reclaimed before soft chckpt (SOFTMAX) = 100Log retain for recovery enabled (LOGRETAIN) = RECOVERYUser exit for logging enabled (USEREXIT) = OFFHADR database role = STANDARDHADR local host name (HADR_LOCAL_HOST) =HADR local service name (HADR_LOCAL_SVC) =HADR remote host name (HADR_REMOTE_HOST) =HADR remote service name (HADR_REMOTE_SVC) =HADR instance name of remote server (HADR_REMOTE_INST) =HADR timeout value (HADR_TIMEOUT) = 120HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNCHADR peer window duration (seconds) (HADR_PEER_WINDOW) = 0First log archive method (LOGARCHMETH1) = LOGRETAINOptions for logarchmeth1 (LOGARCHOPT1) =Second log archive method (LOGARCHMETH2) = OFFOptions for logarchmeth2 (LOGARCHOPT2) =Failover log archive path (FAILARCHPATH) =Number of log archive retries on error (NUMARCHRETRY) = 5Log archive retry Delay (secs) (ARCHRETRYDELAY) = 20Vendor options (VENDOROPT) =Auto restart enabled (AUTORESTART) = ONIndex re-creation time and redo index build (INDEXREC) = SYSTEM (RESTART) Log pages during index build (LOGINDEXBUILD) = OFFDefault number of loadrec sessions (DFT_LOADREC_SES) = 1Number of database backups to retain (NUM_DB_BACKUPS) = 12Recovery history retention (days) (REC_HIS_RETENTN) = 366Auto deletion of recovery objects (AUTO_DEL_REC_OBJ) = OFFTSM management class (TSM_MGMTCLASS) =TSM node name (TSM_NODENAME) =TSM owner (TSM_OWNER) =TSM password (TSM_PASSWORD) =Automatic maintenance (AUTO_MAINT) = OFFAutomatic database backup (AUTO_DB_BACKUP) = OFFAutomatic table maintenance (AUTO_TBL_MAINT) = OFFAutomatic runstats (AUTO_RUNSTATS) = OFFAutomatic statement statistics (AUTO_STMT_STATS) = OFFAutomatic statistics profiling (AUTO_STATS_PROF) = OFFAutomatic profile updates (AUTO_PROF_UPD) = OFFAutomatic reorganization (AUTO_REORG) = OFFAuto-Revalidation (AUTO_REVAL) = DISABLEDCurrently Committed (CUR_COMMIT) = DISABLEDCHAR output with DECIMAL input (DEC_TO_CHAR_FMT) = V95Enable XML Character operations (ENABLE_XMLCHAR) = YESWLM Collection Interval (minutes) (WLM_COLLECT_INT) = 0Monitor Collect SettingsRequest metrics (MON_REQ_METRICS) = NONEActivity metrics (MON_ACT_METRICS) = NONEObject metrics (MON_OBJ_METRICS) = NONEUnit of work events (MON_UOW_DATA) = NONELock timeout events (MON_LOCKTIMEOUT) = NONEDeadlock events (MON_DEADLOCK) = NONELock wait events (MON_LOCKWAIT) = NONELock wait event threshold (MON_LW_THRESH) = 5000000SMTP Server (SMTP_SERVER) =。