db2解決load後系統空間不足問題

guyuanli發表於2012-09-14
在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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章