| View previous topic :: View next topic |
| Author |
Message |
pcsingh_2000
Beginner
Joined: 13 May 2003
Posts: 15
Topics: 6
Location: Kolkata
|
 Posted: Thu Jul 26, 2007 10:58 am Post subject: DSN1MSTR message: UNABLE TO DRAIN RESOURCE |
 |
|
Here are some message I have collected from DSN1MSTR while analyzing a contention
with respect to "SOSSD" tablespace for partition 1 as specified by Reason, Type and
Name.
| Code: |
02.10.14 STC01203 DSNT501I - DSNB1DRA RESOURCE UNAVAILABLE 621
621 CORRELATION-ID=020.STOPDB09
621 CONNECTION-ID=DSN1
621 LUW-ID=*
621 REASON 00C200EA
621 TYPE 00000210
621 NAME DSALAGG1.SOSSD .00000001
02.10.14 STC01203 DSNT501I - DSNISTPC RESOURCE UNAVAILABLE 622
622 CORRELATION-ID=020.STOPDB09
622 CONNECTION-ID=DSN1
622 LUW-ID=*
622 REASON 00C200EA
622 TYPE 00000210
622 NAME DSALAGG1.SOSSD .00000001
02.10.14 STC01203 DSNI020I - DSNISTPC UNABLE TO DRAIN RESOURCE 623
623 TYPE 00000210
623 NAME DSALAGG1.SOSSD .00000001
623 WILL RETRY DRAINING THE RESOURCE.
and the utility job which was abended having message like: "UNABLE TO CLEAR LOCKS,
RETRIES EXHAUSTED".
|
I am bit confused about CORRELATION-ID=020.STOPDB09.
Could someone help me what does this("020.STOPDB09") mean?
Regards,
Prakash. |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12375
Topics: 75
Location: San Jose
|
|
| Back to top |
|
|
videlord
Beginner
Joined: 09 Dec 2004
Posts: 147
Topics: 19
|
| Posted: Thu Jul 26, 2007 3:24 pm Post subject: |
|
|
020.STOPDB209 should be a STOP DB command.
And the command failed becasue it can't drain the tabelespace/partition
try command:
-DIS DB(DSALAGG1) SP(SOSSD) CLAIMERS
there should be some claimers on the tablespace
cancel the thread |
|
| Back to top |
|
|
pcsingh_2000
Beginner
Joined: 13 May 2003
Posts: 15
Topics: 6
Location: Kolkata
|
| Posted: Fri Jul 27, 2007 4:12 am Post subject: |
|
|
Right.. we can find out the Claimers at that point of time. When I got the oppertunity to investigate the thing, by that time, the Claimer was not there. Is there any way to find out the Clamers for this abend now by looking at somewhere?
_________________
prakash c. singh
voice:00-91-93315 16675 |
|
| Back to top |
|
|
videlord
Beginner
Joined: 09 Dec 2004
Posts: 147
Topics: 19
|
| Posted: Fri Jul 27, 2007 2:57 pm Post subject: |
|
|
| you can try get more informaiton from SYS1.LOGREC |
|
| Back to top |
|
|
videlord
Beginner
Joined: 09 Dec 2004
Posts: 147
Topics: 19
|
| Posted: Fri Jul 27, 2007 3:33 pm Post subject: |
|
|
oh, if you have related DB2 trace started,
try DB2 PM Locking report |
|
| Back to top |
|
|
pcsingh_2000
Beginner
Joined: 13 May 2003
Posts: 15
Topics: 6
Location: Kolkata
|
| Posted: Wed Aug 01, 2007 1:58 am Post subject: |
|
|
| I have TMON for DB2in our shop. Any idea for getting history of locking from this tool. |
|
| Back to top |
|
|
pcsingh_2000
Beginner
Joined: 13 May 2003
Posts: 15
Topics: 6
Location: Kolkata
|
| Posted: Mon Jun 28, 2010 7:04 am Post subject: |
|
|
We got the same error. Here is the DISPLAY database command for this segmented tablespace
-DISPLAY DATABASE(DFLXPRP1) SPACENAM(SFWST ) LOCKS LIMIT(*)
at the time of STOP Pending time. | Code: |
NAME TYPE PART STATUS CONNID CORRID LOCKINFO
-------- ---- ---- ------------------ -------- ------------ --------
SFWST TS STOPP DSN1 020.STOPDB09 W-X,S,01
SFWST TS STOPP DSN1 020.STOPDB09 H-X,S,C
SFWST TS STOPP DSN1 020.STOPDB09 H-X,R,A
SFWST TS STOPP DSN1 020.STOPDB09 H-X,C,A
SFWST TS STOPP DSN1 020.STOPDB09 H-X,W,A
26 TB DSN1 020.STOPDB09 H-X,R,A
26 TB DSN1 020.STOPDB09 H-X,C,A
26 TB DSN1 020.STOPDB09 H-X,W,A
===
|
While I can fully understand the LOCKINFO, still not sure about "01" in first line which is for lock duration. Any idea? Also not able to determine what is "020.STOPDB09 " and "26" under the Name column.
Under CORRID, it seems: '0nn', where 'nn' is a number, if the thread is for a system agent. So which system agent is "020"?
It seems same table space is holder of the exclusive lock and same tablespace is waiting for it. Mostly not able to drain the resource.. Not able to determine the reason of it.
_________________
prakash c. singh
voice:00-91-93315 16675 |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12375
Topics: 75
Location: San Jose
|
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
