db2 Load锁表 后解锁详解

1、切换DB2用户并将目录指定到脚本所在位置:

su - db2inst1;

2、连接数据库:

db2 connect to ig;

3、清空表中残留数据:

db2 alter table configitem activate not logged initially with empty table;

4、向表中执行导入操作:

db2 load client from 'configitem.del' of del modified by delprioritychar insert into configitem;

5、此时,会锁表,执行如下操作查看:

db2 list tablespaces show detail;

翻至最后,显示:

 Tablespace ID                        = 7
 Name                                 = IGTABLESPACE
 Type                                 = Database managed space
 Contents                             = All permanent data. Large table space.
 State                                = 0x0020
   Detailed explanation:
     Backup pending
 Total pages                          = 36864