How many locks have been used?

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 whenwe 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@teranews... > > 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 #