Database administration for fun and profit

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

Defining different TSM options for multiple DB2 instances

I had been struggling with an obscure problem recently. I needed to set up several DB2 instances on a Microsoft Cluster Server and configure them for TSM backup and log archiving. That would have been a relatively easy task if it were not for the fact that those instances belonged to different cluster resource groups. Each group had its own virtual IP address and host name, and could be brought online or moved to another cluster node independently. For this reason each resource group required a separate TSM node defined for it, which, in turn, called for a separate set of TSM configuration options.

Read More