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

db2rbind after runstats?

P: n/a

Is it still necessary to do perform a bind after runstats in DB2 9?

e.g.

runstats
reorg
runstats
db2rbind

Jun 27 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Patrick Finnegan wrote:
Is it still necessary to do perform a bind after runstats in DB2 9?
runstats
reorg
runstats
db2rbind
The whole idea of static SQL is that it does not change plans on you
unless you want it to. So I wouldn't call it necessary. But required IF
you want to pick up the new stats.

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Jun 27 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.