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

Question on using rebind with auto-runstats/auto-reorg

P: n/a
Running DB2 8.2.5 and version 9 with fixpack2 on AIX 5.3 supporting
both SAP netweaver and non-SAP applications.

In implementing auto-reorg and auto-runstats, what is the guidance
regarding doing a rebind of packages?

I am having difficulty coming across any guidance on this.

Thanks in advance.

Gerry
Nov 28 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Nov 28, 10:41 am, datapro01 <datapr...@yahoo.comwrote:
Running DB2 8.2.5 and version 9 with fixpack2 on AIX 5.3 supporting
both SAP netweaver and non-SAP applications.

In implementing auto-reorg and auto-runstats, what is the guidance
regarding doing a rebind of packages?

I am having difficulty coming across any guidance on this.

Thanks in advance.

Gerry
I can only share my experience with this problem. I'm not sure what
the "official" IBM line is. For our suite of products I have developed
a solution that seems to do the trick performance wise (i.e ensure
that stored procedures run with a correct execution plan). A
scheduled job is run periodically which rebinds stored procedures
which:
1) access tables that are greater than a certain size (so are worth
rebinding) and are not volatile
2) Haven't been rebound since the stats were updated for the table
(don't already have a good plan).

All this information can be obtained from the system catalog (SYSCAT).
Nov 28 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.