Re: DBA Monitoring-Table use
--0__=WamFr8WN5xvQrz1xsewU9RlhUDODzcjbpHYzhf29pgckRagAwMMVq750
Content-type: text/plain; charset=us-ascii
Content-Disposition: inline
Mary K. Gregory @ ECCI 11/13/98 04:17 PM
(Embedded image moved to file: pic05753.pcx)
I had the same need ...
Unix Script:
dbaccess sysmaster << EOF 2>> /dev/null
select syslocks.dbsname[1,10] DBName,
syslocks.tabname[1,15] Tabname,
a.username User,
syslocks.type LockType,
b.username WaitUser
from syslocks,
syssessions a,
outer syssessions b
where syslocks.owner = a.sid
and syslocks.dbsname <> "sysmaster"
and syslocks.waiter = b.sid
order by syslocks.dbsname, syslocks.tabname, a.username
EOF
This is essentially the same output at onstat -k, but in a format that you
can understand.
Dave McNight <dmcnight@bju.edu> on 11/13/98 02:23:54 PM
Please respond to 1700@iiug.org; Please respond to Wade@iiug.org; Please
respond to Hampton@iiug.org; Please respond to Blvd@iiug.org; Please
respond to Greenville@iiug.org; Please respond to SC@iiug.org; Please
respond to 29614@iiug.org
To: informix-list@iiug.org
cc: (bcc: Mary K. Gregory/AMPAC/ECCI)
Subject: DBA Monitoring-Table use
Dave McNight wrote:
>
> Does anyone have a good script/stored procedure on Unix runing ODS 7.24
> or 7.3 which would allow a DBA to monitor users and show what tables
> they are locking and in what mode? Maybe another way also, table xyz is
> being used by "n" users and here is the mode? This would be invaluable
> at certain times! Thanks in advance :-)
--0__=WamFr8WN5xvQrz1xsewU9RlhUDODzcjbpHYzhf29pgckRagAwMMVq750
Content-type: application/octet-stream;
name="pic05753.pcx"
Content-Disposition: attachment; filename="pic05753.pcx"
Content-transfer-encoding: base64
CgUBCAAAAADCAQ8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAABwwEBAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAP/wf/B/8H/wf/B/8H5QfSB8QHxw/ED8IPD/8L/QsPwwsPwwsPwwsPwwsP
wwsPwwsPwwsPwwsPwwsPwwsPwwsPwwsPwwsPwwsPwwsPwwsPwwsPwwsPwwsPwwsPCw8LD8MLDwsP
Cw8LDwsPCw8LDwsPCw8LDwsPC8MPCw8LDwvDDwvDDwvDDwvDDwvDDwvDDwvDDwvDDwvDDwvDDwvD
DwvDDwvDDwvDDwvDDwvDDwvDDwvDDwvDDwvDDwv/D+EP0Q/ID8QPwg8PD+ULD8cLD8MLD8MLD8ML
D8MLD8MLDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsP
Cw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8L
DwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsP
Cw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8L
DwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsP
Cw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPC8MPC8MPC8MPC8MPC8cPC9cPzA/G
D8MPDw//C/8L2AsPxwsPwwsPwwsPwwsPwwsPwwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8L
DwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsP
Cw8LDwvDDwvDDwvDDwvDDwvDDwvHDwv/D+4P1w/MD8YPww8PD8cLD8cLD8cLD8MLD8MLD8MLD8ML
D8MLD8MLD8MLD8MLD8MLD8MLD8MLD8MLD8MLD8MLD8MLD8MLDwsPCw/DCw8LDwsPwwsPCw8LDwsP
Cw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8L
DwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsP
Cw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8L
DwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsP
Cw8LDwvDDwsPCw8Lww8LDwsPC8MPC8MPC8MPC8MPC8MPC8MPC8MPC8MPC8MPC8MPC8MPC8MPC8MP
C8MPC8MPC8cPC8cPC8gPxA/CDw8P/wv5Cw/HCw/HCw/DCw/DCw/DCw/DCw/DCw/DCw/DCw/DCw/D
Cw/DCw/DCw/DCw/DCw/DCw/DCw/DCw8LDwsPwwsPCw8LD8MLDwsPCw8LDwsPCw8LDwvDDwsPCw8L
ww8LDwsPC8MPC8MPC8MPC8MPC8MPC8MPC8MPC8MPC8MPC8MPC8MPC8MPC8MPC8MPC8MPC8MPC8cP
C8cPC8cPC/sP3Q/PD8cPxA/CDw/hCw/HCw/HCw/DCw/DCw/DCw8LDwsPwwsPCw8LD8MLDwsPCw8L
DwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsP
Cw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8L
DwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsP
Cw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8L
DwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsP
C8MPCw8LDwvDDwsPCw8Lww8Lww8Lxw8Lxw8L1Q/LD8UPww8PD/8L/wvUCw/HCw/HCw/DCw/DCw/D
Cw8LDwsPwwsPCw8LD8MLDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8L
DwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8Lww8LDwsPC8MPCw8LDwvDDwvDDwvDDwvHDwvHDwv/D+wP
1g/LD8YPww8PD8sLD8MLD8MLD8MLD8MLD8MLD8MLD8MLD8MLD8MLD8MLD8MLD8MLD8MLD8MLD8ML
D8MLD8MLD8MLD8MLD8MLDwsPCw/DCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsP
Cw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8L
DwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsP
Cw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8L
DwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8Lww8LDwsPC8MPC8MPC8MP
C8MPC8MPC8MPC8MPC8MPC8MPC8MPC8MPC8MPC8MPC8MPC8MPC8MPC8MPC8MPC8MPC8cPC8YPww/C
Dw//C/0LD8MLD8MLD8MLD8MLD8MLD8MLD8MLD8MLD8MLD8MLD8MLD8MLD8MLD8MLD8MLD8MLD8ML
D8MLD8MLD8MLDwsPCw/DCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwvDDwsPCw8Lww8Lww8Lww8Lww8L
ww8Lww8Lww8Lww8Lww8Lww8Lww8Lww8Lww8Lww8Lww8Lww8Lww8Lww8Lww8Lww8L/w/hD9EPyA/E
D8IPDw/lCw/HCw/DCw/DCw/DCw/DCw/DCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8L
DwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsP
Cw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8L
DwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsP
Cw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8L
DwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwvD
DwvDDwvDDwvDDwvHDwvXD8wPxg/DDw8P/wv/C9gLD8cLD8MLD8MLD8MLD8MLD8MLDwsPCw8LDwsP
Cw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8L
DwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8Lww8Lww8Lww8Lww8Lww8Lxw8L/w/uD9cPzA/GD8MPDw/H
Cw/HCw/HCw/DCw/DCw/DCw/DCw/DCw/DCw/DCw/DCw/DCw/DCw/DCw/DCw/DCw/DCw/DCw/DCw8L
DwsPwwsPCw8LD8MLDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsP
Cw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8L
DwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsP
Cw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8L
DwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8Lww8LDwsPC8MPCw8LDwvDDwvDDwvDDwvDDwvDDwvDDwvD
DwvDDwvDDwvDDwvDDwvDDwvDDwvDDwvDDwvHDwvHDwvID8QPwg8PD/8L+QsPxwsPxwsPwwsPwwsP
wwsPwwsPwwsPwwsPwwsPwwsPwwsPwwsPwwsPwwsPwwsPwwsPwwsPwwsPCw8LD8MLDwsPCw/DCw8L
DwsPCw8LDwsPCw8Lww8LDwsPC8MPCw8LDwvDDwvDDwvDDwvDDwvDDwvDDwvDDwvDDwvDDwvDDwvD
DwvDDwvDDwvDDwvDDwvDDwvHDwvHDwvHDwv7D90Pzw/HD8QPwg8P4QsPxwsPxwsPwwsPwwsPwwsP
Cw8LD8MLDwsPCw/DCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8L
DwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsP
Cw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8L
DwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsP
Cw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8L
DwsPCw8LDwsPCw8LDwsPCw8LDwvDDwsPCw8Lww8LDwsPC8MPC8MPC8cPC8cPC9UPyw/FD8MPDw//
C/8L1AsPxwsPxwsPwwsPwwsPwwsPCw8LD8MLDwsPCw/DCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsP
Cw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPCw8LDwsPC8MPCw8LDwvDDwsPCw8L
ww8Lww8Lww8Lxw8Lxw8L/w/sD9YPyw/GD8MPDwwAAACAAAAAgACAgAAAAICAAIAAgI