RE: ER Problem

Your table is locked. Before starting cdr check, try to: $ export IFX_DIRTY_WAIT=600and then try to execute cdr check again. If it does repeat, there seems to be any session/application that is locking the table (maybe a defunct process?) Hope it helps. Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Informix Senior DBA - Orizon Brasil BRIUG website administrator Informix independent consultant Date: Wed, 8 May 2013 12:05:25 -0600 Subject: ER Problem From: lgustin@utah.gov To: informix-list@iiug.org IDS 11.7 FC7Linux Im getting this error when I try to run cdr chek on a single replicate. cdr check repl -m g_psprod1sl -r abc_checks_incident_status -a Error returned from getNumRows: select count(*) from 'informix'.incident_statusSQLCODE -252 ISAM -154 Error Details: 252: Cannot get system information for table. 154: ISAM error: Lock Timeout Expired Current Connection:conn4, Database:@g_psprod1sl command failed -- SQL failure (195) I have stopped and restarted ER , and deleted and recreated the replicate. Any clues? Thanks!Laurie _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list