RE: Row / Page Locking?
Marco
On a heavily used system it can take a significant time to run,
is not as simple to extract the lock level (output needs to be
run through awk or perl or something) and output to screen,
especially with many detached indexes, produces copious output
(particularly if extents have 'got away' )
Keith
-> -----Original Message-----
-> From: Marco Greco [mailto:marco@4glworks.com]
-> Sent: Tuesday, February 22, 2005 12:21 PM
-> To: informix-list@iiug.org
-> Cc: Claus Samuelsen
-> Subject: Re: Row / Page Locking?
->
->
-> Hmmmm, after three or four sql based answers, one cannot but
-> wonder whatever
-> happened to oncheck -pt database:tablename?
->
-> Claus Samuelsen wrote:
-> > Geezer From The Freezer wrote:
-> >
-> >>Whats the best way to find out if a table is being row or
-> page locked?
-> >
-> >
-> > SELECT locklevel FROM systables WHERE tabname = 'tablename';
-> >
-> > 'R' = row, 'P' = page
-> >
-> >
-> >
->
->
-> --
-> Ciao,
-> Marco
-> _____________________________________________________________
-> _________________
-> Marco Greco /UK /IBM Standard
-> disclaimers apply!
->
-> Informix faq
http://www.iiug.org/techinfo/faq/informix.htm
4glworks http://www.4glworks.com
Informix on Linux http://www.4glworks.com/ifmxlinux.htm
sending to informix-list
**********************************************************************************
This message is sent in strict confidence for the addressee only. It may
contain legally privileged information. The contents are not to be disclosed
to anyone other than the addressee. Unauthorised recipients are requested
to preserve this confidentiality and to advise the sender immediately of any
error in transmission.
This footnote also confirms that this email message has been swept for the
presence of computer viruses, however we cannot guarantee that this message
is free from such problems.
**********************************************************************************
sending to informix-list