Professional Web Applications Themes

DB2 Connect V8.1.2 slow then V7.2.9 - IBM DB2

Greetings, Currently I have DB Connect V8.1.2 and V7.2.9 on two identical Windows 2000 Boxes. All the TCP/IP registries are the same. The host Databases are same. But the response time of V8 always slow then V7. When I did snapshot for the V8 and V7. I found out that in V8 snapshot, it has no Package name listed. I ran a same query on V8 and V7. Here are the snapshots: For V8: .... Outbound communication address = 192.168.26.2 5023 Outbound communication protocol = TCP/IP Inbound communication address = *LOCAL.DB2 First database connect timestamp = 07-11-2003 13:40:59.260635 Host response ...

  1. #1

    Default DB2 Connect V8.1.2 slow then V7.2.9

    Greetings,
    Currently I have DB Connect V8.1.2 and V7.2.9 on two identical Windows
    2000 Boxes.
    All the TCP/IP registries are the same.
    The host Databases are same.
    But the response time of V8 always slow then V7. When I did snapshot
    for the V8 and V7. I found out that in V8 snapshot, it has no Package
    name listed.
    I ran a same query on V8 and V7. Here are the snapshots:

    For V8:
    ....
    Outbound communication address = 192.168.26.2 5023
    Outbound communication protocol = TCP/IP
    Inbound communication address = *LOCAL.DB2
    First database connect timestamp = 07-11-2003
    13:40:59.260635
    Host response time (sec.ms) = 3.902979
    Time spent on gateway processing = 0.001409
    ....
    Statement = Static Commit
    Section number = 0
    Application creator =
    Package name =
    SQL compiler cost estimate in timerons = 0
    SQL compiler cardinality estimate = 0
    Statement start timestamp = 07-11-2003
    13:41:20.762671
    Statement stop timestamp = 07-11-2003
    13:41:20.767005
    ....

    For V7:
    ....
    Outbound communication address = 192.168.26.2 5023
    Outbound communication protocol = TCP/IP
    Inbound communication address = *LOCAL.DB2
    First database connect timestamp = 07-11-2003
    13:34:04.021190
    Host response time (sec.ms) = 0.609894
    Time spent on gateway processing = 0.037881
    ....
    Most recent operation = Static Commit
    Most recent operation start timestamp = 07-11-2003
    13:34:33.174802
    Most recent operation stop timestamp = 07-11-2003
    13:34:33.176628
    Host execution elapsed time = 0.469747
    Statement = Static Commit
    Section number = 0
    Application creator = NULLID
    Package name = SQLC2D04
    SQL compiler cost estimate in timerons = 0
    SQL compiler cardinality estimate = 0
    Statement start timestamp = 07-11-2003
    13:34:33.174802
    Statement stop timestamp = 07-11-2003
    13:34:33.176628
    ....

    My questions are:
    1. Is that V8 is missing Package Name related to the slow performance?
    2. If it is, how do I fix the problem?

    Any inputs are appreciated.
    Andy Zou Guest

  2. #2

    Default Re: DB2 Connect V8.1.2 slow then V7.2.9

    Hi

    I'm testing the DB2 Connect EE V8 right now, and don't see big differences
    in the reply-time compared to V7.

    Have you tried, to eliminate network difference, to ftp-transmit a file
    between your DB2-gateway and z/OS ?
    What about connection pooling and stuff like this ?

    /Kim


    "Andy Zou" <zou.xiaoquanmayo.edu> wrote in message
    news:6b0a1e74.0307151223.4ef06ac7posting.google.c om...
    > Greetings,
    > Currently I have DB Connect V8.1.2 and V7.2.9 on two identical Windows
    > 2000 Boxes.
    > All the TCP/IP registries are the same.
    > The host Databases are same.
    > But the response time of V8 always slow then V7. When I did snapshot
    > for the V8 and V7. I found out that in V8 snapshot, it has no Package
    > name listed.
    > I ran a same query on V8 and V7. Here are the snapshots:
    >
    > For V8:
    > ...
    > Outbound communication address = 192.168.26.2 5023
    > Outbound communication protocol = TCP/IP
    > Inbound communication address = *LOCAL.DB2
    > First database connect timestamp = 07-11-2003
    > 13:40:59.260635
    > Host response time (sec.ms) = 3.902979
    > Time spent on gateway processing = 0.001409
    > ...
    > Statement = Static Commit
    > Section number = 0
    > Application creator =
    > Package name =
    > SQL compiler cost estimate in timerons = 0
    > SQL compiler cardinality estimate = 0
    > Statement start timestamp = 07-11-2003
    > 13:41:20.762671
    > Statement stop timestamp = 07-11-2003
    > 13:41:20.767005
    > ...
    >
    > For V7:
    > ...
    > Outbound communication address = 192.168.26.2 5023
    > Outbound communication protocol = TCP/IP
    > Inbound communication address = *LOCAL.DB2
    > First database connect timestamp = 07-11-2003
    > 13:34:04.021190
    > Host response time (sec.ms) = 0.609894
    > Time spent on gateway processing = 0.037881
    > ...
    > Most recent operation = Static Commit
    > Most recent operation start timestamp = 07-11-2003
    > 13:34:33.174802
    > Most recent operation stop timestamp = 07-11-2003
    > 13:34:33.176628
    > Host execution elapsed time = 0.469747
    > Statement = Static Commit
    > Section number = 0
    > Application creator = NULLID
    > Package name = SQLC2D04
    > SQL compiler cost estimate in timerons = 0
    > SQL compiler cardinality estimate = 0
    > Statement start timestamp = 07-11-2003
    > 13:34:33.174802
    > Statement stop timestamp = 07-11-2003
    > 13:34:33.176628
    > ...
    >
    > My questions are:
    > 1. Is that V8 is missing Package Name related to the slow performance?
    > 2. If it is, how do I fix the problem?
    >
    > Any inputs are appreciated.

    Kim Bundgaard Guest

Similar Threads

  1. Slow DB
    By frizzle in forum MySQL
    Replies: 11
    Last Post: February 15th, 02:29 PM
  2. How to use “RDS.Connect” to connect to a MS Access database?
    By hannaman@msn.com in forum ASP Database
    Replies: 0
    Last Post: August 2nd, 11:09 PM
  3. Slow printing on fast copier but fast printing on slow printer!
    By Davie_Helms@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 0
    Last Post: May 7th, 08:24 PM
  4. SLOW DOWN..Why is my Photoshop CS Super Slow in PANTHER?
    By Aerosyn-Lex@adobeforums.com in forum Adobe Photoshop Mac CS, CS2 & CS3
    Replies: 4
    Last Post: February 23rd, 10:42 PM
  5. Slow! Slow! Slow
    By Al Millstein in forum Adobe Photoshop Elements
    Replies: 4
    Last Post: August 17th, 07:59 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139