I have a Perl script using DBD::DB2, that runs during system startup on
a Solaris system.  The script is working fine during startup on many
machines, except on one machine it fails complaining about a missing
".so" file, with Perl flagging the "use DBD::DB2" line.  (I don't have

I have a table called 'employee' with one column called 'name', a varchar.
If I execute the following insert statements:
insert into employee(name) values ('jones')
insert into employee(name) values ('smith')

  I am developing a JDBC application and I encountered this problem (DB2
for ISeries).
I want to do a select for update and also use the fetch first rows clause.
This is my sql statement:

Running Db2 8.1 w Fixpack 9.
Recently upgraded to this level.
An application attempting a load receives the following error
Error    Error    1    2005-12-29 14:55:26    SQLError: sqlstate 51002: [IBM][CLI

We are using DB2 UDB version 8.1 fp7 & fp9 on AIX 5.2.
On our databases we do massive inserts and deletes (millions of rows).
The performance is dramatically reduced because of pseudo deleted keys.
In a 10 minutes it goes from 18000 transaction per minute to 9000 and

Hi  all,
I have a  fixedwidth .DAT file and a DB2 table, I have to create a flat
file by pulling data from both file and DB2 table. I tried using
IMPORT/LOAD utilities to load to a global temporary table and thought

I work for a company that has UDB 8.1 which is currently used to access
DB2 databases on Z/OS mainframe and also distributed DB2 databases on
Unix platform.  We are moving some of the application software from
mainframe platform (Cobol) to Visual Studio .Net (C#).  The mainframe

  Is there a way to convert application id ( db2 list applications
output) to a readable format?.
Auth Id  Application    Appl.      Application Id                 DB
  # of

This is probably an easy question but...
When working with DB2 7.2 IBM had a manual/book (pdf) called the Admin
API reference. This excellent volume covered basically all the Command
Reference tools for c programmers to integrate with.

I have created a database on DB2 8.1 and 8.2 for Windows using the
codeset "Big5" with the command:
db2 CREATE DATABASE TWBIG5 USING CODESET BIG5 TERRITORY TW
When I try to connect to the database using the DB2 Universal Type 4

I have been given the task to come up with Requirements, Comparision
and Migration document from Shadow Direct to DB2 Connect. I am very new
much to all this, but kind of know a little bit about both of them.
There has been a lot of pressure from business to move to DB2 Connect

Hi, i've read that 'Col BETWEEN expr1 and expr2' became stage 1 and
indexable in DB2 UDB for z/OS Version 8.
Is there any way to find out which predicates are stage 1 and indexable
in V7/V8?

I have a problem with db2 query...
I access to my database via jdbc using com.ibm.db2.jcc.DB2Driver. I
build my string query in a java class. I have some parameters in my
query, but there are two of these which gives me some problems:

This is the DB2 performance issue I was referring to .
We have requirement where we need to insert some values to the DB2
table and
get back its ID. Its possible by using an insert query , followed by

How do we increase the throughput between an app server and the DB2 server.
I tried increasing the bufferpage size, and get throughput around 5.4
mb/sec.  I compute throughput by calculating the total number of bytes
inserted/ total time taken.