II 2.6/0305 (su9.us5/00)

I'm getting...

DAVE::[32978 , 000000010fb08200]: Fri Oct 22 09:46:13 2004
E_DMA00D_TOO_MANY_LOG_LOCKS This lock list cannot acquire any more logical
locks. The lock list status is 00000000, and the lock request flags were
00000009. The lock list currently holds 1500 logical locks, and the maximum
number of locks allowed is 1500. The configuration parameter controlling
this resource is ii..rcp.lock.per_tx_limit.
DAVE::[32978 , 000000010fb08200]: Fri Oct 22 09:46:13 2004
E_DM004B_LOCK_QUOTA_EXCEEDED Lock quota exceeded.
DAVE ::[32978 , 000000010fb08200]: Fri Oct 22 09:46:13 2004
E_DM9041_LK_ESCALATE_TABLE Maximum number of locks for transaction
exceeded. Escalating to table-level lock on table iixprotect in database
SMITH.

iixprotect is an index for iiprotect, how come iixprotect gets escalated but
the base table doesn't?

I have set the pagesize for system catalogues to 8k - should I have leave
them to 2k?

I know this table is used for security, is it only used if C2 level is
installed (siwtched on accidently)?



Gareth
English:- This message is confidential. If you are not the intended
recipient of the message then please notify the sender immediately. Any of
the statements or comments made above should be regarded as personal and not
necessarily those of Bro Morgannwg NHS Trust, any constituent part or
connected body. Cymraeg:- Mae'r neges hon yn gyfrinachol. Os nad chi yw'r
derbynnydd y bwriedid y neges ar ei gyfer, byddwch mor garedig â rhoi gwybod
i'r anfonydd yn ddi-oed. Dylid ystyried unrhyw ddatganiadau neu sylwadau a
wneir uchod yn rhai personol, ac nid o angenrhaid yn rhai o eiddo
Ymddiriedolaeth GIG Bro Morgannwg, nac unrhyw ran gyfansoddol ohoni na
chorff cysylltiedig.