db2备份数据库表

qq78707

CONNECT TO STHK0601;
EXPORT TO "df" OF DEL SELECT * FROM DB2ADMIN.LINK;
CONNECT RESET;


import from  c:\lin.sql of del insert into db2admin.link (LINK_ID, LINK_N
AME, HEAD_NODE_ID, TAIL_NODE_ID, LINK_FLAG, LINK_TYPE, LINK_LENGTH, SPEED_LIMIT,
LINK_ONEWAY)


import 时
SQL3306N An SQL error "-964" occurred while inserting a row into the table. SQL0964C The
调整如下参数

数据库的事务日志满了，调大以下几个数据库参数
Log file size (4KB)                         (LOGFILSIZ)
Number of primary log files                (LOGPRIMARY)
Number of secondary log files               (LOGSECOND)


CONNECT TO STHK0601;
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
CONNECT RESET;
BACKUP DATABASE STHK0601 TO "C:\" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;
CONNECT TO STHK0601;
UNQUIESCE DATABASE;
CONNECT RESET;


SQL>@$PATH/filename.sql;
DB2 可以这样实现﹕
db2 -tvf $PATH/filename.sql 文件中每行以 ; 结尾