Using IBM Db2 LUW as a source for AWS SCT

Using IBM DB2 LUW as a source for AWS SCT ? Read more →

DB2 LUW 11.1 product documentation available in PDF format

For a period of time the DB2 LUW 11.1 documentation was only available online. The good news is it's now available in PDF format and can be downloaded to read through . To download the documentation visit the Db2 Version 11.1 for Linux, UNIX, and Windows English Manuals Read more →

Alternatives to Oracle Apex

Oracle Application Express (Apex) is a great tool for DBAs to quicky bang up a web application based around an Oracle database and using PL/SQL. One of the limitations in a multi-vendor database environment is it doesn't play well with other databases. There are workarounds - such as taking feeds or exporting feeds , and then using Apex to report. I've been looking at a few alternatives to Oracle Apex. I know that some people will come back with Ruby on Rails - but thinking other options. A few I've looked at recently. If you have been working with alternatives... Read more →

How to remove a TSA peer domain

I was installing TSA for a shared storage DB2 clustering , and there were some disk error issues. Rather than spending time troubleshooting dealing with a half installed installation, it was easier to drop the peer domain and start the TSA install again. Making the decision on whether you reinstall or troubleshoot, will depend on your circumstances. It's worth highlighting the TSA uninstall procedure is easy . It then gives you the opportunity to complete any due diligence, bug fixing or other preparatory steps Once the disk error was fixed , these were the steps I completed to delete the... Read more →

How to find the DB2 installation path using db2ls

Question: Is there a DB2 utility to find the DB2 installation path? The utility should also return installation date and other useful information. I need this utility to run on Linux. Answer: From DB2 9.5 , the db2ls command is available. On a typical installation of a DB2 server, a symbolic link is added to the /usr/local/bin path. A different resultset returns, depending on the installation. If you execute db2ls as root, only root installations are returned. If you execute as a non-root , the recordset includes DB2 installations by root and the DB2 installations completed by the id. The... Read more →