Hi!!
Is it possible to delete (or update) with join ??
For example
DELETE

I put the next lines in the overnor configuration file to force the
sessions ir there are more than 15 minutes doing nothing but it's not
working.  I need some help.
==========================================================

We use DB2-LUW-8.2.
I am doing some research on performance issues and I read about the
"OPTIMIZATION LEVELS' and their impacts on Joins.
How do I get the Optimization level implemented here? Can I query some

I am trying to find a view or a way I can figure out was protocol
users are connecting to the database.  Ie:  through TCP/IP, Local,
share memory, etc.  In Oracle, I know you can select on the  v
$session_connect_info and in SQL Server it is the sysprocesses view.

I must audit all user activities on a database and i don't know how to
proceed
I must keep the logs 3 years, and i must be able to know who changed one
record and the old/new values.

we have a java application using hibernate ORM mapper on top of db2
UDB v9. we are using type 4 jdbc drivers for connections.
Now the issue is we have a table with BLOB column and  when you issue
a query against this table, all the blob data are fetched into JVM

I have a table CARS that model cars coming in and out of a dealership.
(This is oversimplified)
create table cars(VIN varchar(50) not null primary key, location_id
int not null, inDate date not null, outDate date)

I have a a table which has the following columns:
PART_NUMBER
RESULT_TYPE
....

Hello to everyone,
I'm currently doing some UDF and stored procedure development in DB2 v.9.
I have a problem with the following construct:
SET (var_a, var_b) = (select a, b from table1 where ...)

I have a db2load script I'm using to populate a large table.
Ideally, my target table is required to have "Not Null" constraints on
a number of different columns.
I've noticed a  huge performance hit when I load the target table with

 I am using DB2 Enterprise v9 and I had the install done to make the
server use Windows Authentication. I would like to get the DB2 Server
to use sql authentication ( Eg user sa in sql server). From what I
read this is not possible in DB2. I read authentication in DB2 is

          Is there any particular advantage in having larger page
sizes for data warehousing environment over smaller pagesizes. For
example, is it better to have a 32 K page instead of an 8K page in
favor of faster sequential scans even though larger page size may

We have turned on INTRA_PARALLELISM and also bumped up sort heap ten
times.
are there any other suggestions with turning on INTRA_PARALLELISM like
io_cleaners, prefetchers etc.?

Previously posted on comp.databases.oracle.misc. Apologies to those
who read both groups.
I have created a link using generic connectivity from an Oracle
10.2.0.1

I'm writing a performance analysis utility that uses the snapshot
monitor C API to get statistics in the connection level. It seems that
the way I use the snapshot monitor is very inefficient : each snapshot
takes a few dozens of milliseconds and overall it consumes a lot of