Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Informix Topics / January 2005

Tip: Looking for answers? Try searching our database.

How many locks have been used?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
malcolm weallans - 31 Jan 2005 09:24 GMT
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
Bill Dare - 31 Jan 2005 13:08 GMT
> -----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
Doug Lawry - 31 Jan 2005 13:11 GMT
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
Paul Watson - 31 Jan 2005 13:32 GMT
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          #

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.