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