REORG - UNABLE TO DRAIN

SUBSCRIBE DB2-L Anil Kale

REORG - UNABLE TO DRAIN
Hi All !

Env: DB2 V9 CM on z/os
Task Performed: Online REORG

One of our reorg jobs was performing lot of iterations in the log phase of a
online reorg. I noticed that it had done about 200 iterations and each time it
said 0 records processed.
I also saw multiple occurences of the following message.
DSNU1122I # 017 03:52:13.90 DSNURLOG - JOB DBAREOJ1
PERFORMING REORG
. WITH UTILID DBAREOJ1 UNABLE TO DRAIN dbname.tsname
. RETRY 120 OF 255 WILL BE ATTEMPTED IN 30 SECONDS

I am posting this message after the fact. Its 4 days now since we
encountered the problem. So I am not sure how much log information I can
get. But I would appreciate any comments/inputs/feedback from you all.

Thanks.

Anil


_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

duam lee

Re: REORG - UNABLE TO DRAIN
(in response to SUBSCRIBE DB2-L Anil Kale)

Hi Anil,



issue dis db(dbname) space(spname) claimers and see the thread. Then you may have to cancel the thread if you found any.



With Thanks
Duam.




> Date: Wed, 20 Jan 2010 12:50:13 +0000
> From: [login to unmask email]
> Subject: [DB2-L] REORG - UNABLE TO DRAIN
> To: [login to unmask email]
>
> Hi All !
>
> Env: DB2 V9 CM on z/os
> Task Performed: Online REORG
>
> One of our reorg jobs was performing lot of iterations in the log phase of a
> online reorg. I noticed that it had done about 200 iterations and each time it
> said 0 records processed.
> I also saw multiple occurences of the following message.
> DSNU1122I # 017 03:52:13.90 DSNURLOG - JOB DBAREOJ1
> PERFORMING REORG
> . WITH UTILID DBAREOJ1 UNABLE TO DRAIN dbname.tsname
> . RETRY 120 OF 255 WILL BE ATTEMPTED IN 30 SECONDS
>
> I am posting this message after the fact. Its 4 days now since we
> encountered the problem. So I am not sure how much log information I can
> get. But I would appreciate any comments/inputs/feedback from you all.
>
> Thanks.
>
> Anil
>
>
> _____________________________________________________________________
>
> * IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
> _____________________________________________________________________
>
> http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
> DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
> many more categories of help waiting for you!
> Whether you are an old hand or a DB2 newbie, we have presentations for every level.
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

_________________________________________________________________
Windows Live: Friends get your Flickr, Yelp, and Digg updates when they e-mail you.
http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/social-network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_3:092010

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Jorg Lueke

Re: REORG - UNABLE TO DRAIN
(in response to duam lee)
You really shouldn't just cancel a thread. Often times the business may prefer
to have an app up rather than the reorg run through. There's several
behaviors that can be set in the utilit. Is this an online reorg with fastswitch?
Sometimes a simple schedluing change is all that is required.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Sudhir Raj

Re: REORG - UNABLE TO DRAIN
(in response to Jorg Lueke)
 Zero rows processed! Looks like the problem is not the writers, it the readers. You might have long running read thread , since DB2 will have to drain all writers and readers in the switch phase it will retry # of times as specified on your RETRY parm.

I suggest
-> adding -DISPLAY DB(xx) TS(xx) USE command step in your jcl, before and after the REORG utility, to find the culprit!
-> move to reorg to a quieter time if possible.
-> recommend adding frequent commits to SELECT/read-only batch programs.
-> last but not the best! cancel the offending thread after checking with your business.

Sudhir
RealTime-DBA




________________________________
From: Anil <[login to unmask email]>
To: [login to unmask email]
Sent: Wed, January 20, 2010 7:50:13 AM
Subject: REORG - UNABLE TO DRAIN

Hi All !

Env: DB2 V9 CM on z/os
Task Performed: Online REORG

One of our reorg jobs was performing lot of iterations in the log phase of a
online reorg. I noticed that it had done about 200 iterations and each time it
said 0 records processed.
I also saw multiple occurences of the following message.
DSNU1122I # 017 03:52:13.90 DSNURLOG - JOB DBAREOJ1
PERFORMING REORG
.      WITH UTILID DBAREOJ1 UNABLE TO DRAIN dbname.tsname     
.      RETRY 120 OF 255 WILL BE ATTEMPTED IN 30 SECONDS 

I am posting this message after the fact. Its 4 days now since we
encountered the problem. So I am not sure how much log information I can
get. But I would appreciate any comments/inputs/feedback from you all.

Thanks.

Anil


_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 *  http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L




_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L