Re:144 error when using dbaccess

Hi Gurus, I am trying to access some information using dbaccess. Dbaccess -> query-language -> choose the database -> info Then I get the 144: ISAM error: key value locked. Anybody has ideas? It is our production database. Please help. Thanks, Denny ******************************************* The information contained in this e-mail message may contain privileged and confidential information. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you have received this message in error, please notify the sender by return e-mail, delete this message and destroy any copies. Internet e- mail is not guaranteed to be secure or error-free. Messages could be intercepted, corrupted, lost, arrive late or contain viruses. The sender will not be liable for these risks. ******************************************* Ce message electronique pourrait contenir des informations privilegiees et confidentielles. Si vous n'en etes pas le recipiendaire prevu, nous vous signalons qu'il est strictement interdit d'examiner, de diffuser, de distribuer et de reproduire le present message. Si vous l'avez recu par erreur, veuillez prevenir l'expediteur par courriel, puis effacer ce message et en detruire toute copie. Le courrier electronique n'est pas garanti securitaire ni exempt d'erreurs. Les messages pourraient etre interceptes, corrompus, egares, retardes ou contamines par des virus. L'exp'editeur n'est pas responsable de ces risques .

Guo, Denny said: > > Hi Gurus, > > I am trying to access some information using dbaccess. > Dbaccess -> query-language > > -> choose the database > > -> info > > Then I get the 144: ISAM error: key value locked. > > Anybody has ideas? It is our production database. > Please help. What product? What version? What platform? -- Bye now, Obnoxio "... no bill is required as no value was provided." -- Christine Normile

Sorry, I forget to provide suc information. We are running Informix Dynamic Server Version 7.31.UD3 on Aix V4.3.3. Thanks, Denny -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Obnoxio The.... Sent: June 2, 2006 12:59 PM To: ids@iiug.org Subject: Re:144 error when using dbaccess [6858] Guo, Denny said: > > Hi Gurus, > > I am trying to access some information using dbaccess. > Dbaccess -> query-language > > -> choose the database > > -> info > > Then I get the 144: ISAM error: key value locked. > > Anybody has ideas? It is our production database. > Please help. What product? What version? What platform? -- Bye now, Obnoxio "... no bill is required as no value was provided." -- Christine Normile ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************* The information contained in this e-mail message may contain privileged and confidential information. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you have received this message in error, please notify the sender by return e-mail, delete this message and destroy any copies. Internet e- mail is not guaranteed to be secure or error-free. Messages could be intercepted, corrupted, lost, arrive late or contain viruses. The sender will not be liable for these risks. ******************************************* Ce message electronique pourrait contenir des informations privilegiees et confidentielles. Si vous n'en etes pas le recipiendaire prevu, nous vous signalons qu'il est strictement interdit d'examiner, de diffuser, de distribuer et de reproduire le present message. Si vous l'avez recu par erreur, veuillez prevenir l'expediteur par courriel, puis effacer ce message et en detruire toute copie. Le courrier electronique n'est pas garanti securitaire ni exempt d'erreurs. Les messages pourraient etre interceptes, corrompus, egares, retardes ou contamines par des virus. L'exp'editeur n'est pas responsable de ces risques .

Maybe your database has many active transaction when you try to access the info option. Try this: -> choise database -> query -> New -> write: 'set isolation to dirty read' -> Run the query -> try again the 'info' option. -----Mensaje original----- De: Guo, Denny [mailto:DGuo@livingstonintl.com] Enviado el: Viernes, 02 de Junio de 2006 11:54 a.m. Para: ids@iiug.org Asunto: Re:144 error when using dbaccess [6857] Hi Gurus, I am trying to access some information using dbaccess. Dbaccess -> query-language -> choose the database -> info Then I get the 144: ISAM error: key value locked. Anybody has ideas? It is our production database. Please help. Thanks, Denny ******************************************* The information contained in this e-mail message may contain privileged and confidential information. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you have received this message in error, please notify the sender by return e-mail, delete this message and destroy any copies. Internet e- mail is not guaranteed to be secure or error-free. Messages could be intercepted, corrupted, lost, arrive late or contain viruses. The sender will not be liable for these risks. ******************************************* Ce message electronique pourrait contenir des informations privilegiees et confidentielles. Si vous n'en etes pas le recipiendaire prevu, nous vous signalons qu'il est strictement interdit d'examiner, de diffuser, de distribuer et de reproduire le present message. Si vous l'avez recu par erreur, veuillez prevenir l'expediteur par courriel, puis effacer ce message et en detruire toute copie. Le courrier electronique n'est pas garanti securitaire ni exempt d'erreurs. Les messages pourraient etre interceptes, corrompus, egares, retardes ou contamines par des virus. L'exp'editeur n'est pas responsable de ces risques . **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

