DB2 V8 Access Path

Antonis Galaios

DB2 V8 Access Path
After a successful migration to DB2 V8 (NFM) to a test environment, we find out that some packages change their access path. Usually from index scan with 0 matching columns to a tablespace scan. The cost in ms and su for these packages increased.

Is there any good ideas what can I do with these package when we will migrate to production?

Áíôùíçò Ãáëáéïò

DB2 DBA for z/OS

IBM Certified Solutions Expert

DB2 UDB V7.1/V8.1 Database Administration

P Think before you print.

This e-mail is confidential. If you are not the intended recipient, you should not copy it, re-transmit it, use it or disclose its contents, but should return it to the sender immediately and delete the copy from your system.
EFG Eurobank Ergasias S.A. is not responsible for, nor endorses, any opinion, recommendation, conclusion, solicitation, offer or agreement or any information contained in this communication.
EFG Eurobank Ergasias S.A. cannot accept any responsibility for the accuracy or completeness of this message as it has been transmitted over a public network. If you suspect that the message may have been intercepted or amended, please call the sender.

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms