Category: DB2

Just a quick post today to let my readers — specifically those in the US Midwest — that I will be presenting at an executive briefing at the River Forest Country Club in Elmhurst, IL  (Chicago suburb) on August 23, 2016. The event will address the challenges of data management for the digital economy and will look at issues such as: Simplified data management with intelligent automation that requires no downtime. Increased application performance. Data integrity of structured and unstructured data. The ability to easily manage growing databases. My presentation will take a look at the trends and challenges being faced by ... Read More

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 ... Read More