We have a requirement to run a query on all of the DB2 databses on a
regular basis.
Obviously, doing this manually is going to be a waste of several
people's time.

we have column with GENERATED ALWAYS AS DEFAULT. So, we can insert into
this column manually and also let db2 generate a value for this column.
Given a scenario, how can i find the NEXTVAL for this identity column?
We can do "VALUED NEXTVAL FOR SEQUENCE", but for identity how can it ...

I have been asked to copy a handfull of table spaces in to new
identical table spaces so that they can be accessed with out running
into the nightly batch update. I first did a FULLCOPY with SHARELEVEL
REFERENCE of the table space. Then I copied the DDL used to create the

I'm trying to declare and use temporary tables. I have written the
following code in Java. Creating the tablespace (i can see the
tablespace created using the Control Center), the temporary table and
even inserting the values execute fine (even the executeUpdate while

I am working on a DB2 replication program that used to work. I ran the
"warm" capture program to get a cold start and I am running the apply
program, but, the apply does not replicate the data. I update a test
table and I see that the CD table gets new rows. But the apply program

Where can I find those?
IBM doesn't provide free doc for this?
Thanks!

Just inherited a DB2 system, and I know nothing about it.  Actually it
says DB6, which I guess is a variant of DB2, running on Linux?
Is "db2" the command line processor that I want to use?
Any suggestions for docs for dummies would be helpful.

does anybody have a hint, why a get the Query Patroller, when I download
ftp://ftp.software.ibm.com/ps/products/db2/fixes2/english-us/db2winIA32v8/fixpak
/FP7b_WR21358/FP7b_WR21358_PE.exe
(link on one line) found on
http://www-306.ibm ...

I read a lot about DB2 INSERT performance here. I have a nice story as
well.
The thing is, I work on 2 installations of DB2 (on completely different
locations) which run on different (but same generation) hardware.

I am using DB2 UDB v.8.2, with TPC-H 1GB database.
When I use the design advisor, and set a disk space limit of 100 MB,
the design advisor does not recommend anything.
db2advis -l 100 -d TPCH -i c:\thequeries.sql -k OFF -m I -t 10

Having a bear of a time trying to implement replication under 8.2
environment. I've created all of the control structures on both source
and target database and can actually see data being staged in the CD
tables. I look at the subscription sets and see that everything seems

Anyone have any reservations about using NAS (Network Attached Storage) for
DB2 active logs in a high volume OLTP environment?

db2 8.2 (8.1 FP9a) on AIX 5.2.
Please can someone tell me what the implications (if any) are of
storing our application binaries outside the
/home/<instance/sqllib/function directory (e.g. in /appl/code)?

Hi @ll,
i have two tables with very big performance problems under another
database this statements take 1-3 seconds under Version 8.2 fixpack 7
this takes 30 seconds or sometimes 10 seconds. I made a reorg on all

I have a SQL proc that does the following below (this is a MDC rollout; I
drop indexes because YEAR_NUM which is a dimension, is part of the unique
index, and the optimizer decides to delete based on the Unique index for a
800 timeron difference out of 33 millions)