How can you determine cause of a -911

Carlton Enuda

How can you determine cause of a -911
Dear Listers,
I have the following Boole & Babage Mainview and Platinum DB2 Tools at my disposal and I will like to use either of these tools to find the cause of a -911. 
Here's the scenario: I have a vendor reporting tool that gets a -911 frequently but we have not been able to determine which of many tables that it goes after and what other process competes for the same resource that causes the deadlock! Unfortunately, my shop dosen't keep much of  Detector history so I have a very short period to track this problem before whatever history there is is purged.
My queston is, how can I use Boole & Babbage and/or Detector to pinpoint the competing processes and table involve? Some time agao, I think I ws able to find this via Detector, but I don't remember how I did that. Can someone help with the "How to" steps for either of the monitoring tools I have mentioned.
 
Thanks
Carlton
 
We have a need to bring in someone with strong experience with DB2 Connect (PE,EE) but our problem is that we don't have the expertise to determine what skillset to look for (knowledge of the product). We are interested in developing a medium to expert candidate profile along with the requisite skills. Could you DB2 Connect gurus out there help us out with information such as what intimate knowledge should DB2 Connect candidates should know about the product.
Also, any DB2 Connect interview questions and resources to develope such questions will be highly appreciated.   
Thanks in advance, all!
Carlton Enuda

Join the world’s largest e-mail service with MSN Hotmail. Click Here

Jeff Frazier

Re: How can you determine cause of a -911
(in response to Carlton Enuda)
Have you looked in Syslog or the DB2 messages?




Carlton Enuda <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
01/10/02 03:10 PM
Please respond to DB2 Data Base Discussion List


To: [login to unmask email]
cc:
Subject: How can you determine cause of a -911



Dear Listers,
I have the following Boole & Babage Mainview and Platinum DB2 Tools at my
disposal and I will like to use either of these tools to find the cause of
a -911.
Here's the scenario: I have a vendor reporting tool that gets a -911
frequently but we have not been able to determine which of many tables
that it goes after and what other process competes for the same resource
that causes the deadlock! Unfortunately, my shop dosen't keep much of
Detector history so I have a very short period to track this problem
before whatever history there is is purged.
My queston is, how can I use Boole & Babbage and/or Detector to pinpoint
the competing processes and table involve? Some time agao, I think I ws
able to find this via Detector, but I don't remember how I did that. Can
someone help with the "How to" steps for either of the monitoring tools I
have mentioned.

Thanks
Carlton

We have a need to bring in someone with strong experience with DB2 Connect
(PE,EE) but our problem is that we don't have the expertise to determine
what skillset to look for (knowledge of the product). We are interested in
developing a medium to expert candidate profile along with the requisite
skills. Could you DB2 Connect gurus out there help us out with information
such as what intimate knowledge should DB2 Connect candidates should know
about the product.
Also, any DB2 Connect interview questions and resources to develope such
questions will be highly appreciated.
Thanks in advance, all!
Carlton Enuda


Join the world's largest e-mail service with MSN Hotmail. Click Here


Eric Pearson

Re: How can you determine cause of a -911
(in response to Jeff Frazier)
Look on your MVS console log for messages
DSNT375I and DSNT501I. These will tell you the
resource and (one of the probable) causer(s).

If you do not have access to the console log,
look in the JESMSGLG output of ....MSTR.

DETECTOR will also show you the resource but
not the causer.

From the main Detector menu, select
1) View Current Displays
then set to View Type ==> E
which will take you to
DETECTOR SQL ERROR Summary Display

scroll down to -904,
and you will get a list of all -904 during the
collection intervals. Select the one(s) you
want. The diagnostic provided will include the
SQLCA which will identify the resource but
not the causer.



Regards,
eric pearson
NS ITO Database Support

-----Original Message-----
From: Carlton Enuda [mailto:[login to unmask email]
Sent: Thursday, January 10, 2002 3:10 PM
To: [login to unmask email]
Subject: How can you determine cause of a -911


Dear Listers,
I have the following Boole & Babage Mainview and Platinum DB2 Tools at my
disposal and I will like to use either of these tools to find the cause of a
-911.
Here's the scenario: I have a vendor reporting tool that gets a -911
frequently but we have not been able to determine which of many tables that
it goes after and what other process competes for the same resource that
causes the deadlock! Unfortunately, my shop dosen't keep much of Detector
history so I have a very short period to track this problem before whatever
history there is is purged.
My queston is, how can I use Boole & Babbage and/or Detector to pinpoint the
competing processes and table involve? Some time agao, I think I ws able to
find this via Detector, but I don't remember how I did that. Can someone
help with the "How to" steps for either of the monitoring tools I have
mentioned.

Thanks
Carlton

We have a need to bring in someone with strong experience with DB2 Connect
(PE,EE) but our problem is that we don't have the expertise to determine
what skillset to look for (knowledge of the product). We are interested in
developing a medium to expert candidate profile along with the requisite
skills. Could you DB2 Connect gurus out there help us out with information
such as what intimate knowledge should DB2 Connect candidates should know
about the product.
Also, any DB2 Connect interview questions and resources to develope such
questions will be highly appreciated.
Thanks in advance, all!
Carlton Enuda

_____

Join the world's largest e-mail service with MSN Hotmail. Click
< http://go.msn.com/bql/hmtag4_etl_EN.asp > Here
To change your subscription

http://www.ryci.com/db2-l. The owners of the list can be reached at
[login to unmask email]

[login to unmask email]

Re: How can you determine cause of a -911
(in response to Eric Pearson)
How about looking at the ****MSTR start of task. It'll show -911



David Seibert

Re: How can you determine cause of a -911
(in response to Ed_Vetock@NAVYFEDERAL.ORG)
Hi Carlton,
As Jeff, Eric, & Ed have told you, you can find details about your
deadlock in the log for the master address space. Here are a couple more
specifics from doc I wrote up a number of years ago. I hope I've corrected
any outdated pieces and removed most of the irrelevant junk.

Note, you can also encounter some of deadlock or timeout with
symptoms of -904 with Resource Unavailable messages.
If I recall correctly with -904 you get DSNT375 instead of 376 for -904

If you can browse that JESLOG in SDSF,

issue the following sequence of commands:
1. =>> prefix **** ;DA ((where **** is your subsystem)))

