Hi Martin,
Thanks for your comments,
Yes theses values are large, (too large).
I'm looking to understand how to manage theses parameters in a environment
where applications use Transaction processing (commit / rollback) with
little records
in a pure relational schema (header files and details files - not mv'ed).
This acquire many locks on update step.
I run a 70 users / system with device licensing where users start easy 2
telnets and there is rpc application on the side. I count +- 200 started
sessions.
Actually, I've got many Collision, Retries into the analyze.shm -s
I'll probably conclude to increase the GSEMNUM to give more processing
versus give more space by expend TABSZ.
About GLTABSZ equal RLTABSZ, If I understand correctly, if two records held
in the same groupid, the GLTABSZ use one place and the RLTASZ use two places
to store the locks.
My application works with a majority of little records, frequently updated
(accumulators)
With a RLTAB gt GLTAB, I suppose I'm able to manage more records locks for
one grouplocks ; Is'n it ?
Any comment are welcome to help my understanding.
With kind regards.
Manu
----- Original Message -----
From: "Martin Phillips" <[EMAIL PROTECTED]>
To: <u2-users@listserver.u2ug.org>
Sent: Tuesday, July 18, 2006 11:05 AM
Subject: Re: [U2] [UV] gsemnum,gltabsz,rltabsz - on NT
Hi Manu,
These do seem to be some very large numbers.
GSEMNUM=241, GLTABSZ=150, RLTABSZ=375, RLOWNNER=375
This gives a record lock table with 90,000 items in it. Ok, because of how
locking works you would be very unlikely to be able to use all 90,000 but
this still seems very large. Do you really need this many?
Also, GLTABSZ and RLTABSZ default to be the same value because, given a
large random access database, it is likely that each record lock is in a
separate group and hence has a separate informational group lock.
Martin Phillips
Ladybridge Systems
17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
+44-(0)1604-709200
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
