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
 

 

force repair an index

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

New User


Joined: 08 Oct 2009
Posts: 12
Location: Kolkata, India

PostPosted: Wed Mar 10, 2010 4:26 pm    Post subject:
Reply with quote

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
View user's profile Send private message

guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Wed Mar 10, 2010 4:34 pm    Post subject:
Reply with quote

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
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Mar 10, 2010 4:54 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Mar 10, 2010 9:14 pm    Post subject:
Reply with quote

Hello,

Quote:
In some shops it is not recomended to run REPAIR utility by developer without the knowledge of DBA.
Indeed icon_smile.gif

In many shops developers cannot run REPAIR at all - these types of things must be done by the dba(s). . .
Back to top
View user's profile Send private message
Chirantan Banerjee

New User


Joined: 08 Oct 2009
Posts: 12
Location: Kolkata, India

PostPosted: Thu Mar 11, 2010 10:09 am    Post subject: Reply to: force repair an index
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Mar 11, 2010 10:15 am    Post subject:
Reply with quote

Hello,

If your environment provides for individual developers to have "their own" databases, that could work icon_smile.gif

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
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 setting new limit Key values for inde... srilata83 DB2 1 Fri Feb 10, 2017 9:24 pm
No new posts Order BY AND Index Nileshkul DB2 2 Sat Dec 31, 2016 6:33 pm
No new posts Several errors during building altern... Andi1982 JCL & VSAM 11 Wed Jul 06, 2016 7:39 pm
No new posts Drop building Alternate Index for a p... bhavin.mehta JCL & VSAM 6 Mon Jul 04, 2016 3:47 pm
No new posts VSAM Alternate Index in CICS jacobdng CICS 2 Fri May 06, 2016 1:41 pm


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