Professional Web Applications Themes

terrible remote (ODBC) performance for lob columns under AIX 64 bit version 8 - IBM DB2

We have DB2 ESE version 8 sp2 under AIX. Most databases have about 1000 tables, and are rarely accessed much. If, on the AIX box, I do a "select * from syscat.tables" piped to a file with no stdout (-r and +o options), the query runs in about 1 second. If I run the SAME query against syscat.tables under windows (via ANY ODBC tool) the query takes about one minute. If the lob column(s) are left out of the query, it runs in about a second. This terrible performance did not appear until the db2 instance was 'converted' from 32 ...

  1. #1

    Default terrible remote (ODBC) performance for lob columns under AIX 64 bit version 8

    We have DB2 ESE version 8 sp2 under AIX. Most databases have about
    1000 tables, and are rarely accessed much.

    If, on the AIX box, I do a "select * from syscat.tables" piped to a
    file with no stdout (-r and +o options), the query runs in about 1
    second.

    If I run the SAME query against syscat.tables under windows (via ANY
    ODBC tool)
    the query takes about one minute. If the lob column(s) are left out of
    the query, it runs in about a second.

    This terrible performance did not appear until the db2 instance was
    'converted' from 32 to 64 bit mode.

    I'm convinced that there is some sort of configuration problem.

    Any thoughts????
    Adam Tukov Guest

  2. #2

    Default terrible remote (ODBC) performance for lob columns under AIX 64 bit version 8

    Quote Originally Posted by Adam Tukov View Post
    We have DB2 ESE version 8 sp2 under AIX. Most databases have about
    1000 tables, and are rarely accessed much.

    If, on the AIX box, I do a "select * from syscat.tables" piped to a
    file with no stdout (-r and +o options), the query runs in about 1
    second.

    If I run the SAME query against syscat.tables under windows (via ANY
    ODBC tool)
    the query takes about one minute. If the lob column(s) are left out of
    the query, it runs in about a second.

    This terrible performance did not appear until the db2 instance was
    'converted' from 32 to 64 bit mode.

    I'm convinced that there is some sort of configuration problem.

    Any thoughts????
    Unfortunately, I don't have the solution.
    Instead, I thiink I'm having the same or a similar problem.

    Since I'm using a 64 bits ODBC driver to access my AIX datafiles, performance is cut in half.
    I don't know what lob columns are.

    Have you found a solution ?
    Unregistered Guest

Similar Threads

  1. Replies: 2
    Last Post: July 31st, 04:21 PM
  2. Performance issue : local vs remote
    By Twiggy182 in forum Coldfusion Server Administration
    Replies: 1
    Last Post: July 14th, 03:47 PM
  3. J2ee version of CFMX7 & ODBC server
    By hinsbergen in forum Coldfusion Server Administration
    Replies: 1
    Last Post: March 23rd, 12:12 AM
  4. Can't find the "Rows and Columns" option in the new version
    By lisa_herrera@adobeforums.com in forum Adobe Illustrator Windows
    Replies: 1
    Last Post: May 25th, 08:36 AM
  5. ODBC and performance
    By Danny De Koster in forum Informix
    Replies: 2
    Last Post: September 26th, 08:49 AM

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