Posted on Monday, 25th January 2010 by Balazs
Summary
Patching AIX can be intimidating at first for someone coming from the Windows / Linux world. AIX has capabilities that natively support production quality operations. One of these qualities is that one can install patches on an alternative volume, make that volume bootable for testing and allowing an easy way out if something [...]
Tags: AIX 6.1, IBM, Patch, smit, smitty, SUMA
Posted in AIX | Comments (Comments)
Posted on Thursday, 21st January 2010 by Balazs
OS X developers do not need to use a virtual machine any longer to be able to run DB2 in their favorite development environment. The latest version of DB2 9.5 available for download works on Snow Leopard (OS X 10.6).
Tags: DB2 9.5, IBM, OS X 10.6, Snow Leopard
Posted in DB2, Mac OS X | Comments (Comments)
Posted on Tuesday, 29th December 2009 by Balazs
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 kit from IBM. As Grant Allen puts it in Beggining DB2, “IBM [...]
Tags: DB2 9.7, IBM
Posted in DB2 | Comments (Comments)
Posted on Thursday, 17th December 2009 by Balazs
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 registered before it will process XML documents that refer to an XML Schema or [...]
Tags: DB2 9.7, DTD, IBM, pureXML, XML, XML Schema, XQuery
Posted in DB2 | Comments (Comments)
Posted on Friday, 6th November 2009 by Balazs
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 article is about a way of automating the RHEL 5 deployment directly from AIX [...]
Tags: AIX, IBM, Kickstart, NIM, RHEL
Posted in AIX, Linux | Comments (Comments)
Posted on Monday, 28th September 2009 by Balazs
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 MANAGER processing.
SQL1032N No start database manager command [...]
Tags: AIX 6.1, DB2 9.7, IBM
Posted in AIX, DB2 | Comments (Comments)
Posted on Monday, 24th August 2009 by Balazs
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 Oracle PL/SQL code, that capability opens up a world of possibilities, and at the same [...]
Tags: DB2, DB2 9.7, IBM, Java, UDF
Posted in DB2 | Comments (Comments)
Posted on Monday, 24th August 2009 by Balazs
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 within hours after optimizations.
Of course in the case of a database like DB2, there are [...]
Tags: AIX 6.1, FC, Fiber Channel, IBM, SAN
Posted in AIX, DB2 | Comments (Comments)
Posted on Wednesday, 5th August 2009 by Balazs
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 the focus on predictive analysis. IBM clearly shows a preference for solutions [...]
Tags: Analytics, DB2, IBM, SAS, SPSS
Posted in DB2, Technology | Comments (Comments)
Posted on Saturday, 1st August 2009 by Balazs
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 might not want to run the AIX Web Based System Manager. For [...]
Tags: AIX 6.1, IBM, IBM Systems Director, ISD
Posted in DB2 | Comments (Comments)