var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Jdbc, metadata slowly!
I have DB2 Udb (FP13) and my problem is the slowest metadata capture from schema, especialy the method "getExportedKeys".
I check every admin parameter but all are ok, I have no idea!
Can you give a more detailed accounting of your problem. Also include your
DB2 OS. Maybe if you gave code snippets of where you problem is...
OS is Linux (Suse Enterprise 9) with 64 bit instance ( cpu amd Opteron) and the dbms is DB2 Udb ESE with last fix pak (13).
This problem doesn't verify on DB2 Udb fix pak 8 with instance 32 bit...
The metadata capture go slowly especially in "getExportedKeys" method..i look some redbook and I make a parameters comparision with the healthy dbms without solution...
Is it any faster if you query the catalog views directly?
Unfortunatly the software company must use driver (type 4) with jcc connection, this is the only way to capture metadata and builds the java objects!!
Aniway all is fast except the method "getExportedKeys" for the exported foreign key..
1) it runs fine from 8.1.8 32 bit
2) it runs "slow" on 8.1.13 64 bit.
3) you cannot play with the code to determine if there is a problem there.
Are you running this on the servers?
Your summary is correct!
No because I'm using standard and minimal code, I know jdbc well enough...
I'm sure that this problem is on DB2 server.
I tried to use the "Configuration Advisor" and manually modify the parameter values without saw change...
Are you running this on the DB2 server or from a workstation?
Yes i'm working from remote client (Windows XP 32 bit) with my jcc Ibm driver and license and Sun 1.4.2 VM..
Have you tried the IBM Java JRE?
Great! I resolved following these steps:
- turn on the trace of jdbc jcc driver
- see what package db2 try to use with hight time..
- bind of the package *.bnd (in my situation db2schema.bnd)
Now my DB2 8.2.6 is fast!!
aniway thanks ARWinner!