informix 11 版 數(shù)據(jù)清理經(jīng)常報(bào)211、244等錯(cuò)誤，尋求解決辦法。

rb_sp

2012-11-26 04:00:06.051 [CSXML-APP-ThreadPool-15] ERROR com.csii.batch.job.dataClear.ibs.DailyJnlClearJobService - org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [IX000]; error code [-211];   --- The error occurred in META-INF/config/sql-mapping/sql.xml.  
--- The error occurred while executing update.  
--- Check the    insert into ibsjnlqueryloghist_201210     select * from IBSJNLQUERYLOG where TRANSDATE >= ? AND TRANSDATE < ?   .  
--- Check the SQL Statement (preparation failed).  
--- Cause: java.sql.SQ
.ibs.DailyJnlClearJobService - java.lang.RuntimeException: org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [IX000]; error code [-211];   
--- The error occurred in META-INF/config/sql-mapping/sql.xml.  
--- The error occurred while executing update.  
--- Check the    insert into ibsjnlqueryloghist_201210     select * from IBSJNLQUERYLOG where TRANSDATE >= ? AND TRANSDATE < ?   .  
--- Check the SQL Statement (preparation failed).  
--- Cause: java.sql.SQLException: Cannot read system catalog (sysfragments).;
mework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [IX000]; error code [-244];   
--- The error occurred in META-INF/config/sql-mapping/sql.xml.  
--- The error occurred while applying a parameter map.  
--- Check the batch.getLastTableCount-InlineParameterMap.  
--- Check the statement (query failed).  
--- Cause: java.sql.SQLException: Could not do a physical-order read to fetch next row.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in META-INF/config/sql-mapping/sql.xml.  
nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in META-INF/config/sql-mapping/sql.xml.  
--- The error occurred while executing update.  
--- Check the    insert into ibsjnlqueryloghist_201210     select * from IBSJNLQUERYLOG where TRANSDATE >= ? AND TRANSDATE < ?   .  
--- Check the SQL Statement (preparation failed).  
--- Cause: java.sql.SQLException: Cannot read system catalog (sysfragments).
2012-11-26 04:00:06.054 [CSXML-APP-ThreadPool-4] ERROR com.csii.batch.job.dataClear.ibs.HistoryTableMonthDataClearJobService - org.springfra
-- The error occurred while applying a parameter map.  
--- Check the batch.getLastTableCount-InlineParameterMap.  
--- Check the statement (query failed).  
--- Cause: java.sql.SQLException: Could not do a physical-order read to fetch next row.
LException: Cannot read system catalog (sysfragments).; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in META-INF/config/sql-mapping/sql.xml.  
--- The error occurred while executing update.  
--- Check the    insert into ibsjnlqueryloghist_201210     select * from IBSJNLQUERYLOG where TRANSDATE >= ? AND TRANSDATE < ?   .  
--- Check the SQL Statement (preparation failed).  
--- Cause: java.sql.SQLException: Cannot read system catalog (sysfragments).
2012-11-26 04:00:06.051 [CSXML-APP-ThreadPool-15] ERROR com.csii.batch.job.dataClear


--java代碼：ibsTxTemplate.execute(new TransactionCallback() {                       
        public Object doInTransaction(TransactionStatus arg0) {                                                       
        logger.info("==="+tablename+"  bakup===");
        try{
             sqlMap.insert("batch.bakdata"+tablename, map);
             logger.info("==="+tablename+"  delete ===");
             sqlMap.delete("batch.delete"+tablename, map);
             logger.info("==="+tablename+"  delete end ===");
        }catch (Exception e) {

IBATIS查詢SQL                                                       
<insert id="bakdataIBSJNL" parameterClass="java.util.HashMap">
        insert into IBSJNLHIST_$lastMonth$
        select * from IBSJNL where TRANSDATE >= #BeginDate# AND TRANSDATE &lt; #EndDate#
</insert>



--211錯(cuò)誤碼的解釋
-211        不能讀取系統(tǒng)目錄<目錄表>。

數(shù)據(jù)庫(kù)服務(wù)器在處理大多數(shù)語(yǔ)句時(shí)參照系統(tǒng)目錄表。當(dāng)不能讀取這些重要的表時(shí)就產(chǎn)
生了嚴(yán)重的錯(cuò)誤。檢查伴隨的ISAM錯(cuò)誤代碼以獲得更多的信息。錯(cuò)誤的影響取決于正
在執(zhí)行的語(yǔ)句和特定的表，如下所示。

    *   CREATE TABLE語(yǔ)句，systabauth不能讀��；該表可以被建立，但不能象正常
        情況一樣授權(quán)給PUBLIC。

    *   DROP TABLE語(yǔ)句，systables不能讀��；不做任何動(dòng)作。

    *   DROP TABLE語(yǔ)句，sysviews不能讀取；該表將被取消，但任何依賴于該表的
        視圖將不能被自動(dòng)取消。

    *   DROP VIEW語(yǔ)句，sysviews不能讀��；不做任何動(dòng)作。

    *   DROP INDEX語(yǔ)句，systables或sysindexs不能讀取；不做任何動(dòng)作。

    *   DROP SYNONYM語(yǔ)句，systables或syssynonyms不能讀取；不做任何動(dòng)作。

    *   DROP DATABASE語(yǔ)句，systables不能讀�。徊蛔鋈魏蝿�(dòng)作。

    *   START DATABASE語(yǔ)句，systables不能讀��；不做任何動(dòng)作。

    *   DATABASE語(yǔ)句，systables或sysusers不能讀取；該數(shù)據(jù)庫(kù)不被選中
        (沒(méi)有當(dāng)前數(shù)據(jù)庫(kù)，后來(lái)的操作見(jiàn)錯(cuò)誤-349)。


現(xiàn)在數(shù)據(jù)在數(shù)據(jù)清理及備份到歷史表的數(shù)據(jù)時(shí)，informix庫(kù)經(jīng)常出錯(cuò)。
尋求解決辦法，
謝謝。

liaosnet

在SQL中增加臟讀或者鎖等，或者兩者都加上看下。。
--ADD HERE
set lock mode to wait 30;
--set isolation to dirty read;
        insert into IBSJNLHIST_$lastMonth$
        select * from IBSJNL where TRANSDATE >= #BeginDate# AND TRANSDATE &lt; #EndDate#