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: ***@utah.gov
To: informix-***@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