Rajendra Jamadagni (rajendra@sis6000.fujitsu.com.au) wrote:
: Hi netters,

: 	fow last few weeks i have been noticing following error in 
: 	II_SYSTEM/files/errlog.log. The error says, 


:       ::[1059            , 005E2040]: Thu Jun 15 09:44:04 1995 
: 		E_DM9041_LK_ESCALATE_TABLE	Maximum number of locks for 
: 		transaction exceeded. Escalating to table level lock on 
: 		table ii_srcobj_encoded        in database cs_fsms. 

: 	what does this exactly means, and how do i get over with this. we have 
: 	Server - ICL DRS6000 Ingres 6.4/05/02

It would appear you are running out of locks...  Under normal circumstances,
you request a number of pages to be locked and they are given to you.  However,
if doing this will a) exceeded your maxlocks b) exceeded the max locks for your
transaction or c) exceed maximum locks for the installation, then your resource
requested will attempt to escalate to a page lock request (as an attempt to 
satisfy your lock despite your request exceeding some limit).

This in itself is not too harmless but does give an indication that you may
have too much overflow in tables, need to increase your max locks/txn values
or you have not configured your lg/lk system for enough users.

: 	btw i tried using a small sql script which appears in release notes
: 	to calculate number of locks needed, but it does not work. ie even
: 	after waiting for half an hour, it refuses to comeout with any output. 
: 	does anyone has any script which does similar job ??

I'm not familiar with that script.  However, you should see a fairly good
calculation in mkrcpconfig (under utility).

: 	also does anyone knows if setting cache limits on PC side helps,
: 	when i have smartdrive running (under openroad)??

This won't make a difference to the number of locks taken, but anything that 
reduces the time that a lock is held will improve your concurrency.

Cheers

Jon
--
#include 
+--------------------Reply to jonm@ingres.com-----------------------+
| Remember when you could wake up in the morning, beat a harp seal, |
| disembowel your sister's dolly and still have change left over    |
| for a movie?                                                      |
+-------------------------------------------------------------------+
| Jon Machtynger(jonm@ingres.com)                                   |
| Bvd de la Woluwe 34 Bte. 13                                       |
| Brussels. Belgium. (+32)  Ph: 02-774 49 23 Fax: 02-773 28 09      |
+-------------------------------------------------------------------+

Ingres Q & A

To William's Home Page

© William Yuan 2000

Email William