I have a column of datatype CHAR(20).
When the DataStage job loads data of length 15 into it, it pads the
remaining 5 spaces with blank space.
This is happening with all CHAR datatype fields.

hai everyone......
                  A small issue here........ I was trying access a
remote database....... i issued the following commands.....
db2 catalog tcpip node <node name> remote <ipaddress> server <portno>

CREATE TABLE "MYSCHEMA"."T1"  (
                 "ID1" DECIMAL(8,0) NOT NULL GENERATED ALWAYS AS
IDENTITY (
                   START WITH +1

Hello Friends;
I am asking this as a database administrator, perhaps more on behalf of
the SQL Programmer.
We have a search on a view that uses a street number and a partial

What is the difference? Is LONG VARCHAR only 28 bytes longer then VARCHAR?
Is this the only difference?

Folks,
I have an AIX system running DB2 7.2 ESE (or EE or what ever it was called at
that time) and and HP-UX running UDB 7.2 also. The database resides on
HP-UX system and on AIX it is setup as remote database. For several reasons

-Is it possible to recover a tablespace just from a full offline backup
and offline incremental backup?
If not possible
-Can we recover tablespace from Full backup , Wednesdays incremental

I have recently upgraded from SuSe 8 to 9 (kernel 2.4 to kernel 2.6).
I am running DB2 8.1 FP 11 (aka 8.2 FP 4).  I have had slowdowns that I
suspect are related to the fact that an online backup is being run.
Can someone help me understand the behaviour described below and offer

I have a table with the following definition.
The primary key is  west_nme and west_eff_tms and i have created unique
index on them.
The foreign keys which reference other parent tables are

I need to mirror a set of my database data, that is create a database
which acts as a buffer in front of the real one.
We have in our DB2 database data which has been created over the last
100 years or so, and is obviously huge amount of data. All normal

i want so run a sql-script with user and password parameter.
My sql-script looks like:
--
connect to TEST user TestUser using TestPw

I'm trying to retrieve some records in my web application using a jdbc
Statement like this:
statement =
connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);

1. How can I generate sql file for just stored procedure statements
using db2look
2. while using db2 look with just the -tw option my file is always
coming out as a ps file even though i used -0 db2look.sql with it. What

Friends:
I've written a stored procedure that, among other things, writes
several million rows to a declared global temporary table (DGTT)
declared as NOT LOGGED using a (cursor) FOR loop. My rows-inserted

I have db2 EES installed on linux . db2level
DB21085I  Instance "db2inst1" uses "32" bits and DB2 code release
"SQL08025"
with level identifier "03060106".