after installing DB2 V8.2.3 on OpenSuse 10.1 (in vmware)
we have created a database instance with the restore command:
db2 "restore database $OLD_DB user db2inst1 using db2inst1 from
$BACKUP_DIRECTORY taken at $TS into $DB".

I am looking in to utilising the new functionality of DPSIs on zOS UDB
(DB2 v8), but I have a question regarding the following scenario.
- The first table is an Account table whose columns are Account,
Invoice Date, Partition#.  This is a NPSI table.

I have database  db2 udb 7.2
with following table and datatype
CREATE DISTINCT TYPE APP.NOTEPAD  AS SYSIBM .CLOB(4096);
CREATE TABLE APP.AP_NOTE_PAD  (

anyone knows if i can create index on global temp tables
if yes, will i use session schema for indexes also ?
if yes, can i create all kinds like unique, clustered, mdc etc indexes
in global temp table ?

When I'm using IMPORT with INSERT_UPDATE I sometimes get
SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result of a
query is an empty table.
I'm not sure why this happens. The problem is that I get rejected rows

I am new to creating DB2 SQL Procedures and I need a little help.
This works perfectly when I am just using it through my SQL Editor:
SELECT * FROM SALESTABLE
WHERE VENDOR LIKE 'ELK' || '%' AND CUSTOMER LIKE 'HOO' || '%'

My bulk data is sitting on a big table. I cluster its rows using views
and SQL-UDFs. So far it was ok, but its performance will become an
issue soon. Therefore I am looking for alternatives.
Any recommendation will be greatly appreciated.

this is my first thread in this newsgroup :)
First of all, I wanna explain :
I've a DB2 installed in AIX O.S.;
I've a remote server (OS400) in which there are some applications (in

(re: DB2 LUW v8.1 fp8 optimisation Level2)
Can anyone explain why the following difference have wildly different
plans - this seems very fundamental)
select p.part_number,

two questions:
- is there a way to call the INSERT-Statement from Java (JDBC).
(import from file of del replace into table)
- in db2 there is no truncate-statement, is it?

I would like to signal a warning from a trigger but what I get it's
always and error instead of a warning. Is it possible to signal a
warning from a trigger ?
....

I get the following error message when trying to connect to a host
database (OBCD connection) with "MS Query".
SQL0471N Invocation of routine "SYSIBM .SQLTABLES   " failed due to
reason "00E7900C".

I am using DB2 v 8.2 , Win XP OS. I have creaed a sample situation
which results in a deadlock created by appl1 & appl2.Now, I want to
release one of the locks (using CLP, not Control Center) so as to
release the deadlock.now how can I be sure that I am releasing the

I have an SQL Script (test.sql) which I have to call via: su -root -c
"db2 test.sql".
Now I need a variable in the SQL-Script which is stored i a different
propertie file.

I am using DB2 v 8.2 Enterprise Server Edition. We can replicate only a
single table at once. Now, how to replicate multiple tables in a single
shot.
Any suggestions would be highly appreciated.