IDS Forum

Re: Informix 9.21/HP.UX 11 : no more locks.

Posted By: Ravi T
Date: Tuesday, 6 January 2004, at 10:17 a.m.

In Response To: Re: Informix 9.21/HP.UX 11 : no more locks. (Obnoxio The Clown)

Also, make sure you have a CLOSE cursor statement after your deletes are done to assure the cursor is closed because opened cursors do not release locks !

"Obnoxio The...." <obnoxio@hotmail.com> wrote:Try change the program in one of three ways:

1. LOCK TABLE before you start deleting.
2. Use a CURSOR WITH HOLD to delete a set of rows, COMMIT WORK and then
continue deleting.
3. Find another way of deleting fewer rows at a time (like deleting rows
older than 100 days, for instance)

--
Bye now,
Obnoxio

"C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule"
- Coluche

"Necrophilia means never having to say ... well, anything!"
- Captain Pedantic

"Ogni uomo mi guarda come se fossi una testa di cazzo"
- Marco




>From: "JEYAKANTHAN...."
>To: ids@iiug.org
>Subject: Re: Informix 9.21/HP.UX 11 : no more locks. [2416] Date: Tue, 6
>Jan 2004 06:30:06 -0500 (EST)
>Received: from ace.iiug.org ([216.177.38.212]) by mc11-f4.hotmail.com with
>Microsoft SMTPSVC(5.0.2195.6713); Tue, 6 Jan 2004 04:40:13 -0800
>Received: from ace.iiug.org (localhost [127.0.0.1])by ace.iiug.org
>(8.12.10-14/8.12.8) with ESMTP id i06Ba74S027089;Tue, 6 Jan 2004 07:23:53
>-0500 (EST)
>Received: (from nobody@localhost)by ace.iiug.org (8.12.10-14/8.12.8/Submit)
>id i06BU66Q026957;Tue, 6 Jan 2004 06:30:06 -0500 (EST)
>X-Message-Info: UZmYcfFpTCdJ5BGElTWioO4ZVxYFWObZ
>Message-Id: <200401061130.i06BU66Q026957@ace.iiug.org>
>Apparently-To: forum.subscriber@iiug.org
>Precedence: bulk
>Return-Path: nobody@ace.iiug.org
>X-OriginalArrivalTime: 06 Jan 2004 12:40:13.0845 (UTC)
>FILETIME=[3AFB2450:01C3D452]
>
>Thanks so much for the responses. It helped me a lot.
>
>The accompanying ISAM error code is 134. (no more locks).
>
>I changed the paramemters(locks ...) in onconfig and re-started the
>Informix Server. It didn't work.
>
>The data is being inserted/updated into the database by more than one ways.
>Stored Procedures, Informatica(ETL), Perl Scripts etc.
>
>Finally, I narrowed down the issue to a particular program which does the
>house keeping. This is program deletes the records which are more than 90
>days old. I have suspended that program. I am still not clear on how I am
>going to tune/trouble shoot this program. This program is holding too many
>locks. I ran the update statistics to ensure the this program uses the
>index to search.
>
>Thanks and regards
>Jeya
>
>

_________________________________________________________________
Use MSN Messenger to send music and pics to your friends
http://www.msn.co.uk/messenger




---------------------------------
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes

Messages In This Thread

• Informix 9.21/HP.UX 11 : no more locks.
  JEYAKANTHAN KULASEKARAM -- Monday, 5 January 2004, at 6:57 a.m.
  • RE: Informix 9.21/HP.UX 11 : no more locks.
    Obnoxio The Clown -- Monday, 5 January 2004, at 8:25 a.m.
  • Antw: IDS: Informix 9.21/HP.UX 11 : no more locks.
    Andreas.KUTSCHE@spar.at -- Monday, 5 January 2004, at 9:28 a.m.
  • Re: Informix 9.21/HP.UX 11 : no more locks.
    preetinder dhaliwal -- Monday, 5 January 2004, at 4:16 p.m.
  • Re: Informix 9.21/HP.UX 11 : no more locks.
    JEYAKANTHAN KULASEKARAM -- Tuesday, 6 January 2004, at 6:30 a.m.
    • Re: Informix 9.21/HP.UX 11 : no more locks.
      Obnoxio The Clown -- Tuesday, 6 January 2004, at 7:47 a.m.
      • Re: Informix 9.21/HP.UX 11 : no more locks.
        Ravi T -- Tuesday, 6 January 2004, at 10:17 a.m.
    • RE: Informix 9.21/HP.UX 11 : no more locks.
      NormaJean.Sebastian@tellabs.com -- Tuesday, 6 January 2004, at 8:34 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.