dbTalk Databases Forums  

Serious Design Advisor problems.

comp.databases.ibm-db2 comp.databases.ibm-db2


Discuss Serious Design Advisor problems. in the comp.databases.ibm-db2 forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Fin
 
Posts: n/a

Default 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.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.