ER Problem

[Laurie Gustin]

IDS 11.7 FC7

Linux

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_status

SQLCODE -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

[Alexandre Marini]

Your table is locked.

Before starting cdr check, try to:
$ export IFX_DIRTY_WAIT=600
and 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: lgu...@utah.gov
To: inform...@iiug.org

_______________________________________________ Informix-list mailing list Inform...@iiug.org http://www.iiug.org/mailman/listinfo/informix-list