Re: cannot drop index
You might try to find the session using something like,
tabname=f4uhlp
echo "select hex(partnum) from systabnames where tabname='$tabname'" |
dbaccess sysmaster | grep "^0x" |
while read partnum
do
onstat -g ath | grep "^ [1-9]" | awk '{print "-g opn",$1}' |
onstat -i |
grep $partnum | awk '{if($8)print $1}' | sort -u |
while read tid
do
onstat -g ath | grep " $tid "| awk '{print $3}' |
while read rstcb
do
onstat -u | grep $rstcb | awk '{print $3}'
done
donedone
Good luck,
-Tim
malcolm.weallans@btope
nworld.com (malcolm) To: informix-list@iiug.org
Sent by: cc:
owner-informix-list@ii Subject: cannot drop index
ug.org
04/15/2004 12:13 PM
Please respond to
malcolm.weallans
I am having problems dropping an index. The system complains that I
don't have exclusive access, but there are no locks on the index or
the table.
Any ideas?
Malcolm
sending to informix-list