(3)执行 oatest.sql 脚本建立数据库
主要命令:
db2 -tvf oatest.sql
[db2inst1@devsvr2 db2inst1]$ cd oatest0303
[db2inst1@devsvr2 oatest0303]$ db2 -tvf oatest.sql
……
(4)执行 db2move 导入数据
主要命令:
db2move sample load
[db2inst1@devsvr2 oatest0303]$ db2move sample load
……
* LOAD: table "OATEST "."UM_USER"
-Rows read: 1529
-Loaded: 1529
-Rejected: 0
-Deleted: 0
-Committed: 1529
Disconnecting from database ... successful!
End time: Sun Mar 5 10:24:22 2006
(5)检查一致性
主要命令:
db2 set integrity for oatest.UM_USER immediate checked
[db2inst1@devsvr2 oatest0303]$ db2 connect to sample
数据库连接信息
数据库服务器 = DB2/LINUX 8.2.0
SQL 授权标识 = DB2INST1
本地数据库别名 = SAMPLE
[db2inst1@devsvr2 oatest0303]$ db2 "select count(*) from
oatest.um_user"
1
-----------
SQL0668N 由于表 "OATEST.UM_USER" 上的原因码 "1",所以不允许操作。
SQLSTATE=57016
[db2inst1@devsvr2 oatest0303]$ db2 set integrity for oatest.UM_USER
immediate checked
DB20000I SQL 命令成功完成。
[db2inst1@devsvr2 oatest0303]$ db2 "select count(*) from
oatest.um_user"
1
-----------
1529
1 条记录已选择。
利用 sql 语句得到要检查的表的执行语句
主要命令:
db2 "select 'db2 set integrity for oatest.'||TABNAME||' immediatechecked' from syscat.tables where TABSCHEMA='OATEST' and STATUS='C'"
[db2inst1@devsvr2 oatest0303]$ db2 "select 'db2 set
integrity for oatest.'||TABNAME||' immediate checked'
from syscat.tables where TABSCHEMA='OATEST' and STATUS='C'"
1
-----------------------------------------------------------------
db2 set integrity for oatest.CAL_AUTH immediate checked
……
db2 set integrity for oatest.UM_USER immediate checked
81 条记录已选择。
执行这 81 条语句,语句有可能报错
主要命令:
db2 set integrity for oatest. CAL_AUTH immediate checked
[db2inst1@devsvr2 oatest0303]$ db2 set integrity
for oatest.CAL_AUTH immediate checked
DB20000I SQL 命令成功完成。
[db2inst1@devsvr2 oatest0303]$ db2 set integrity
for oatest.UM_USER immediate checked
DB20000I SQL 命令成功完成。
…………
如果报错,再反复执行这些语句直到下面的语句结果返回 0 条记录
[db2inst1@devsvr2 oatest0303]$ db2 "select 'db2 set integrity
for oatest.'||TABNAME||' immediate checked' from syscat.tables
where TABSCHEMA='OATEST' and STATUS='C'"
1
---------------------------------------------------------------
0 条记录已选择。
32/3<123>