SHOW RESQUEUE

Andrew21210

ADSM.ORG Member
Joined
Apr 10, 2008
Messages
97
Reaction score
2
Points
0
PREDATAR Control23

I realize the SHOW commands are undocumented but I want to find out how to read the output from SHOW RESQUEUE. Here is what I get:

RESOURCETimeout is 60 minutes.
Resource list is unlocked.
==========================================================
This is a local waiter.
status=resWaiting waitTime=0 minutes
waiter Type=unknown (0) timeout value=60 minutes
txnSeqNo=0:1574362415 resourceName=(243.1) lengthLen=5
type=19002 and nameSpace=0
waiter thead id is 937079 condition=-1618228168
mutex=-2127483720 abortFunc=809d4184
==========================================================
This is a local waiter.
status=resWaiting waitTime=2 minutes
waiter Type=unknown (0) timeout value=60 minutes
txnSeqNo=0:1574361412 resourceName=(*NULL*) lengthLen=0
type=57001 and nameSpace=0
waiter thead id is 23 condition=-985421016
mutex=-2127483720 abortFunc=809d4184
==========================================================


I have no idea how to read this or if there is an issue.
 
PREDATAR Control23

It gets complex quick. First, you will need to look at show threads to identify what those 2 threads are doing, that should tell you what is doing the waiting for a resource.
 
Top