db2备份数据库表
CONNECT TO STHK0601;EXPORT TO "df" OF DEL SELECT * FROM DB2ADMIN.LINK;
CONNECT RESET;
import fromc:\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 文件中每行以 ; 结尾
页:
[1]