国庆期间,应用人员打电话说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 条评论