> -----Original Message-----
> From: owner-informix-list@iiug.org [SMTP:owner-informix-list@iiug.org]
[quoted text clipped - 13 lines]
>
> I am running IDS 9.40.FC3 on AIX 5.2.
[Bill Dare]
I am on the same platform and have had no problems. Normally we
have about 4000 locks. I have a monitor script to keep an eye on locks
and it has reported errors when users have as many as 500,000 locks.
The script uses onstat -k and it works fine.
Bill
> regards
>
> Malcolm
> sending to informix-list
sending to informix-list
Hi Malcolm.
I use this:
# Display Informix locks - Doug Lawry, 16/04/03
(dbaccess sysmaster 2>&1 | egrep '^[a-z]') <<!
SELECT dbsname [1,18] database,
tabname [1,18] table,
username [1,08] user,
type lock,
tty [6,12] tty,
pid ::SMALLINT process,
count(*) ::SMALLINT number
FROM syslocks,
syssessions
WHERE dbsname != "sysmaster"
AND sid = owner
GROUP BY 1, 2, 3, 4, 5, 6
ORDER BY 1, 2, 3, 4, 5, 6
!

Signature
Regards,
Doug Lawry
www.douglawry.webhop.org
> I am trying to determine how many locks have been used
> or are currently being used. On IDS 9.3 we can do an
[quoted text clipped - 11 lines]
> Malcolm
> sending to informix-list
select * from syslocks is a good starting point
> I am trying to determine how many locks have been used
> or are currently being used. On IDS 9.3 we can do an
[quoted text clipped - 11 lines]
> Malcolm
> sending to informix-list

Signature
Paul Watson #
Oninit Ltd # Growing old is mandatory
Tel: +44 1436 672201 # Growing up is optional
Fax: +44 1436 678693 #
Mob: +44 7818 003457 #
www.oninit.com #