SQL1279W Some indexes may not have been recreated

SQL1279W Some indexes may not have been recreated

An unscheduled  table reorganisation was occurring  while attempting a db2sop .. db2start .

Upon restart of the instance – and an attempt to connect to the database the following message appeared:

SQL1279W  Some indexes may not have been recreated.

The database restarted OK. And the currently invalid indexes where recreated when the table was accessed .

Investigate the cause of the issue  in db2diag.log and fix

 

Author: Jack Vamvas

Leave a Reply

Discover more from ciquery

Subscribe now to keep reading and get access to the full archive.

Continue reading