李英杰
作者李英杰·2012-10-09 11:32
数据库技术专家·烁林软件

DB2数据库访问表报SQL0668 reason code "3“

字数 3095阅读 7935评论 0赞 1

国庆期间,应用人员打电话说DB2数据库访问一张表报错,错误码为SQL0668 reason code "3",此表处于Load Pending状态,通过LOAD QUERY查询此表:

$ db2 load query table datacore.in_zs
SQL1193I  The utility is beginning to load data from the SQL statement "INSERT
INTO IN_ZS VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ...".

SQL3500W  The utility is beginning the "LOAD" phase at time "10/01/2012
01:19:17.441871".

SQL3519W  Begin Load Consistency Point. Input record count = "0".

SQL3520W  Load Consistency Point was successful.

SQL2044N  An error occurred while accessing a message queue.  Reason code:
"4".

SQL3532I  The Load utility is currently in the "LOAD" phase.


Number of rows read         = 0
Number of rows skipped      = 0
Number of rows loaded       = 0
Number of rows rejected     = 0
Number of rows deleted      = 0
Number of rows committed    = 0
Number of warnings          = 0

Tablestate:
  Load Pending

应用程序报:

Severity Timestamp Node Thread Message Code Message
ERROR 2012-10-1 2:02:54 node01_bbdcrpt04 WRITER_1_*_1 WRT_8229 发生数据库错误:
[IBM][CLI Driver][DB2/AIX64] SQL2044N  An error occurred while accessing a message queue.  Reason code: "4".
 sqlstate =     

数据库驱动程序错误...
函数名称: Execute
SQL 语句: INSERT INTO IN_ZS_HIS(DATADATE,CURRNO,CURRNAME,ACCTKIND,ACCTNO,ACCTNAME,ACCTYPE,SUBCTRCD,SUBNAME,BCHCD,BCHNAME,BALA,LBALA,MBALA,QBALA,YBALA,ACCMM,ACCMQ,ACCMY,AVERM,AVERQ,AVERY,LACCMM,LACCMQ,LACCMY,OPENDATE,MATUDATE,INTRATE,BALACTRLDIR,BALACTRLDIRNAME,SUBCTRLCODE,CURR_TRAN,BALA_TRAN,CURR_WB,CURR_BWB)  VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
本地错误代码 = -2044
DB2 致命错误
DB2 批量执行(CLI 加载)失败。

此LOAD操作为INFOMATIC程序发起,因此不能找到原始的LOAD语句,但查此时LOAD并未真正执行,所以执行如下命令取消LOAD状态,

$ db2 load from /dev/null of del RESTART into datacore.in_zs_his NONRECOVERABLE
SQL3531I  A LOAD RESTART has occurred.

SQL3109N  The utility is beginning to load data from file "/dev/null".

SQL3500W  The utility is beginning the "LOAD" phase at time "10/01/2012
10:19:14.791333".

SQL3519W  Begin Load Consistency Point. Input record count = "0".

SQL3520W  Load Consistency Point was successful.

SQL3110N  The utility has completed processing.  "0" rows were read from the
input file.

SQL3519W  Begin Load Consistency Point. Input record count = "0".

SQL3520W  Load Consistency Point was successful.

SQL3515W  The utility has finished the "LOAD" phase at time "10/01/2012
10:19:14.912994".


Number of rows read         = 0
Number of rows skipped      = 0
Number of rows loaded       = 0
Number of rows rejected     = 0
Number of rows deleted      = 0
Number of rows committed    = 0

 

再次查询此表,此表可以正常访问

如果觉得我的文章对您有用,请点赞。您的支持将鼓励我继续创作!

1

添加新评论0 条评论

Ctrl+Enter 发表

作者其他文章

相关问题

X社区推广