467,209 Members | 1,277 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,209 developers. It's quick & easy.

DB2 8.2 32bit to 64 bit conversion

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
  • viewed: 1384
Share:
2 Replies
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
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.

Similar topics

1 post views Thread by Peter Hartmann | last post: by
6 posts views Thread by R.Biloti | last post: by
8 posts views Thread by dwelch91 | last post: by
2 posts views Thread by M O J O | last post: by
1 post views Thread by =?Utf-8?B?RGFuaWVs?= | last post: by
reply views Thread by Paul McNett | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.