DB2 删除

删除数据库：

su - <db instance user>

db2 drop database <dbname>

 

删除实例：

su - root

cd /<db2 install directory>/instance  例如：/opt/ibm/db2/V9.7/instance

./db2idrop -f <instance name>

 

删除das：

su - root

cd /<db2 install directory>/instance  例如：/opt/ibm/db2/V9.7/instance

./dasdrop <das user>

 

删除DB2软件：

su - root

cd /<db2 install directory>/install  例如：/opt/ibm/db2/V9.7/install

./db2_deinstall -a

 

删除DB2用户：

userdel -r <username>

 

删除表数据：

1. delete from <table name>：速度最慢

 

2. alter table <tablename> activate not logged initially with empty table：速度最快

 

3. load from /dev/null of del replace into <tablename> nonrecoveralbe

 

4. drop table <tablename>;

    create table <tablename>...

 

a. 创建空文件

b. import from empty.del of del replace into <table name>

 

4. truncate table <table name> immediate

 

5. alter table <table name> activate not logged intially

   delete from <tablename> where id > 10000