Row level lock

Hi, my name is Marcelo, we are running IDS 7.3 over SCO OpenServer 5.0.5. We need in one of our applications to lock a table at row level, but by default is set in page mode. The question is: - The DBA can update the systable for that table in column locklevel setting it with value "R". If it is like this, what else do I have to do to take effect this change in the table ? - The programmers must do anything in the 4gl source file ? Thank you for your response.

----LNX_Thu_Sep_18_2003_14:25:03_V3.33-- Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable >Datum: 2003.09.18 13:55:18 >Sender: MARCELO MUSRI <marmus@inv.gov.ar> > >Hi, my name is Marcelo, we are running IDS 7.3 over SCO OpenServer 5.0.5= =2E > >We need in one of our applications to lock a table at row level, butby >default is set in page mode. > >The question is: > >- The DBA can update the systable for that table in column locklevelsett= ing >it with value "R". If it is like this, what else do I have to do to take= effect >this change in the table ? = Check the SQL Syntax Manual. You can change the lock mode of a table with= ALTER TABLE ... = >- The programmers must do anything in the 4gl source file ? = No. But - you might need much more locks now when changing larger parts of the ta= ble! Onconfig parameter! - row level locking because of parallel requests? you may need fitting in= dices as well (if you do sequential scans theres no big difference in row or pageleve= l locking) = Regards, Andreas Kutsche = ------------------------------------------------ SPAR Oesterreichische Warenhandels-AG Hauptzentrale Europastra=DFe 3 A-5015 Salzburg = Telefon : +43 662 4470 24423 E-Mail : Andreas.KUTSCHE@spar.at Internet: http://www.spar.at ------------------------------------------------ = ----LNX_Thu_Sep_18_2003_14:25:03_V3.33----

Hi Marcello, Do not update the systables table yourself. This will cause an inconsistency. What you should do is give the 'alter table <tablename> lock mode (row)'command. This will update the systemcatalog in a nice manner. After this you don't have to change your application at all. The lock granularity only has become smaller so there shouldn't be any problem. The only thing your DBA should check if there are enough locks defined (parameter LOCKS in onconfig). Because the lock granularity is smaller there can be a situation where more locks are needed. Just to be sure. Greetz, Rob Prop -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On Behalf Of MARCELO MUSRI Sent: donderdag 18 september 2003 12:39 To: ids@iiug.org Subject: Row level lock [1899] Hi, my name is Marcelo, we are running IDS 7.3 over SCO OpenServer 5.0.5. We need in one of our applications to lock a table at row level, but by default is set in page mode. The question is: - The DBA can update the systable for that table in column locklevel setting it with value "R". If it is like this, what else do I have to do to take effect this change in the table ? - The programmers must do anything in the 4gl source file ? Thank you for your response. -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On Behalf Of MARCELO MUSRI Sent: donderdag 18 september 2003 12:39 To: ids@iiug.org Subject: Row level lock [1899] Hi, my name is Marcelo, we are running IDS 7.3 over SCO OpenServer 5.0.5. We need in one of our applications to lock a table at row level, but by default is set in page mode. The question is: - The DBA can update the systable for that table in column locklevel setting it with value "R". If it is like this, what else do I have to do to take effect this change in the table ? - The programmers must do anything in the 4gl source file ? Thank you for your response.

MARCELO MUSRI wrote: > Hi, my name is Marcelo, we are running IDS 7.3 over SCO OpenServer 5.0.5. > > We need in one of our applications to lock a table at row level, but by default is set in page mode. > > The question is: > > - The DBA can update the systable for that table in column locklevel setting it with value "R". If it is like this, what else do I have to do to take effect this change in the table ? I hope you mean, the DBA can run ALTER TABLE for each table to change the locklevel value in systables??? <gulp> They shouldn't be running UPDATEs on the systables table, or any other sys tables. That's all there is to do, except you may find you run out of locks, depending on how many are configured in your onconfig file. > - The programmers must do anything in the 4gl source file ? No Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+

I hope you haven't done this. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" - Coluche From: "MARCELO MUSRI" <marmus@inv.gov.ar> > >Hi, my name is Marcelo, we are running IDS 7.3 over SCO OpenServer 5.0.5. > >We need in one of our applications to lock a table at row level, but by >default is set in page mode. > >The question is: > >- The DBA can update the systable for that table in column locklevel >setting it with value "R". If it is like this, what else do I have to do to >take effect this change in the table ? > >- The programmers must do anything in the 4gl source file ? > >Thank you for your response. > _________________________________________________________________ Express yourself with cool emoticons - download MSN Messenger today! http://www.msn.co.uk/messenger