Database administration for fun and profit

Column-organized tables in DB2? Why not! Check out the IBM DB2 Technology Preview

A technology preview program for the potential new features in IBM DB2 was announced today: IBM DB2 Technology Preview

You can explore what DB2 developers are working on and provide direct feedback. In this installment: column-organized tables, a feature that may benefits performance of analytical and other data warehouse-type workloads.

In a column-organized table values of a single table column are stored sequentially in a particular page on disk. This is contrary to the regular, row-organized tables, where all columns of each row are stored sequentially, and one or more complete rows are placed on a particular page.

Columnar organization of a table benefits queries that access a significant portion or all rows in the table but only reference few columns.

Of course, there is no certainty about when or even whether this will actually be a part of DB2 Data Server, but the technology preview program gives you the opportunity to influence future directions of DB2.

Security Bulletin: DB2 Escalation of Privilege Vulnerability

A vulnerability has been found in the Tivoli Monitoring Agent (ITMA) that ships with DB2 9.5 and 9.7. It allows a local user to run arbitrary code with elevated (root) privileges.

If you are using ITMA, take a note of how to apply the workaround: http://www.ibm.com/support/docview.wss?uid=swg21576372&myns=swgimgmt&mynp=OCSSEPGG&mync=E

Apparently, the Response File Generator utility, db2rspgn, is also affected: http://osvdb.org/show/osvdb/76456

Downloading the logrotate script

I’ve been receiving comments recently from readers who have problems opening the logrotate archive. I did check (and re-check) the archive, and I’m absolutely positive that the URL is correct and the file is not corrupt and can be downloaded and opened. The only problem I can see is that when you use Internet Explorer (at least IE6 – did not try it with other version) to download the file, it gets renamed to “logrotatew.tar.tar” for some reason. Apparently, Explorer does not like the original “.tar.gz” extension.

If that happens to you make sure that you rename the downloaded file back to “logrotatew.tar.gz”; after that bsdtar, WinZip, gunzip, and other utilities will know how to deal with the file. As an example, here’s how to use bsdtar if you saved the file in c:\temp:

bsdtar -xvzf c:\temp\logrotatew.tar.gz

Fixpak 14 for DB2 UDB v8 is out

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.