View previous topic :: View next topic
|
Author |
Message |
Chirantan Banerjee
New User
Joined: 08 Oct 2009 Posts: 12 Location: Kolkata, India
|
|
|
|
After reading What is COPY PENDING status in DB2...
Can anyone tell me if we can force repair an index which is in Rebuild Pending status by using the repair utility. If yes then can someone please provide the control statement. |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Hello Chirantan,
First check why your index went to REBUILD PENDING state. You can use following REPAIR command
Code: |
REPAIR SET INDEX indexname NORBDPEND |
|
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Hi,
In some shops it is not recomended to run REPAIR utility by developer without the knowledge of DBA.
Ask your DBA to run the appropriate utilities, COPY & REBUILD.
Sushanth |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
In some shops it is not recomended to run REPAIR utility by developer without the knowledge of DBA. |
Indeed
In many shops developers cannot run REPAIR at all - these types of things must be done by the dba(s). . . |
|
Back to top |
|
|
Chirantan Banerjee
New User
Joined: 08 Oct 2009 Posts: 12 Location: Kolkata, India
|
|
|
|
Thanks Ekta for providing the control statement.
@Dick and Sushanth - In our shop we have a few test databases where developers are allowed to load/delete/repair to create test data. We take DBA help whenever required but we usually try to sort out the problems ourselves since the test data is meaningful only to the developer who is testing on that database and losing it will not make any difference to others. So instead of asking for DBA help to repair the rebuild pending status - which would take some time, we raised a DBA ticket to investigate why the index went to rebuild pending and repaired the index ourselves and loaded the table afresh to carry on with our work. In the meantime the DBA can check what went wrong and let us know so that we can avoid such situations in future. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
If your environment provides for individual developers to have "their own" databases, that could work
Most places do not provide this and different teams share sets of tables. If one developer drops tables or alters them, it causes disruption for many others. There is also the concern that if the developers implement something that the dbsa will not promote to production, considerable resources might be wasted. |
|
Back to top |
|
|
|