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..
Please check in the DB2 V8 Manuals... There is no problem.. I just need a clarification on the my first post.
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?