I am trying to determine how many locks have been used
or are currently being used. On IDS 9.3 we can do an
onstat -k and look at the last line of output but when
we try to do the same with IDS 9.4 the onstat -k often
hangs. It seems that the onstat -k is OK for small
numbers of locks but when the number of locks in use
grows it seems that onstat -k has problems. Has
anybody else seen this?

I am running IDS 9.40.FC3 on AIX 5.2.

regards

Malcolm
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

!

--
Regards,
Doug Lawry
www.douglawry.webhop.org


"malcolm weallans" <malcolm.iiug@btopenworld.com> wrote in message
news:1107169828.9a4acae707bd45453ee3277b3e145595@t eranews...
>
> I am trying to determine how many locks have been used
> or are currently being used. On IDS 9.3 we can do an
> onstat -k and look at the last line of output but when
> we try to do the same with IDS 9.4 the onstat -k often
> hangs. It seems that the onstat -k is OK for small
> numbers of locks but when the number of locks in use
> grows it seems that onstat -k has problems. Has
> anybody else seen this?
>
> I am running IDS 9.40.FC3 on AIX 5.2.
>
> regards
>
> Malcolm
> sending to informix-list

select * from syslocks is a good starting point

malcolm weallans wrote:

> I am trying to determine how many locks have been used
> or are currently being used. On IDS 9.3 we can do an
> onstat -k and look at the last line of output but when
> we try to do the same with IDS 9.4 the onstat -k often
> hangs. It seems that the onstat -k is OK for small
> numbers of locks but when the number of locks in use
> grows it seems that onstat -k has problems. Has
> anybody else seen this?
>
> I am running IDS 9.40.FC3 on AIX 5.2.
>
> regards
>
> Malcolm
> sending to informix-list


--
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 #