DB2崩溃恢复后表空间异常模拟

1.新建一个表空间ts1存储路径是/home/test/file
[test@demo SQL00001]$ db2 "create tablespace ts1 managed by database using (file '/home/test/file' 10M)"
DB20000I  The SQL command completed successfully.
[test@demo ~]$ pwd
/home/test
[test@demo ~]$ ls
dlockmon  file  sqllib  SQLOGDIR  test

2.在表空间ts1上创建一张表
[test@demo ~]$ db2 "create table tb2(id int,name varchar(10)) in ts1"

3.执行一个大事务
[test@demo ~]$ db2 "begin atomic declare i int default 0;while (i<1000000) do insert into tb2 values(i,'yo'||char(i));set i=i+1;end while;end"

4.另一个窗口暴力kill掉db2进程
[root@demo Desktop]# ps -ef|grep db2sysc
root      3829 29534  0 15:39 pts/3    00:00:00 grep db2sysc
db2inst1  8676  8674  0 04:38 ?        00:00:05 db2sysc                                        
test     25270 25268  0 02:49 pts/1    00:01:30 db2sysc                                        
[root@demo Desktop]# kill -9 25270
[root@demo Desktop]# ps -ef|grep db2sysc
root      3874 29534  0 15:39 pts/3    00:00:00 grep db2sysc
db2inst1  8676  8674  0 04:38 ?        00:00:05 db2sysc   

5.db2停止，SQL命令失败
[test@demo ~]$ db2 "begin atomic declare i int default 0;while (i<1000000) do insert into tb2 values(i,'yo'||char(i));set i=i+1;end while;end"
DB21034E  The command was processed as an SQL statement because it was not a 
valid Command Line Processor command.  During SQL processing it returned:
SQL1224N  The database manager is not able to accept new requests, has 
terminated all requests