I am trying to suppress warnings from SQL in CLP using its -w option
but had no luck to make it. So I have two dummy tables t and x of the
same simple structure, and table x is empty, then I am doing as follows
from CLP (DB2 LUW client):

DB2 WSE LUW 8.1.5
A few questions:
Why doesn't IMPORT have IDENTITYOVERRIDE support like LOAD does??
Why doesn't LOAD have CREATE INTO (ala IXF) like IMPORT DOES?

I have a table with 2 columns
** CREATE TABLE test (emp_num DECIMAL(7) NOT NULL,emp_name CHAR(10) NOT
  NULL) and i have inserted a number of records.
** Now, I want to insert a new record (3232,'Raindeer') based on the

I am doing a db converison from windows v7 to aix v8. The db contains
many LOBs. I did an export specifying the LOB option, compressed the
data (using tar and gzip for windows) , ftp the data, and decompressed
the data. I then ran the import using the same LOB option and the

I used the Create Database Wizard in CC to create a quick test
database.  However, I screwed up when it asked about what
database path (DFTDBPATH) to use.  Rather than using the DFTDBPATH
that is the default in my dbm cfg, I specified a database path

When I run a backup script from the Task Center i get these messages:
2006-02-15-21.30.08.515000+060 E21985H390         LEVEL: Error
PID     : 2408                 TID  : 3416        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000         DB   : XDKE00

Another novice question.
I want to insert multiple records into my DB2 database using stored
procedure but I do not know how many I would like to insert at any
given time. Each record has 6 columns (fields).

Are there any implementations of truncate in db2. Is it going to be
implemented in the future?
Is there an alternate way of doing a truncate of a table that has a high
record count without using "load" and is fast?

I have a few instances of same java application working concurrent on
DB2 v8.2. All of them:
- has a transaction isolation level set to TRANSACTION_READ_UNCOMMITTED,
- try to insert into same table T1,

db2 v 8.1.3 Windows
I need to provide following information in single query for an inhouse
tool.
1)Schema Name

I can't seem to find the eqivalent to the MSSQLServer "print" command ?

Running DB2 8.2 on AIX5.2
When a new application was installed, a consultant recommended that
large tablespaces be defined with just one container, given that the
container was striped into a raid10 array of discs.

Is there a tool for converting oracle scripts
to db2?
In particular I want to convert oracle example
script hr_main.sql to db2.

Hi All;
We recently upgraded to FP10 (from FP6) in our data warehouse
environment. Have had a couple of issues with Oracle federation and
minor configuration changes and all has been stable. Queries and day

how to find the base table of  an ALIAS ?
thanks