I have taken an db2 v8.1 fp15 backup on AIX and want to restore it
into a db2 v8.1 fp15 Solaris Box. If the backup was uncompressed, the
cross-platform restore works without any issue. But for compressed
backup images, since the decompression requires compression libraries,

I am trying something so simple, I have no idea why it doesn't work!
create table test1 (c1 VARCHAR(16));
insert into test1 values( '12154846' );
select translate(c1, '5', 'A') from test1;

I want to convert some specific tables to table based
partitioning.One of the methods i understand is by altering the
partitioning index from cluster to non-cluster.  Then alter the index
back so that it is clustered.  My question is ,how can we find the

DB2 V9.5 LUW, Is there any way that one can force Asynchronous index
cleanup (AIC) after detaching a partition in a range partitioned
table?
Thanx in advance

DB version - DB2 9.1 on AIX
Consider the following script construct...
open curs1;
fetch curs1 into a, b;

I'm trying to convert a T-SQl query to DB2.
I have two tables policy and policyHolder.
I would like a count of the amount of distinct poicyHolders per
policy, for a particular set of new policies.

Hi, I have installed DB2 ESE on AIX 5.2. And when I try to execute
db2licm -l I get the following error:
exec(): 0509-036 Cannot load program db2licm because of the following
errors:

I have some data in rows which I want them in columns. Below is an
example:
col1    col2      col3
------    -----        -----

I apologize if this is available in a FAQ somewhere.
My question is this:
The DB2 Universal Driver jars are shipped with DB2 for z/OS
(db2jcc.jar and db2jcc_license_cisuz.jar).

I have 2 strings here which has 1 or 2 digits different because of
typo, like below
179705723    179705732
Any simple way I can make them similar.

After doing some googling for the error below, it seem to be that this
error pertains to db2 v8.2 or 8.1.
2008-01-10-10.10.36.579007-360 I16865488A285      LEVEL: Severe
PID     : 160024               TID  : 1           PROC : db2fmp (C) 0

Is it possible that a reorg index doesnt use a sys temporary
tablespace and use the index tablespace in a reorg index? (db2 udb v8
fixpack 12 -  there are 2 8k system tablespaces on this DB)
The command is REORG INDEXES ALL FOR TABLE xxx.xxx ALLOW WRITE ACCESS

I am coding Java and C Stored procedures for DB2 LUW 9.5.  I read with
interest
about the availability of arrays as parameters to stored procedures.
Is there a way within a trigger to build an array to pass to a stored

Is it possible in the new DB2 9.5 to use the content of an array in an
IN expression?
Say we have the ddl:
CREATE TYPE Numbers AS Integer ARRAY[];

How can I lookup the current isolation level?
Thanks in advance