I have a function that returns a table.
The function parses through data and builds a (potentially) nasty
query.
query = select column1, column2 from table1 where column 1 in (....)

I was looking de db2diag.log  (DB2 V7, AIX) and I have this error and
It's creating every 5 minutes the file .000
PID:312050(db2agent (idle)) Appid:none
drda_as sqljp_ddm_dict_search Pdrobe:413

I was planning to give 704 Advanced DBA Certification.
Wanted to know is it really worth doing that certification , as how
much this certification is valued for?
I am into a organization where managers really don't know about the

I am running DB2 8.1 Fp12.
I have a primary key consisting of 3 columns on a table. Is it
necessary for me to create another index on top of this primary
key(unique or not is another question)? I see access plans using

I keep getting the folowing error message in my db2diag.log every
couple of seconds, and I can not find any information on this on the
DB2 website or in the apr's
Can anyone give me a pointer why this is happening.

I am currently setting up our Java apps running in JBoss to use DB2
HADR capabilities with automatic reroute. My understanding is that I
need to use the DB2DataSource for this to work. The problem is that
the JBoss connection pooling uses it's own DataSource but the

As far as I know db2 uses the OS for authentication of users.
We are using the pam_ldap modul for OS authentication but it seems db2
is not working correctly with this config:
I've done a db2 trace of a "connect to database" and found a

Knut,
I lost your response to me about my DB2 V7 and the problem I had with
missing FP2_WR21246 - but I remember the gist of what you said.
SERIOUS mistake on my part and I thankyou kindly for your help which