Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Clarification on Repair Index & Indexspace

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

New User


Joined: 12 Sep 2006
Posts: 12
Location: India

PostPosted: Fri Aug 17, 2007 5:23 pm    Post subject: Clarification on Repair Index & Indexspace
Reply with quote

Hi,

If an index or an indexspace falls into a pending status, we use the repair utility statements - Repair Set Index or Repair Set Indexspace.

What is the need of Repair Set Index while the Repair Set IndexSpace solves the problem?

Please clarify.

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

noorkh

New User


Joined: 06 Mar 2006
Posts: 76
Location: Chennai

PostPosted: Mon Aug 20, 2007 7:48 pm    Post subject:
Reply with quote

Hi Arjun,

Indexspace works for both Index and Indexspace. They might want to give more clarity bettween Indexspace and single index. Even I am not sure why there are 2. But I am just guessing that it can be.

I may be wrong.
Back to top
View user's profile Send private message
wanderer

Active User


Joined: 05 Feb 2007
Posts: 199
Location: Sri Lanka

PostPosted: Tue Aug 21, 2007 5:57 am    Post subject:
Reply with quote

I don't see any syntax like "Repair Set IndexSpace" in DB2 V7 manuals. Could you give an example of what was the problem and what you command you executed?

thanks.
Back to top
View user's profile Send private message
jontyjun

New User


Joined: 12 Sep 2006
Posts: 12
Location: India

PostPosted: Tue Aug 21, 2007 2:45 pm    Post subject:
Reply with quote

Hi Noorkh,

Yes we understand that Set Indexspace works for both Index and Indexspace, but I am not able to justify that the two statements are just present for clarity sake.... hope somebody will clarify us on this..


Hi Wanderer,

Please check in the DB2 V8 Manuals... There is no problem.. I just need a clarification on the my first post.

Example:
Repair Set Index Creator.Indxname nocopypend;
Repair Set Indexspace DBname.Indxspname nocopypend;

Executing any one of the above statements will repair the pending status.
Hence Why has the IBM provided The new Set Indexspace statement in DB2 V8?

Are there any other features for the Set Indexspace?

Regards,
Arjun.
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 Confusion b/w index and subscript Deepak kumar25 Mainframe Interview Questions 7 Thu Aug 31, 2017 6:50 am
No new posts SQL - select data available in index Nileshkul DB2 3 Mon Jun 26, 2017 1:30 am
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

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us