DB2 8.2 32bit to 64 bit conversion

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ShengTC@gmail.com - 02 Mar 2006 05:23 GMT

Hi all,

After we upgraded a db2 database on AIX 5.2 from 32bit to 64bit, we
noticed a strange problem. That is, some queries would perform table
scan instead of index scan. However, once the database is downgrade
from 64bit to 32bit, then these same queries would perform index scan.

Has anyone experienced similar problem?

Reply to this Message

Serge Rielau - 02 Mar 2006 12:50 GMT

> Hi all,
>
[quoted text clipped - 4 lines]
>
> Has anyone experienced similar problem?

Compare the db2exfmt output for both cases. It should show the
difference (e.g. did a DB CFG change)?

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

ShengTC@gmail.com - 03 Mar 2006 22:44 GMT

Hi Serge,

Actually, we did compared access paths, that is how we noticed some SQL
performed table scan after the DB was converted to 64 bit, while the
same queries performed index scan in 32 bit environment.

Also, no DB cfg was change.

Reply to this Message