We have bufferpools defined as automatic and they never change their
size from 1000 pages. we have 24 partitions on 3 BCU. I noticed while
going through db2 info center that SELF_TUNING_MEM has to be turned on
for automatic bufferpools to resize according to load conditions. we

All,
     Can someone tell me the IBM URL which can give list all the
PMR's we have opened up based on the Customer number?
Thanks

I have a table : test_table (pid varchar(30), rule_expr clob(33k))
The data for rule_expr is xml, eg:
<validate ErrorCode="attriberror" ErrorSeverity="ERROR"
Service="MyService" Document="MyDoc">

Before I rush of and start implementing one, I just want to check
whether someone already did and is willing to share their code? For
reasons that are beyond my control I need an sql implementation (i.e.
no java or c allowed).

autostart of a DB2 instance is controlled (since V8, I think) by:
-autostart enabled:  db2iauto -on <inst.name>
-autostart disabled: db2iauto -off <inst.name>
But how can I find out the current state for a certain instance, regarding

In my application I see a strange behavior. Whenever I rollback a
transaction, all ResultSets are closes. My Connection has auto commit
set to off.
The JDBC javadoc

I know this is redundant in V8.2 as anybody seen a performance
degradation if this registry variable is left configured following a
migration V8.2 FP15.
Thanks.

Hi, All,
When DB2 back up to TSM, from database side, how can we get the actual
backup image zise?
dbadutl only shows the image timestamp.

running DB2 v8.2, running into HWM problems
and wondered if we could drop the indexes and
recreate them after altering the pagesize for the
index tablespace.

This is kind of a continuation of a thread I started last month.
This also might be a case of "premature optimization is the root of all
evil", but its bugging me, so...
The following two statements both seem to do what I want, which is to return

Can someone confirm that these are the only AIX settings I have to
make when setting up DB2_PINNED_BP for a DB2 instance?
chuser capabilities=CAP_BYPASS_RAC_VMM,CAP_PROPAGATE
<instance_owner_user_id>

I'm looking for a way to use a query inside another query in the
following way:
First I make my first query(Q1) and I save it as Q1.
Then I want to reuse the result of that query inside query 2(Q2)

Env: DB2 LUW v8 FP16 running Linux.
create table FOO (a varchar (5), b varchar(5), c timestamp);
insert into FOO values
('A','B','2008-11-26-09.00.00.000000'),

when trying to drop a table from a CLI application while another app
is running a "SELECT *' statement, i run into a deadlock/timeout
situation.
More specifically, one app is trying to do an

What is the maximum size of a RAW device in AIX V6 and can UDB V9.5
FP2 accomodate this?