I read in the Db2 9 Administration Planning guide that DB2LINUXAIO was
depreciated in DB2 9.
In 8.2, it improved my db2 i/o performance on a DB2 implementation on
Linux with Raid.

I am learning how to write C++ programs for DB2. My primary area of
concern would be the administrative level DB2 APIs.
For the time being, I am also looking at how to create packages and
bindfiles for DB2. I have the below mentioned code which is giving me

I need some trying to figure out what is happening on our AS/400.
I am not an AS/400 programmer, but I am using ASP.NET (VB) and the
IBM.Data.DB2.iSeries control for .NET to access our DB2 databases.
The problem we seem to be having is after I am all done with my queries

Hi Team,
Very serious problem with my DB2 V8.1 Fixpack 6 running in AIX 5.1
machine. Every one hour my DB2 instance processes are killed and it's
going down. Several trap files are generated in the db2 diag log

Has anyone come across a problem where on Linux using DB2 9.1 Express-
C with the packaged jcc-JDBC driver that it fails correctly to parse a
returned date value? I'm simply calling
resultSet.getDate(paramIndex)

As title!!
My development environment is db2 v8.1. But my production environment
is db2 v7.2. Can I use db2jcc.jar to connect to db2 v7.2?
Thanks a lot.

As I understand it, Declared Global Temporary Tables (DGTTs) have a
scope that is session/connection based.
Using the same connection, I have discovered that if I declare a DGTT
in one stored procedure, then I can't create a second stored procedure

I have noticed an incredible difference in performance between DB2 LUW
v8.2.5 and V9.1.1 with regards to CLOBs.
I will sketch the scenario i have tested.
I created a table with 1 Integer column, 50 Varchar(20) columns and 4

I am admin a db2 instance for a class of over 500 students. I am
wondering
if there is some scripts already for assigning  basic authorization to
the a

I have db2 ESE v9 fix pak 2 installed on red hat linux kernel 2.6.
When I use db2 load facility even with 1 row to be inserted, I see
this error message:
SQL2044N  An error occurred while accessing a message queue.  Reason

Whenever datastage (ETL Tool) tries to establish more than 2
connection to database it fails with the error SQL1224N A database
agent could not be started to service a request, or was terminated as
a result of a database system shutdown or a force command.

Customer wanted us to figure out why their database was growing at an
astronomical rate.
We broke down the various fields making up a table, and we found that the
.LB file was using about 1k per row, where the average length of the two

In a cobol program I have an SQL instruction like following:
EXEC SQL DECLARE CURSORE_1 CURSOR FOR
        SELECT        CAMPO1,
                      CAMPO2,

Take the following table
CREATE TABLE MGR_DEV1.ADDRESSES (
   CUSTOMER_NBR DECIMAL (9, 0)  NOT NULL
 , ADDR_KEY DECIMAL (3, 0)  NOT NULL

   I would also like to find the source for an XBSA client or
application (i.e. links against an XBSA library) so I can better
understand the XBSA API, function call sequence , etc.
Vasili