db2rbind after runstats?

[Patrick Finnegan]

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

e.g.

runstats
reorg
runstats
db2rbind

[Serge Rielau]

Re: db2rbind after runstats?

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