I have a third-party Java application running queries with parameter
markers (through PreaparedStatement).  I wish the server optimize all
queries from scratch as there is oppotunity to match submitted
querires with MQT.

Does  V8 of DB2 zOS supports Updatable UNION ALL Views in DB2 Universal
Database Version 8.
I used it in DB2 9.5C after reading Serge Rielau
Updatable UNION ALL Views in DB2 Universal Database Version 8.

I am learning IBM-DB2, my PM asked me the following question, Please
help me on this :
You are a new employee at the company and the only DB2 DBA.
You were just informed by the management that one of the DB2 database

Env: DB2 V8 LUW FP16 running Linux
create Table X (machine_id varchar(24) not null, ctime timestamp not
null);
create index iFoo on X (MACHINE_ID, CTIME) allow reverse scans;

In DB2 UDB 9.1 and AIX 5.3, I want to have the logs for a database in
this folder:
/db2/logs/db1
For that we use:

Hy,
we have an "old" but running db2 V7.2 server running on OS/2 Warp.
We would like to access it from a Linux Ubuntu machine.
What client should we install ?

I'm just getting my feet wet in DB2 UDB (9.x), after years as a Sybase
DBA.  In Sybase, if I wanted to delete data from one table based on
joining that table to a second table, I'd use this syntax
delete TABLE_A

I am facing some strange issue in DB2 UDB 9.5.1
I have created a database on DPF implemented environment and I tried
to execute following commands
Db2 create table test ( name char(10) not null, acno integer not

I am runnig v95.
I have a query "select * from A, B where B.b<2000"
I create a MQT as  "select * from A,B where B.b<2000"   (identitcal to
the query), and the optimizer will use this MQT to answer this query.

In version 8.2 ESE we used alternate fixpacks to allow multiple fixpack
levels for different instances, and to allow an instance to be deprecated
back to the previous fixpack (with certain limitations).
In looking at V9.5 install procedures there are no alternate fixpacks. There

I am getting the error "SQL0101N  The statement is too long or too
complex.  SQLSTATE=54001" while trying to rebind a package on the
database. I am connected as instance owner.Here's the info on the UDB
software installed on db server -

I have to use
         "set current refresh age any"  and
         "set current maintained table types for optimization all"
to let optimizer pick my user-maintained MQT.

When running an export:
export to css.ixf of ixf select css_id, service, client_id, site_id,
css_label, css_abbr, sos_flag, city,          state, 'N', 'N' from
userid.css_defn

One query is failing on the database and its a long query which was
running fine earlier. One possible reason we can think of is increase
in data in tables in query.
It is failing with following error:-

My app needs to insert thousand value rows into a mostly empty table
(data are read from a file).  I can either use inserts, or use merge.
The advantage of using merge is that in the few cases where the table
is not empty, it can take care of the updating part, which makes the