backup

来源：互联网发布：ipad进入淘宝卖家中心编辑：程序博客网时间：2024/05/17 03:51

backdb2.sql is below:

CONNECT to xm USER xm USING passw0rd;
LIST APPLICATIONS FOR DATABASE xm;
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
CONNECT RESET;
BACKUP DB xm TO "D:/";
CONNECT to xm USER xm USING passw0rd;
UNQUIESCE DATABASE;
TERMINATE;

Execute this command on cmd to backup xm: db2 -tvf backdb2.sql

On linux:

Chown –R db2inst1 /back

backdb2.sql is below:

CONNECT to xm USER xm USING passw0rd;
LIST APPLICATIONS FOR DATABASE xm;
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
CONNECT RESET;
BACKUP DB xm TO "/back";
CONNECT to xm USER xm USING passw0rd;
UNQUIESCE DATABASE;
TERMINATE;

Execute this command on cmd to backup xm: su – db2inst1 ,bash, db2 -tvf backdb2.sql

How to restore xm:

connect to xm user xm using passw0rd;

LIST APPLICATIONS FOR DATABASE xm;

QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;

CONNECT RESET;

RESTORE DATABASE xm FROM c:/xm;

connect to xm USER xm using passw0rd;

UNQUIESCE DATABASE;

TERMINATE;