When I import data from an CSV file, data seems to be converted (into
iso-8851-1 ???) although the csv data and the db are in utf-8 format.
I also tried "modified by codepage=1208" but it failed too. (but with
different import results):

Java web application, based on J2EE  and JBOSS 4.0.0.2, installed on
Windows 2003 Server
Database: DB2 on AS/400 iSeries V5R3M0
Which JDBC driver can be used? One choice is DataDirect, but they are

We have a DB2 server using AIX 5.3 lpar with 10 logical cpus. There
are nine DB2 instances on the server with five at DB2 V9.1 FP3 and
four at DB2 V8.2 FP8. One of the DB2 V9.1 instances has INTRA_PARALLEL
set to ON and for all other instances it is set to OFF. The WebSphere

(DB2 9.1 LUW)
I have 'heard' that the encryption output of a character string, is
different depending on the database codepage.
i.e If we have encrypted data in a current non unicode database and we

All the time I'm working with DB2 I feel that DB2 authers just hate
their customers and users of their products...
The last example - I want to create a stored procedure in the script,
use it to add data to database inside this script and then drop this

I have a sql that I use within an SP..
INSERT INTO xx.yyyy( c1,cnt1,sum1 )
(SELECT    COUNT(*), sum(yyy)  FROM xx.yyyy_dtl WHERE<> GROUP BY  <>)
Every time I run this, I get different values for the cnt1 variable. I

We have installed UDB 9.5 on HP-UX IA64 machine.  We would like to
install DB2 8.2 client on HP-UX PA-RISC V11.11. We want to install
only on HPUX V 11.11 since we have licensed version MF Cobol on this.
My question is: Can DB2 8.2 client talk to DB2 server 9.5?

Our 4K index tablespace has grown to 64GB. It has maxed out. I want to
increase the page size from 4 to 16K. What will be the safest method?
Any suggestions? We are in DB2 UDB 8.2 Sun Solaris 8.
Thanks.

Today my friend ask me a question about setting logsecond to -1. The
following sentences were copied from DB2 InforCenter:
"By setting logsecond to -1, you will have no limit on the size of the
unit of work or the number of concurrent units of work. However,

Is it possible to have v8.2 32-bit instance co-existing with v9.1
installation on UNIX environment. I see that it is not possible in
Windows from the DB2 v9.1 product manuals.

Can someone please confirm that DB2_SKIPDELETED has been removed from
the product?  IY87229 says so, but it is STILL in the 9.5
documentation.  db2set lets me set it in 9.5 GA.
Thanks in advance,

I noticed some strange behavior when executing a SQL query on our AS/
400 (V5R3) DB2 database. The query is like this:
WITH
   R AS (SELECT t1.ID, t2.ID

Dear all IBM users,
I need a exact version of DB2 v7.1.0.8 Runtime Client for Windows as
my CD-R cannot be read anymore. I have searched the IBM FTP and Web
sites but I cannot found the exact version.

I am sure lot of people like me have this question...
How to become a DB2 DBA?
Almost all employers needs experienced DBAs, and to get REAL DBA
experience, one has to work as a DBA. DBAs in this forum - could you

The table became inaccessible due to an error during an insert in 'not
logged' mode. Now I can't drop it, since it was declared using
'restrict on drop'.. Pleaseeeeee heklp. It's using 400 GIGS........