db2解决load后系统空间不足问题

在load导入因为操作系统空间不够，导致load失败，以后再访问这个目标表会出现如下问题
Severity Timestamp Node Thread Message Code Message
INFO 2012/9/10 17:01:23 node01_TK_etlt WRITER_1_*_1 WRT_8164 Error loading into target [ETL_TESTXX5000] :
[IBM][CLI Driver][DB2/AIX64] SQL0668N Operation not allowed for reason code "3" on table "DB2INST1.ETL_TESTXX5000". SQLSTATE=57016
sqlstate = 57016[@more@]

[IBM][CLI Driver][DB2/AIX64] SQL0668N Operation not allowed for reason code "3" on table "DB2INST1.ETL_TESTXX5000". SQLSTATE=57016
sqlstate = 57016

Turning off DB2 bulk mode (CLI load) failed.
Database driver error...
Function Name : Close

DB2 Fatal Error
解决方法：
db2 "load from /dev/null of del terminate into db2inst1.etl_test10000 nonrecoverable"

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7490392/viewspace-1059429/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7490392/viewspace-1059429/