If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > ISAM error : Record is locked

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-10-10, 09:30
gokulakrishnan gokulakrishnan is offline
Registered User
 
Join Date: Dec 2010
Posts: 1
Post ISAM error : Record is locked

Can any one help me to fix this error. when i trying to connect the database it is showing message as " 908: Attempt to connect to database server (informix_db_tcp) failed.
ISAM error: record is locked." i have enclosed the screen short .

os: RHEL4
DB : informix 11.5
Attached Thumbnails
ISAM error : Record is locked-informixdberror.png  
Reply With Quote
  #2 (permalink)  
Old 12-15-10, 15:10
rpaskudniak rpaskudniak is offline
Registered User
 
Join Date: Feb 2009
Location: Brooklyn, NY
Posts: 5
The old 908 error when connecting, eh?

Looks like someone it running an operation that locks the database exclusively, like a dbexport or similar utility. Running onstat -k might show you a database lock with the X flag on in the lock type column. How recognize a database lock? This is merely a row lock on the database TBLspace. The TBSspace number of this TBLspace is something like 100002 (may be wider in a 64-bit server). Check out this page for a bit more information on locks.

It may also be that the server is still in middle of a long "fast recovery" and no databases are accessible. (I don't recall if I ever tried to access sysmaster during a fast recovery.) The top line of the onstat output should tell you the basic state of the server.

+ Rasputin Paskudniak ------------------------------+
| In pursuit of undomesticated, semi-aquatic avians |
+---------------------------------------------------+
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On