在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@]
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博客 ” ，链接：https://blog.itpub.net/7490392/viewspace-1059429/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
db2不记录日志插入记录
请登录后发表评论
登录
全部评论
