datori

Some time ago I was looking for a “quick and dirty” way of generating HTML documentation of one of my clients’ database schema. I didn’t need an ER diagram – just a list of tables to insert into a word document. At that time TOAD for DB2 did not exist, so I could not use it for my purpose.

Eventually, I ended up creating a simple solution for that simple problem, using a SQL script fetching information from the database catalog and an XSL template to transform its output into HTML, similar to this.
(more…)

It contains, among other things, a fix for the Daylight Savings Time (DST) change. USA and Canada will change the effective date of DST in March, 2007. By that time you should make sure the operating system supports the change and install the fixpak. This also concerns DB2 9, for which Fixpak 2 is available.

The complete list of fixes can be found here.