2. Press enter
3. Select the Job
+-------------------------------------------------------------+
| SDSF DA CW01 CW01 PAG 0 SIO 208 CPU 72/ 70 |
| PREFIX=D23M* DEST=(ALL) OWNER=* SORT=JOBNAME/A |
| NP JOBNAME STEPNAME PROCSTEP JOBID OWNER C P |
|>> s D23MMSTR D23MMSTR IEFPROC STC00156 D23MMSTR N |
+-------------------------------------------------------------+
4. once in the JESLog, type
Next;up
on the command line. This takes you to the bottom of the Jeslog
for this address space.
+--------------------------------------------------------------------+
|SDSF OUTPUT DISPLAY D23MMSTR STC00156 DSID 2 LINE 0 COLUM|
|COMMAND INPUT ===> N;up SCROLL|
|******************************** TOP OF DATA ***********************|
| J E S 2 J O B L O G -- S Y S T E M C W 0 |
| |
|1.20.11 STC00156 IEF695I START D23MMSTR WITH JOBNAME D23MMSTR IS AS|
|1.20.11 STC00156 $HASP373 D23MMSTR STARTED |
|1.20.11 STC00156 IEF403I D23MMSTR - STARTED - TIME=01.20.11 |
+--------------------------------------------------------------------+
5. From the bottom you can either scroll up, or search
backwards for the message DSNT376
for examples, below is a deadlock encountered in QMF.,

20.05.59 STC22236 DSNT376I : PLAN=DSNESPCS WITH

CORRELATION-ID=BFHDJS0

CONNECTION-ID=TSO

LUW-ID=USCWXN01.D701CW01.B704CCC9B3DA=466

THREAD-INFO=BFHDJS0:*:*:*

IS TIMED OUT. ONE HOLDER OF THE RESOURCE IS
PLAN=QMF710 WITH
CORRELATION-ID=BFHDJS1

CONNECTION-ID=DB2CALL

LUW-ID=USCWXN01.D701CW01.B704CC871610=463

THREAD-INFO=BFHDJS1:*:*:*

ON MEMBER D701



20.05.59 STC22236 DSNT501I : DSNILMCL RESOURCE UNAVAILABLE

CORRELATION-ID=BFHDJS0

CONNECTION-ID=TSO

LUW-ID=*

REASON 00C9008E

TYPE 00000200

NAME DJSXPLDB.PLANRTAB




David Seibert
Compuware Corporation File-AID Product Architect
[login to unmask email]



Mike Vaughan

Re: How can you determine cause of a -911
(in response to David Seibert)
In addition to the other reply's on finding the resources/threads involved in a -911 -- since you mentioned Mainview, under "views" mode, the "LKEVENT" view gathers this information together for you (at least it does at V6.1.01). It gives a list of contention issues displaying blocker/waiter and you can drill down to view the resource involved.

Mike.

-----Original Message-----
From: Carlton Enuda [mailto:[login to unmask email]
Sent: Thursday, January 10, 2002 2:10 PM
To: [login to unmask email]
Subject: How can you determine cause of a -911


Dear Listers,
I have the following Boole & Babage Mainview and Platinum DB2 Tools at my disposal and I will like to use either of these tools to find the cause of a -911.
Here's the scenario: I have a vendor reporting tool that gets a -911 frequently but we have not been able to determine which of many tables that it goes after and what other process competes for the same resource that causes the deadlock! Unfortunately, my shop dosen't keep much of Detector history so I have a very short period to track this problem before whatever history there is is purged.
My queston is, how can I use Boole & Babbage and/or Detector to pinpoint the competing processes and table involve? Some time agao, I think I ws able to find this via Detector, but I don't remember how I did that. Can someone help with the "How to" steps for either of the monitoring tools I have mentioned.

Thanks
Carlton

We have a need to bring in someone with strong experience with DB2 Connect (PE,EE) but our problem is that we don't have the expertise to determine what skillset to look for (knowledge of the product). We are interested in developing a medium to expert candidate profile along with the requisite skills. Could you DB2 Connect gurus out there help us out with information such as what intimate knowledge should DB2 Connect candidates should know about the product.
Also, any DB2 Connect interview questions and resources to develope such questions will be highly appreciated.
Thanks in advance, all!
Carlton Enuda

_____

Join the world's largest e-mail service with MSN Hotmail. Click < http://go.msn.com/bql/hmtag4_etl_EN.asp > Here


Roger Miller

Re: How can you determine cause of a -911
(in response to Mike Vaughan)
For deadlocks and timeouts, one of the best tools is the instrumentation for
IFCID 0172 (deadlocks) and )196 (timeouts). They are part of statistics
class 3 and are very cheap unless the number of deadlocks and timeouts is
very high (say more than 1 a second).

Those records include the holders and waiters for resources. For a
deadlock, the situation is easier to resolve.

Roger Miller, DB2 for z/OS