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 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 Wednesday, 5th August 2009 by Balazs
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 version. Loading the new license is quite simple:
Download the license file from [...]
Posted in DB2 | Comments (Comments)
Posted on Monday, 3rd August 2009 by Balazs
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 and a “customer_archive_cua” table with at least two fields. It is a good idea [...]
Tags: PL/PGSQL, PostgreSQL, SQL, Trigger
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)