Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Tablespace in REORG pending state

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
srinivas_naikk

New User


Joined: 23 Jul 2007
Posts: 26
Location: India

PostPosted: Fri Feb 26, 2010 12:53 pm    Post subject: Tablespace in REORG pending state
Reply with quote

Dear All,

Someone has run the Alter Index and the tablespace has gone to REORG pending state.

We are unable to remove the REORG pending status. If we run REORG it is not working. When we run REORG, indexes are going to Rebuild pending. We removed the rebuilding pending.
Let us know how to resolve the issue. Is there a way to take image copy of the tablespace when it is in REORG pending state?

Thanks in advance.

Regards,
srinivas
Back to top
View user's profile Send private message

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Sat Feb 27, 2010 12:10 pm    Post subject:
Reply with quote

Srinivas,

Quote:
Is there a way to take image copy of the tablespace when it is in REORG pending state?


Try reading DB2 V(your version) Utility Reference Manual on chapter REORG TABLESPACE & REORG INDEX along with SHRLEVEL & INLINE copy.

Sushanth
Back to top
View user's profile Send private message
srinivas_naikk

New User


Joined: 23 Jul 2007
Posts: 26
Location: India

PostPosted: Mon Mar 01, 2010 3:07 pm    Post subject: Reply to: Tablespace in REORG pending state
Reply with quote

Dear Sushanth,

Thanks for the reply.

We have already tried that. We got message to repair LEVELID.
When we tried to repair LEVEL ID, it failed stating tablespace in REORG pending.

Any other solution?

Regards,
srinivas
Back to top
View user's profile Send private message
srinivas_naikk

New User


Joined: 23 Jul 2007
Posts: 26
Location: India

PostPosted: Mon Mar 01, 2010 3:18 pm    Post subject: Reply to: Tablespace in REORG pending state
Reply with quote

It is taking in Loop. Is there a way to reset LEVELID when the tablespace is in REORG pending state?
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Mon Mar 01, 2010 3:21 pm    Post subject:
Reply with quote

Please don't use Dear........

And Srinivas,

Can you show us the full error message.

Sushanth
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Mon Mar 01, 2010 3:23 pm    Post subject:
Reply with quote

Srinivas,

Quote:
It is taking in Loop.


Can you explain, what was done to get a LEVELID program for a tablespace ?

Sushanth
Back to top
View user's profile Send private message
srinivas_naikk

New User


Joined: 23 Jul 2007
Posts: 26
Location: India

PostPosted: Mon Mar 01, 2010 4:46 pm    Post subject: Reply to: Tablespace in REORG pending state
Reply with quote

Sushanth,

When I try reorg, I get

REORG TABLESPACE DBENT.ENT SHRLEVEL REFERENCE COPYDDN(COPYDDN)
RESOURCE UNAVAILABLE
REASON 00C2010D
TYPE 00000220
NAME DSNC.DSNDBC.DBENT.ENT.I0001.A001


When I try Imagecopy job

COPY TABLESPACE DBENT.ENT SHRLEVEL REFERENCE COPYDDN(COPYDDN)
RESOURCE UNAVAILABLE
REASON 00C2010D
TYPE 00000220
NAME DSNC.DSNDBC.DBENT.ENT.I0001.A001

When I run Repair LEVELID job, I get this error


REPAIR LEVELID TABLESPACE DBENT.ENT
REORG PENDING ON TABLE SPACE DBENT.ENT PROHIBITS PROCESSING
Back to top
View user's profile Send private message
Karthikeyan Subbarayan

New User


Joined: 24 Feb 2008
Posts: 56
Location: Boston

PostPosted: Mon Mar 01, 2010 4:59 pm    Post subject:
Reply with quote

Can You STOP the DataBase and Start the Database once again.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Mon Mar 01, 2010 5:16 pm    Post subject:
Reply with quote

Srinivas,

Check the status of the tablespace and after doing that run LOAD REPLACE or RECOVER to replace the data in the tablespace.

Sushanth
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Image Copy of a tablespace that conta... Robin Sulsona DB2 4 Thu Jun 02, 2016 1:47 am
No new posts IBMHPU - Tablespace and Imagecopy chaitanya bharath DB2 1 Fri Apr 15, 2016 5:54 pm
No new posts Clearing restrictive state aprocon DB2 4 Fri Jan 01, 2016 2:33 am
No new posts Query on Image Copy Tablespace and QU... vickey_dw DB2 3 Fri Oct 23, 2015 10:55 am
No new posts UNLOAD from Image Copy Tablespace wit... alluri12 DB2 5 Wed Sep 23, 2015 7:00 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us