Serious Design Advisor problems. -
07-12-2011
, 11:22 PM
Whenever I run the Design Advisor from Control Panel I am now receiving warnings in the db2diag.log as follows:
ADM5530W The COMMIT processing of table "DB2ADMIN.SYSCOLDIST" that
used NOT LOGGED INITIALLY has been initiated. It is recommended that
you take a backup of this table's table space(s).
I am getting this error repeated for EVERY SYSTEM table in my database, butwith the DB2ADMIN schema ??? Express-C 9.7.4. What on earth is going on and why is the design advisor initiating NOT LOGGED INITIALLY on all 'system'tables in the db2admin schema ?
I'm terrified to run it now for fear of what else it may try ?
Any help would be greatly appreciated. |