Tag Archives: IBM
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
Installing RHEL from an AIX NIM master
Summary The AIX NIM server allows a very flexible automated installation process to deploy hundreds or AIX nodes as well as LPARs in a matter of hours. It is possible to achieve similar results using the RHEL kickstart system. This … 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
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
Extending a Filesystem in AIX 6.1
Aix allows extending a filesystem on the fly. This feature has been around for over 15 years. I first used it with AIX 3.1. What an AIX system is intalled, it can be set up with minimal requirements and then … 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
Installing IBM Systems Director on an AIX 6.1 LPAR with a DB2 back-end
IBM Systems Director is a very powerful management tool that comes free with PowerVM (that is: free to anyone that purchases a Power System). I have gathered here the different steps. Most of the information comes from the official documentation: … Continue reading
