If i do "db2 disconnect all"  after an application finishes, does it
mean that any application that connects after this will find the buffer
pool "cold"?  Or the pages accessed by last application will be still in
buffer pool? Apparently when I do "db2 disconnect all" at the end, ...

Hi, simple question
I have 2 hugge tables Table A and Table B. I define a view over these
2 tables (select,..joint,...)
My question is:

I recently came across a webcast from CA, on 'What's New in SQL for
DB2 9 Part 1' about to take place on april 9th. Sadly, it is for
mainframers, and I am a DD user. Is there any kind of documentation/
presentation/cast available on this topic?

MAXRC is UDF Returns  GREATEST Value of list of COLUMNS – TYPE CHARACTER
Example of use:
SELECT EMPNO, FIRSTNME,MIDINIT,LASTNAME,WORKDEPT,                
  MAXRC(FIRSTNME,MIDINIT,LASTNAME,WORKDEPT) AS MAX_IN_ROWS

In DB2 LUW 'till Version 9 it is not possible to execute dynamic SQL
in a UDF (at least as I understand it; maybe I'm just doing something
wrong). Is this planed to be included in Future Versions? Somebody has
an Idea for a workaround to this?

In our company for internal security compliance we need to encrypt the
data to/from DB server;
What is the encryption algorithm used by DB2 & what key lengths are
supported in DB2 LUW v8 & v9 when we use DATA_ENCRYPT authentication

I have a table which is range-partitioned by a date column (one year per
table-partition).
Currently there are five table partitions (second number is the number of
rows per table-partition):