Skip to main content

developerWorks >  Information Management  >  Forums  >  DB2 for z/OS forum  >  developerWorks

Reorg job abended    Point your RSS reader here for a feed of the latest messages in this thread


Tags for this thread: 

     

 
 

My developerWorks
 Welcome, Guest
Sign in or register
Permlink Replies: 3 - Pages: 1 - Last Post: Nov 16, 2009 2:26 AM Last Post By: momi
IBM-INDIA

Posts: 9
Registered: Oct 06, 2009 07:12:57 AM
Reorg job abended
Posted: Oct 24, 2009 05:37:44 AM
Click to report abuse...   Click to reply to this thread Reply
Hi, Please help in resolving the below error

My reorg job is abending with the below error

-DSNT500I 297 05:12:14.73 DSNUGBAC - RESOURCE UNAVAILABLE
REASON 00C2010D
TYPE 00000220
NAME WCPSTMEN.DSNDBC.DB_NAME.TS_NAME.I0001.A001
-DSNU017I 297 05:12:14.73 DSNUGBAC - UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED, REASON=X'00E40009'
CAUSE=X'00C2010D'
momi

Posts: 87
Registered: Jan 07, 2007 10:49:29 AM
Re: Reorg job abended
Posted: Oct 24, 2009 08:09:13 AM   in response to: IBM-INDIA in response to: IBM-INDIA's post
Click to report abuse...   Click to reply to this thread Reply
DB2 has a mechanism called down level detection. It's purpose is to identify if a certain file is not "up to date" with the rest of the database. this can be cause by copying a file from one DB2 to another using dsn1copy, or have an old copy of a file restored not using the recover utility.

In order to solve this problem you need to run the repair utility with the levelid clause.
If this problem is caused by a dsn1copy job, add the reset parameter to dsn1copy and it will tell db2 to reinitialize the level id the next time the file is opened
You can also recover this tablespace in order to solve the problm
IBM-INDIA

Posts: 9
Registered: Oct 06, 2009 07:12:57 AM
Re: Reorg job abended
Posted: Oct 26, 2009 07:20:50 AM   in response to: momi in response to: momi's post
Click to report abuse...   Click to reply to this thread Reply
I am not sure, what utility has caused this error. How to find the utility which caused this? What action do I need to take now to restore the table space?
momi

Posts: 87
Registered: Jan 07, 2007 10:49:29 AM
Re: Reorg job abended
Posted: Nov 16, 2009 02:26:18 AM   in response to: IBM-INDIA in response to: IBM-INDIA's post
Click to report abuse...   Click to reply to this thread Reply
you can try to use the repair utility with the levelid clause in order to fix the tablespace
 Tags
Help

Use the search field to find all types of content in My developerWorks with that tag.

Use the slider bar to see more or fewer tags.

Popular tags shows the top tags for this particular type of content or application that you're viewing.

My tags shows your tags for this particular type of content or application that you're viewing.

 

MoreLess 


Point your RSS reader here for a feed of the latest messages in all forums