Thanks Julio, it works. Denny -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Julio Gerar.... Sent: June 2, 2006 1:02 PM To: ids@iiug.org Subject: RE: 144 error when using dbaccess [6860] Maybe your database has many active transaction when you try to access the info option. Try this: -> choise database -> query -> New -> write: 'set isolation to dirty read' -> Run the query -> try again the 'info' option. -----Mensaje original----- De: Guo, Denny [mailto:DGuo@livingstonintl.com] Enviado el: Viernes, 02 de Junio de 2006 11:54 a.m. Para: ids@iiug.org Asunto: Re:144 error when using dbaccess [6857] Hi Gurus, I am trying to access some information using dbaccess. Dbaccess -> query-language -> choose the database -> info Then I get the 144: ISAM error: key value locked. Anybody has ideas? It is our production database. Please help. Thanks, Denny ******************************************* The information contained in this e-mail message may contain privileged and confidential information. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you have received this message in error, please notify the sender by return e-mail, delete this message and destroy any copies. Internet e- mail is not guaranteed to be secure or error-free. Messages could be intercepted, corrupted, lost, arrive late or contain viruses. The sender will not be liable for these risks. ******************************************* Ce message electronique pourrait contenir des informations privilegiees et confidentielles. Si vous n'en etes pas le recipiendaire prevu, nous vous signalons qu'il est strictement interdit d'examiner, de diffuser, de distribuer et de reproduire le present message. Si vous l'avez recu par erreur, veuillez prevenir l'expediteur par courriel, puis effacer ce message et en detruire toute copie. Le courrier electronique n'est pas garanti securitaire ni exempt d'erreurs. Les messages pourraient etre interceptes, corrompus, egares, retardes ou contamines par des virus. L'exp'editeur n'est pas responsable de ces risques . ************************************************************************ **** *** Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************* The information contained in this e-mail message may contain privileged and confidential information. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you have received this message in error, please notify the sender by return e-mail, delete this message and destroy any copies. Internet e- mail is not guaranteed to be secure or error-free. Messages could be intercepted, corrupted, lost, arrive late or contain viruses. The sender will not be liable for these risks. ******************************************* Ce message electronique pourrait contenir des informations privilegiees et confidentielles. Si vous n'en etes pas le recipiendaire prevu, nous vous signalons qu'il est strictement interdit d'examiner, de diffuser, de distribuer et de reproduire le present message. Si vous l'avez recu par erreur, veuillez prevenir l'expediteur par courriel, puis effacer ce message et en detruire toute copie. Le courrier electronique n'est pas garanti securitaire ni exempt d'erreurs. Les messages pourraient etre interceptes, corrompus, egares, retardes ou contamines par des virus. L'exp'editeur n'est pas responsable de ces risques .

