Just by knowing the size of the datafiles of a database, how can I
make an estimate of the recovery time. I have have a backup file, does
db2ckbkp have a switch to tell me the estimated recovery time without
actually recovering the database?

Envirnoment is UDB 7.2 fp9 on AIX.
I'm familiar with using "dynexpln" for quickly comparing
access plans for directly executable queries.
dynexpln docs suggest it cannot work with sql that contains

This is pretty asthetic but we had a change in out DBA and every time
we create a new task in the Task Center and set it to notify a contact
the From: XXXXX in the message is always his name.  Does anyone know
how to change it.

Hi,
FYI & comment:
We have triggers that call SPs.
If the Stored Procedure is invalidated, e.g a dependent table is dropped.

I am searching documentation (Redbooks, White Papers, ...) about using DB2
as a backend for Microsoft Access.
Can anybody help me?
Thanks a lot

i need to see the db activity when a app makes some operation on it,
for example select, insert, update, delete thanks in advance

Other than db2licm -l command is there another way to verify in which
bit mode ( 32 bit mode or 64 bit mode ) DB2 is running on AIX 5.2L?
Thanks,
Yasaswi

Why does DB2 allow us to define the PCTFREE & MINPCTUSED for the index
pages, but not data pages when we try to create a regular table?

How to estimate the size of log space when I need to run "INSERT INTO
tgt_tbl SELECT * FROM src_tbl WHERE..." ?
What is the difference of before image between the above INSERT stmt and the
following:

Hello, all.
I have the following production DB2 environment.
DB2 8.1.4 (fp4) WG edition with 2 production databases on Windows 2003
standard edition.

When running the db2 reorchk command, I receive the following Table Name...
BB        FLASH_ORDER_LINE_>     157     0     3     4    11304   0  93  75 --*
Is there anyway to display the full Table Name????
Thanks in advance....

We are using DB2 ESE on AIX, having most tablespaces DMS on filesystem
This has the disadvantage that all data which is read into bufferpools also
is read by JFS filesystem paging.
On db2 8.1 we used these registry settings

Why do the two hex columns display differently between AIX and Linux
but yet both are DB2 and relatively close in fixpacks?
On Linux, DB2 Level -- DB21085I  Instance "mdkint01" uses "32" bits
and DB2 code release "SQL08020" with level identifier "03010106".

I'm struggling supporting national characters of different origin in a mixed
environment
using PHP, Perl and Java.
I have a database created with character set UTF-8, but I'm in doubt when

I have to deal with the following problem to increase the integrity of
our data. While doing a load to a DB2 table from a TXT file if there
is a double quote before the data that needs to be parsed, load parser
ignores the specified coldel delimeter. For instance,