By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,007 Members | 1,237 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,007 IT Pros & Developers. It's quick & easy.

DB2 8.2 32bit to 64 bit conversion

P: n/a
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?

Mar 2 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Sh*****@gmail.com wrote:
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?

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

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Mar 2 '06 #2

P: n/a
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.

Mar 3 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.