软讯网络 > 冲浪宝典 > 网络资源 > db2 install/restore/client connect
【标 题】:db2 install/restore/client connect
【关键字】:
db2,install/restore/client,connect
【来 源】:http://www.cublog.cn/u/2150/showart.php?id=140173
db2 install/restore/client connect
1
ln -s /usr/sbin/installp /etc/installp
2
db2 RESTORE DATABASE cisdb FROM /data/backup/ TAKEN AT 20060712173433
3
db2 get dbm cfg
/etc/service
查看/etc/services
db2cdb2inst1 50000/tcp # Connection port for DB2 instance db2user
db2idb2inst1 50001/tcp # Interrupt port for DB2 instance db2user
db2 update dbm cfg using svcename db2cDB2
4
/db2/db2inst1/sqllib/security目录下的文件所属用户不对,修改其用户属性为以下情况,该问题就解决了
chown -R root db2chpw
chown -R root db2ckpw
5
db2cmd --> db2set db2codepage=819 --> db2stop --> (db2stop force) --> db2start