Results 1 to 12 of 12
  1. #1
    Join Date
    Apr 2004
    Posts
    54

    Unanswered: Jdbc, metadata slowly!

    Hi!
    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!

    Thanks!

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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...

    Andy

  3. #3
    Join Date
    Apr 2004
    Posts
    54
    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...

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Is it any faster if you query the catalog views directly?

    Andy

  5. #5
    Join Date
    Apr 2004
    Posts
    54
    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..

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    So,

    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?

    Andy

  7. #7
    Join Date
    Apr 2004
    Posts
    54
    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...

  8. #8
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Are you running this on the DB2 server or from a workstation?

    Andy

  9. #9
    Join Date
    Apr 2004
    Posts
    54
    Yes i'm working from remote client (Windows XP 32 bit) with my jcc Ibm driver and license and Sun 1.4.2 VM..

  10. #10
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Have you tried the IBM Java JRE?

    Andy

  11. #11
    Join Date
    Apr 2004
    Posts
    54
    Yes, in my client!

  12. #12
    Join Date
    Apr 2004
    Posts
    54
    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •