chinaunix网友2006-07-13 14:48
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
chinaunix网友2006-07-13 14:43
ln -s /usr/sbin/installp /etc/installp A: To work around this problem, create a link at /etc/installp pointing to /usr/sbin/installp: ln -s /usr/sbin/installp /etc/installp How do I install DB2 version 7.1 on AIX 5L? My attempt fails with internal error: DBI1517E An attempt to execute a command in a subprocess failed. http://www-304.ibm.com/jct09002c/isv/tech/faq/individual.jsp?oid=1:24504 install/bakcup restore restore db cisdb tablespace (userspace1) online taken at 20040611174124; /data/db2user/db2user/NODE0000/CATN0000/CISDB.0.db2user.NODE0000.CATN0000.20060712173433.001 db2 restore db CISDB from /data taken at 20060712173433 to /data redirect db2 restore db taken at db2 RESTORE DATABASE cisdb TABLESPACE ONLINE FROM /data/backup/ TAKEN AT 20060712173433 db2 RESTORE DATABASE cisdb FROM /data/backup/ TAKEN AT 20060712173433 db2 list db directory db2 connect to cisdb db2 list tablespace containers for 0 db2 list tablespace containers for 1 db2 list tablespace containers for 2 db2 connect reset db2 terminate db2stop set DB2INSTANCE=PROD db2stop db2 list tablespace containers for 1 2006-7-13 11:11 [IBM][CLI Driver] SQL30081N 检测到通信错误。正在使用的通信协议:"TCP/IP"。正在使用的通信API:"SOCKETS"。检测到错误的位置:""。检测到错误的通信函 1、update dbm cfg using SVCENAME ServiceName; 2、db2set DB2COMM=tcpip 1、update dbm cfg using SVCENAME cisdb 2、db2set DB2COMM=tcpip db2 => update dbm cfg using SVCENAME cisdb DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed successfully. DB21025I Client changes will not be effective until the next time the application is started or the TERMINATE command has been issued. Server changes will not be effective until the next DB2START command. db2 => db2set DB2COMM=tcpip DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL1024N A database connection does not exist. SQLSTATE=08003 db2 => quit DB20000I The QUIT command completed successfully. $ db2set DB2COMM=tcpip $ 你catalog tcpip node & catalog db了吗 db2set db2 get dbm cfg 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 查看系统的services文件里连接db2实例的端口,类似 db2cDB2 11111/tcp #connection port for the DB2 instance DB2 配置客户端时,端口号必须一致,即为11111, 另外,查看db2 get dbm cfg结果里的svcename的值是否为db2cDB2,不是的话db2 update dbm cfg using svcename db2cDB2,之后重启 值11111和db2cDB2都可以更改 db2 update dbm cfg using svcename db2cDB2 db2 update dbm cfg using svcename db2cdb2inst1 chown -R root db2chpw chown -R root db2ckpw /db2/db2inst1/sqllib/security目录下的文件所属用户不对,修改其用户属性为以下情况,该问题就解决了 chown -R root db2chpw chown -R root db2ckpw # pwd 819 db2cmd --> db2set db2codepage=819 --> db2stop --> (db2stop force) --> db2start