Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Location
    Florida
    Posts
    16

    Unanswered: DB2 CLI Application

    We have siebel application which uses DB2 CLI interface. We are facing a strange problem with respect to performance. Any application operation executed for the first time (in a day) takes longer time. Same operation if executed second time, the execution time reduces by half.

    We tried collecting the cli traces...

    First Pass

    Function Name Total Application CLI
    Time Time
    ----------------------------------------------
    ------
    SQLFetch 226 0.155 0.573
    SQLPrepare 22 0.001 0.017
    SQLBindParameter 39 0.001 0.002
    SQLBindCol 1132 0.022 0.050
    SQLSetStmtAttr 53 9.886 0.002
    SQLExecute 31 0.001 15.861
    SQLFreeHandle 3 0.164 0.001
    SQLAllocHandle 22 11.978 0.011
    SQLCloseCursor 25 0.008 1.615

    Second Pass

    Function Name Total Application CLI
    Time Time
    --------------------------------------------
    -
    SQLFetch 227 0.192 0.524
    SQLPrepare 22 0.001 0.017
    SQLBindParameter 39 0.001 0.002
    SQLBindCol 1132 0.021 0.036
    SQLSetStmtAttr 50 0.006 0.002
    SQLExecute 28 0.000 5.242
    SQLFreeHandle 13 1.956 0.003
    SQLAllocHandle 22 6.433 0.008
    SQLCloseCursor 27 0.012 1.421

    Observe that SQLExecute, SQLAllocate, SQLSetStmtAttr took lesser time in second pass.

    About the environment, we have DB2 database on OS/390 and are using db2 connect to access the database from a windows db2 client.

    Can anyone throw some light on this behaviour??

    Nagesh
    Nagesh

  2. #2
    Join Date
    Aug 2003
    Posts
    2

    Connection Performance

    If it is the first connection of the day, unless you issue the DB2 activate command, like on AIX, then all DB2 resources, agents, etc must be allocated. After the first connect as long as an application maintaines a connection, subsequent connections perform better due to less connection overhead.

Posting Permissions

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