reorg related issue??
Up to DB2reorg related issue??
Posted by Pawan at May 15. 2008HI,
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. 2008If 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.