DB2 9.7安装和配置(完善)

DB2 安装和配置
1DB2 安装和配置
1.1拷贝DB2安装包到OPT下
[root@localhost opt]# scp DB2_WSE_97_Linux_x86.tar.gz************.1.239:/opt
The 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)? yes
Warning: 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:09
1.2解压安装包到当前目录
tar -xvf DB2_WSE_97_Linux_x86.tar.gz
1.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/i18n
1.4安装DB2
[root@localhost wse]# ./DB2_install
指定下列一个或多个关键字
（以空格分开）以安装DB2 产品。

选择否
输入WAS
注意必须完全一致，不能退格
1.5创建组
groupadd db2grp1
groupadd db2fgrp1
groupadd dasadm1
1.6创建用户
useradd -g db2grp1 db2inst1
useradd -g db2fgrp1 db2fenc1
useradd -g dasadm1 dasusr1
1.7设置密码
passwd db2inst1
passwd db2fenc1
passwd dasusr1
1.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/tcp
su db2inst1
db2set db2comm = tcpip
su root
1.10拷贝安装许可证到DB2目录license
这是单独的许可证db2wse_c.lic
cp /opt/db2ese.lic /opt/IBM/db2/V8.1/license/
su db2inst1
db2licm -a /opt/IBM/db2/V8.1/license/db2ese.lic
[db2inst1@localhost license]$ db2licm -a /opt/IBM/DB2/V8.1
lib/ 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 in
the License Acceptance and License Information
documents pertaining to the licensed copy of this
product. USE OF THE PRODUCT CONSTITUTES ACCEPTANCE OF
THE TERMS OF THE IBM LICENSE ACCEPTANCE AND LICENSE
INFORMATION DOCUMENTS, LOCATED IN THE FOLLOWING
DIRECTORY: /opt/IBM2/V8.1cense/zh_CN.gbk
[db2inst1@localhost license]$
2恢复DB2数据库
王府井新门店
2.1拷贝数据库备份
启动数据库
db2start
chmod 777 [备份文件名]
日志目录赋予777 权限。

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

su db2inst1
db2 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 scmusering
2.2恢复后设置字符集
db2set db2codepage=1386
db2 terminate
db2 connect to 【数据库名】user 【用户名】using 【密码】
db2 connect to scmv2 user scmuser using scmusering
查数据库字符集及其他信息
[db2inst1@localhost ~]$ db2 get db cfg for scmv2
Database Configuration for Database scmv2
Database configuration release level = 0x0d00
Database release level = 0x0d00
Database territory = US
Database code page = 1208
Database code set = UTF-8
Database country/region code = 1
Database collating sequence = IDENTITY
Alternate collating sequence (ALT_COLLATE) =
Number compatibility = OFF
Varchar2 compatibility = OFF
Date compatibility = OFF
Database page size = 4096
Dynamic SQL Query management (DYN_QUERY_MGMT) = DISABLE
Statement concentrator (STMT_CONC) = OFF
Discovery support for this database (DISCOVER_DB) = ENABLE
Restrict access = NO
Default query optimization class (DFT_QUERYOPT) = 5
Degree of parallelism (DFT_DEGREE) = 1
Continue upon arithmetic exceptions (DFT_SQLMATHWARN) = NO
Default refresh age (DFT_REFRESH_AGE) = 0
Default maintained table types for opt (DFT_MTTB_TYPES) = SYSTEM
Number of frequent values retained (NUM_FREQVALUES) = 10
Number of quantiles retained (NUM_QUANTILES) = 20
Decimal floating point rounding mode (DECFLT_ROUNDING) = ROUND_HALF_EVEN Backup pending = NO
All committed transactions have been written to disk = YES
Rollforward pending = NO
Restore pending = NO
Multi-page file allocation enabled = YES
Log retain for recovery status = RECOVERY
User exit for logging status = NO
Self tuning memory (SELF_TUNING_MEM) = OFF
Size of database shared memory (4KB) (DATABASE_MEMORY) = AUTOMATIC(28752) Database memory threshold (DB_MEM_THRESH) = 10
Max storage for lock list (4KB) (LOCKLIST) = 100
Percent. of lock lists per application (MAXLOCKS) = 10
Package cache size (4KB) (PCKCACHESZ) = (MAXAPPLS*8)
Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = 5000
Sort list heap (4KB) (SORTHEAP) = 256
Database heap (4KB) (DBHEAP) = AUTOMATIC(1200) Catalog cache size (4KB) (CATALOGCACHE_SZ) = (MAXAPPLS*5)
Log buffer size (4KB) (LOGBUFSZ) = 8
Utilities heap size (4KB) (UTIL_HEAP_SZ) = 5000
Buffer pool size (pages) (BUFFPAGE) = 1000
SQL 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) = 10000
Lock timeout (sec) (LOCKTIMEOUT) = -1
Changed pages threshold (CHNGPGS_THRESH) = 60
Number of asynchronous page cleaners (NUM_IOCLEANERS) = AUTOMATIC(1) Number of I/O servers (NUM_IOSERVERS) = AUTOMATIC(3) Index sort flag (INDEXSORT) = YES
Sequential detect flag (SEQDETECT) = YES
Default prefetch size (pages) (DFT_PREFETCH_SZ) = AUTOMATIC
Track modified pages (TRACKMOD) = OFF
Default number of containers = 1
Default tablespace extentsize (pages) (DFT_EXTENT_SZ) = 32
Max number of active applications (MAXAPPLS) = AUTOMATIC(333) Average number of active applications (AVG_APPLS) = AUTOMATIC(1) Max DB files open per application (MAXFILOP) = 30720
Log file size (4KB) (LOGFILSIZ) = 1000
Number of primary log files (LOGPRIMARY) = 3
Number of secondary log files (LOGSECOND) = 2
Changed 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) = NO
Block non logged operations (BLOCKNONLOGGED) = NO
Percent max primary log space by transaction (MAX_LOG) = 0
Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0
Group commit count (MINCOMMIT) = 1
Percent log file reclaimed before soft chckpt (SOFTMAX) = 100
Log retain for recovery enabled (LOGRETAIN) = RECOVERY
User exit for logging enabled (USEREXIT) = OFF
HADR database role = STANDARD
HADR 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) = 120
HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC
HADR peer window duration (seconds) (HADR_PEER_WINDOW) = 0
First log archive method (LOGARCHMETH1) = LOGRETAIN
Options for logarchmeth1 (LOGARCHOPT1) =
Second log archive method (LOGARCHMETH2) = OFF
Options for logarchmeth2 (LOGARCHOPT2) =
Failover log archive path (FAILARCHPATH) =
Number of log archive retries on error (NUMARCHRETRY) = 5
Log archive retry Delay (secs) (ARCHRETRYDELAY) = 20
Vendor options (VENDOROPT) =
Auto restart enabled (AUTORESTART) = ON
Index re-creation time and redo index build (INDEXREC) = SYSTEM (RESTART) Log pages during index build (LOGINDEXBUILD) = OFF
Default number of loadrec sessions (DFT_LOADREC_SES) = 1
Number of database backups to retain (NUM_DB_BACKUPS) = 12
Recovery history retention (days) (REC_HIS_RETENTN) = 366
Auto deletion of recovery objects (AUTO_DEL_REC_OBJ) = OFF
TSM management class (TSM_MGMTCLASS) =
TSM node name (TSM_NODENAME) =
TSM owner (TSM_OWNER) =
TSM password (TSM_PASSWORD) =
Automatic maintenance (AUTO_MAINT) = OFF
Automatic database backup (AUTO_DB_BACKUP) = OFF
Automatic table maintenance (AUTO_TBL_MAINT) = OFF
Automatic runstats (AUTO_RUNSTATS) = OFF
Automatic statement statistics (AUTO_STMT_STATS) = OFF
Automatic statistics profiling (AUTO_STATS_PROF) = OFF
Automatic profile updates (AUTO_PROF_UPD) = OFF
Automatic reorganization (AUTO_REORG) = OFF
Auto-Revalidation (AUTO_REVAL) = DISABLED
Currently Committed (CUR_COMMIT) = DISABLED
CHAR output with DECIMAL input (DEC_TO_CHAR_FMT) = V95
Enable XML Character operations (ENABLE_XMLCHAR) = YES
WLM Collection Interval (minutes) (WLM_COLLECT_INT) = 0
Monitor Collect Settings
Request metrics (MON_REQ_METRICS) = NONE
Activity metrics (MON_ACT_METRICS) = NONE
Object metrics (MON_OBJ_METRICS) = NONE
Unit of work events (MON_UOW_DATA) = NONE
Lock timeout events (MON_LOCKTIMEOUT) = NONE
Deadlock events (MON_DEADLOCK) = NONE
Lock wait events (MON_LOCKWAIT) = NONE
Lock wait event threshold (MON_LW_THRESH) = 5000000
SMTP Server (SMTP_SERVER) =。