I have approximately 5 instances on my test server that are identical
to my prod server.  On the prod server, when I look at the services
file, there is a single entry per instance and everything seems to be
working fine.  However, on the test server, after creating each

Is there recommended way to get the execution plan for queries involving
global temporary tables (from the UNIX command line or within a script)?
I run the queries in Perl scripts, and the only way that comes to my mind
is creating permanent tables that look like the temporary ones ...

going from 8.1.2 to 8.1.11, make our stored procedures very slow, here
is an example:
 select a, b from t1 a
      join t2 b on a.bkr=b.bkr

I have
create table table1 (col1 varchar(50));
insert into table1 values ('abc'), ('defg');
create table table2  (col2 varchar(50));

I'm using predefined SUM(() function on DOUBLE column. Surpisingly the
sum can give different results depending on the order of values in my
table.
Is that correct?

Sorry for quoting an old post and probably I am reading out of context
so my concern is unfounded. But I would appreciate if I can get someone
or Serge to confirm. Also unlike the question asked in the post below,
my question involves non-partitioned table loads.

i get this error SQL30020N  when selecting data from a table . I
altered this table earlier today when i do it a select * from the table
query runs OK, but when i join this table with 10 other tables (in a
scheduled job) i get this error. The job has been running fine untill

hi people,
           i am facing problems during the process of running my
script for db creation. i am using AIX5.2 OS with db2v8.1. During the
process of db creation i am getting the following error that i am

I get this error SQL 1247 when trying to load data into tables from
DataStage.
I have attached the error description below but am unable to understand.
Any suggestions highly appreciated.

I was wondering if there is a way to create a stored procedure that I
can
DECLARE Variables
then set these variables using a select statment  -- up to here works.

I have a requirement such that "user1" should be able to create tables
(or any db objects) only on a particular schema say "etl" so I tried
the following
1) Revoked createtab authority from public

Can someone point to a good source of information for converting data
types in DB2?
i.e. string to integers, etc

Hi, I am working on creating reports for which I want to make a single
stored procedure call to the DB. In order to do so, I need to be able
to parse an array of parameters containing elements as follows:
'20-30, 100--200, 400-500'

I am having some data reject on an insert of Japanese characters to a
Varchar column in my DB2 UTF-8 database.  I am trying to understand how
big to make the Varchar column for the inesert to work successfully for
all of my data.  I would also like ot understand if Vargraphic is a

Hi, I am trying to run my application (32-bit) on HP-UX 11.22i (64-bit)
and am getting the above message while dynamically loading libdb2.so
from my application.  I am using dlopen as follows:
dlopen(libName, RTLD_NOW);