I have recently restored an online backup and rolled forward
through many transactions logs to a particular point in time. The
activity on the database during this period of rolling forward
included a number of drop/create index statements.
Upon completion of the rollfoward, the indexes which were
dropped/recreated were ALL flagged as needing to be rebuilt in
String Title:Index(es) need to be rebuilt. PID:42430 Node:000
I am aware that a number of people have posted similar error
messages, but I am interested in finding out whether this is always
the case with DB2 or if it is something which has been fixed in a
Using DB2 v7.1 FP2a on AIX 4.3.3.
Is there any online documentation which explains this 'feature'. I
have searched some of the IBM web pages but can find nothing which
explains that this problem will occur every time one rollforwards
through a create-index statement.
Many thanks in advance,