View previous topic :: View next topic
|
Author |
Message |
srinivas_naikk
New User
Joined: 23 Jul 2007 Posts: 26 Location: India
|
|
|
|
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 |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
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 |
|
|
srinivas_naikk
New User
Joined: 23 Jul 2007 Posts: 26 Location: India
|
|
|
|
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 |
|
|
srinivas_naikk
New User
Joined: 23 Jul 2007 Posts: 26 Location: India
|
|
|
|
It is taking in Loop. Is there a way to reset LEVELID when the tablespace is in REORG pending state? |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Please don't use Dear........
And Srinivas,
Can you show us the full error message.
Sushanth |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
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 |
|
|
srinivas_naikk
New User
Joined: 23 Jul 2007 Posts: 26 Location: India
|
|
|
|
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 |
|
|
Karthikeyan Subbarayan
New User
Joined: 24 Feb 2008 Posts: 62 Location: Boston
|
|
|
|
Can You STOP the DataBase and Start the Database once again. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
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 |
|
|
|