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 Sunday, 31st May 2009 by Balazs
These ideas are derived and quoted from “Best practices for tuning DB2 UDB v8.1 and its databases”
CREATE INDEX has a number of options that allow for significant performance gains:
Optimizing for SELECT: use PCTFREE 0 if index is on a read-only table.
Optimizing for ascending or descending ordering: use ALLOW REVERSE SCANS to allow for an [...]
Tags: DB2 9.7, IBM, Index
Posted in DB2 | Comments (Comments)