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

[Adam Tukov]

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????

[Unregistered]

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 ?