ADM5530W - NOT LOGGED INITIALLY

Question: I was reviewing messages in db2diag.log and identified some recurring ADM5530W NOT LOGGED INITIALLY messages ADM5530W The COMMIT processing of table "myschema.mytable" that used NOT LOGGED INITIALLY has been initiated. It is recommended that you take a backup of this table's table space(s). What do they mean? Answer: The main purpose of NOT LOGGED INITIALLY is to restrict logging for a transaction. If NOT LOGGED INITIALLY is initiated and there is a : CREATE INDEX,DROP INDEX,ALTER TABLE,INSERT,DELETE or UPDATE , these will not be logged. It doesn’t mean there is an error, and is the expected behaviour for NOT... Read more →