Make sure that another user is not in a pending transaction for a new table creation or alter from within an interactive dbaccess session, thus locking up the system tables for that database. I have seen this many times in our pre-prod environment when developers start a session, create a new table but never back out of the interactive session or commit the changes. Joe Plugge -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Guo, Denny Sent: Friday, June 02, 2006 12:01 PM To: ids@iiug.org Subject: RE: 144 error when using dbaccess [6859] Sorry, I forget to provide suc information. We are running Informix Dynamic Server Version 7.31.UD3 on Aix V4.3.3. Thanks, Denny -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Obnoxio The.... Sent: June 2, 2006 12:59 PM To: ids@iiug.org Subject: Re:144 error when using dbaccess [6858] Guo, Denny said: > > Hi Gurus, > > I am trying to access some information using dbaccess. > Dbaccess -> query-language > > -> choose the database > > -> info > > Then I get the 144: ISAM error: key value locked. > > Anybody has ideas? It is our production database. > Please help. What product? What version? What platform? -- Bye now, Obnoxio "... no bill is required as no value was provided." -- Christine Normile ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************* The information contained in this e-mail message may contain privileged and confidential information. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you have received this message in error, please notify the sender by return e-mail, delete this message and destroy any copies. Internet e- mail is not guaranteed to be secure or error-free. Messages could be intercepted, corrupted, lost, arrive late or contain viruses. The sender will not be liable for these risks. ******************************************* Ce message electronique pourrait contenir des informations privilegiees et confidentielles. Si vous n'en etes pas le recipiendaire prevu, nous vous signalons qu'il est strictement interdit d'examiner, de diffuser, de distribuer et de reproduire le present message. Si vous l'avez recu par erreur, veuillez prevenir l'expediteur par courriel, puis effacer ce message et en detruire toute copie. Le courrier electronique n'est pas garanti securitaire ni exempt d'erreurs. Les messages pourraient etre interceptes, corrompus, egares, retardes ou contamines par des virus. L'exp'editeur n'est pas responsable de ces risques . ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

Joe, Yes, there is some user creating some temp table. Thanks, Denny -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Plugge, Joe R. Sent: June 2, 2006 1:09 PM To: ids@iiug.org Subject: RE: 144 error when using dbaccess [6862] Make sure that another user is not in a pending transaction for a new table creation or alter from within an interactive dbaccess session, thus locking up the system tables for that database. I have seen this many times in our pre-prod environment when developers start a session, create a new table but never back out of the interactive session or commit the changes. Joe Plugge -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Guo, Denny Sent: Friday, June 02, 2006 12:01 PM To: ids@iiug.org Subject: RE: 144 error when using dbaccess [6859] Sorry, I forget to provide suc information. We are running Informix Dynamic Server Version 7.31.UD3 on Aix V4.3.3. Thanks, Denny -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Obnoxio The.... Sent: June 2, 2006 12:59 PM To: ids@iiug.org Subject: Re:144 error when using dbaccess [6858] Guo, Denny said: > > Hi Gurus, > > I am trying to access some information using dbaccess. > Dbaccess -> query-language > > -> choose the database > > -> info > > Then I get the 144: ISAM error: key value locked. > > Anybody has ideas? It is our production database. > Please help. What product? What version? What platform? -- Bye now, Obnoxio "... no bill is required as no value was provided." -- Christine Normile ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************* The information contained in this e-mail message may contain privileged and confidential information. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you have received this message in error, please notify the sender by return e-mail, delete this message and destroy any copies. Internet e- mail is not guaranteed to be secure or error-free. Messages could be intercepted, corrupted, lost, arrive late or contain viruses. The sender will not be liable for these risks. ******************************************* Ce message electronique pourrait contenir des informations privilegiees et confidentielles. Si vous n'en etes pas le recipiendaire prevu, nous vous signalons qu'il est strictement interdit d'examiner, de diffuser, de distribuer et de reproduire le present message. Si vous l'avez recu par erreur, veuillez prevenir l'expediteur par courriel, puis effacer ce message et en detruire toute copie. Le courrier electronique n'est pas garanti securitaire ni exempt d'erreurs. Les messages pourraient etre interceptes, corrompus, egares, retardes ou contamines par des virus. L'exp'editeur n'est pas responsable de ces risques . ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************* The information contained in this e-mail message may contain privileged and confidential information. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you have received this message in error, please notify the sender by return e-mail, delete this message and destroy any copies. Internet e- mail is not guaranteed to be secure or error-free. Messages could be intercepted, corrupted, lost, arrive late or contain viruses. The sender will not be liable for these risks. ******************************************* Ce message electronique pourrait contenir des informations privilegiees et confidentielles. Si vous n'en etes pas le recipiendaire prevu, nous vous signalons qu'il est strictement interdit d'examiner, de diffuser, de distribuer et de reproduire le present message. Si vous l'avez recu par erreur, veuillez prevenir l'expediteur par courriel, puis effacer ce message et en detruire toute copie. Le courrier electronique n'est pas garanti securitaire ni exempt d'erreurs. Les messages pourraient etre interceptes, corrompus, egares, retardes ou contamines par des virus. L'exp'editeur n'est pas responsable de ces risques .