Personal tools
You are here: Home Forums DB2 reorg related issue??
Navigation
Log in


Forgot your password?
 
Document Actions

reorg related issue??

Up to DB2

reorg related issue??

Posted by Pawan at May 15. 2008

HI,


     To reorganize database indexes with an asterisk (*) in the last column (Reorg) after running reorgchk command, we need to do reorg all those indexes.


But after doing reorg activity twice we are still getting asterisk (*) for few indexes. Please find below sample.



IDSLDAP  RCN                 3e+06 27322     1     4    14  8059  3e+06  93  61 124   0   0 *----




Is there any harm if one asterisk (*) exist? the most left dash i am geeting asterisk(*).
Is database reorganized?
If still existance of asterisk (*) then what should I need to take action?
Please look in that and provide solution.
I refered below link but not getting clear picture on this.


Info Center db2 v8


Pawan


Re: reorg related issue??

Posted by Silvania Resende at May 19. 2008

If you see stars (*), run reorg and still see some stars there is no problem. This is very common - reorg can not clean all the stars.


Powered by Ploneboard
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls