--确保99.1.57.103上 DB2COMM=TCPIP$db2 catalog tcpip node N57_103 remote 99.1.57.103 server 50005$db2 catalog database EXAMDB as myexamdb at node N57_103 $db2 list db directory | grep -i myexamdb$db2 connect to myexamdb user examuser using exampass$db...
显示全部--确保99.1.57.103上 DB2COMM=TCPIP
$db2 catalog tcpip node N57_103 remote 99.1.57.103 server 50005
$db2 catalog database EXAMDB as myexamdb at node N57_103
$db2 list db directory | grep -i myexamdb
$db2 connect to myexamdb user examuser using exampass
$db2 connect reset
$db2set db2codepage=1386
$db2set DB2COUNTRY=86
exit user login
login again
$db2 create database mydb using codeset GBK territory CN
$db2 backup db mydb to /db_bak
$db2 connect to mydb
$db2 update db cfg for using MIRRORLOGPATH /mirror_log
$db2 update db cfg for using USEREXIT on
$db2 update db cfg for using LOGRETAIN on
$db2 update db cfg for using MAX_LOG 30
$db2 update db cfg for using LOCKTIMEOUT 15
$db2 force applications all
$db2stop
$db2start
$db2 backup db mydb online to /DBBACKUP include logs
$db2 list history backup all for
注:支持在线备份使用的是V9以下版本的方式,V9以上略有不同
收起