Category Archives: DB2
DB2 Discovery Kit
I have posted a number of tips to use DB2. If you haven’t used DB2 before, it is one of the best databases out there, and best of all, it is available completely free from IBM. Get your DB2 discovery … Continue reading
Register DTD for pureXML with DB2 9.7
Problem Even though XML schema has been around for a decade, still many APIs reference a DTD in the XML documents sent back and fourth. Such is the OpenSRS API. DB2 requires an XML schema or a DTD to be … Continue reading
Change Host Name of DB2 9.7 Server on AIX
Synopsis After changing the name of the host on which DB2 9.7 is running, the following error message is received when trying to start the database: 09/28/2009 02:32:50 0 0 SQL6048N A communication error occurred during START or STOP DATABASE … Continue reading
Creating a User Defined Function (UDF) in Java for IBM DB2 9.7
Intro One of the great features of DB2 is that it can be extended with custom code using SQL, C/C++, Java and COBOL. One of the great new features added to DB2 in 9.7 is the ability to run native … Continue reading
Fiber Channel (FC / SAN) Performance Tuning on AIX 6.1
Introduction In large data-warehousing applications, the efficiency of storage systems is critical. With the same hardware and software release, we have seen queries that never terminate (i.e. still runs after a week) under one configuration to be able to finish … Continue reading
IBM Expands in Analytics Market
Infoworld’s Pete Babb has an article about IBM to acquire analytics firm SPSS. Pete sees this acquisition by IBM in line with the earlier acquisition of Cognos also by IBM. He underlines that the key aspect of this acquisition is … Continue reading
Installing Product License for DB2
In a previous blog post I described how to upgrade to DB2 9.7. However, once the upgrade is complete, the old 9.5 license becomes invalid and a new license needs to be loaded. Preferable before you fire up the new … Continue reading
Posted in DB2 Leave a comment
Creating Delete Triggers in PostgreSQL
One of the common data integrity issues that can happen in a database is the unintended deletion of a row. Here is how to create a DELETE trigger in PostgreSQL. The example code below assumes you have a “customer_cus” table … Continue reading
How to Disable Web Based System Manager on AIX 6.1
AIX has a neat feature that allows to manage a system completely from a browser interface. Since AIX 6.1 TL3, this interface runs on port 80, which makes it easy to find it. However there might be several reasons one … Continue reading
Upgrading DB2 LUW from 9.5 with XML Extender to 9.7
Summary The IBM documentation has good information on how to do the upgrade in general, and how to go through the preparation steps. Unfortunately the information about XML Extender is sparse, and all you get is ADM4104E One or more … Continue reading
 |