一、删除用户USER所有表:
db2 -x "select 'drop table '||tabname||';'from syscat.tables where tabschema ='USER'" > dropAllTables.sql
db2 -tf dropAllTables.sql
dropAllTables.sql文件内容如下(用户USER有表table1,table2):
drop table table1;
drop table table2;
二、重组用户USER所有表:
db2 -x "select 'reorg table '||tabname||';'from syscat.tables where tabschema ='USER'" > reorgAllTables.sql
db2 -tf reorgAllTables.sql
reorgAllTables.sql文件内容如下(用户USER有表table1,table2):
reorg table table1;
reorg table table2;
三、清除用户USER所有表数据:
db2 -x "select 'truncate table '||tabname||' immediate;'from syscat.tables where tabschema ='USER'" > deleteAllTables.sql
db2 -tf deleteAllTables.sql
truncate table tabname1 immediate;
truncate table tabname2 immediate;