Table REORG and bind the programs.
-
- New Member
- Posts: 3
- Joined: Wed Dec 23, 2015 4:44 pm
Table REORG and bind the programs.
Hi,
Whenever we do a table REORG, do we need to bind one and all the programs related to table? If no, why it is not needed. While for a program change we always do it.
Whenever we do a table REORG, do we need to bind one and all the programs related to table? If no, why it is not needed. While for a program change we always do it.
- Akatsukami
- Global Moderator
- Posts: 122
- Joined: Tue Oct 20, 2015 3:20 am
- Location: Bloomington, IL
- Contact:
Re: Table REORG and bind the programs.
Although DB2 is not my area of greatest expertise, I believe that your process would be REORG, RUNSTATS (to establish new access paths to the reorganized data), and (RE)BIND (to allow use of those new access paths).
"I come to the conclusion that, men loving according to their own will and fearing according to that of the prince, a wise prince should establish himself on that which is in his own control and not in that of others." -- Niccolò Machiavelli
-
- New Member
- Posts: 3
- Joined: Wed Dec 23, 2015 4:44 pm
Re: Table REORG and bind the programs.
Thanks for the reply but it did not answer the question, whenever we do a table REORG, do we need to bind one and all the programs related to table? Can you please help me with that anwer too?
- Anuj Dhawan
- Founder
- Posts: 2805
- Joined: Sun Apr 21, 2013 7:40 pm
- Location: Mumbai, India
- Contact:
Re: Table REORG and bind the programs.
The short answer is No, DB2 does not mandate that.whenever we do a table REORG, do we need to bind one and all the programs related to table? Can you please help me with that anwer too?
The longer answer depends on the mind set of the shop. Two types of thoughts work on REBINDing DB2 plans and packages. In first case, one would recommend to REBIND regularly after running RUNSTATS, which of course you'll do after the REORG. If you don't do it, your programs and applications does not stop working but chances are that without REBIND, static SQLs are failing to get the best out of DB2 sub-system for the best performance.
In the second case, they recommend not to REBIND until it is giving you problems. This way, you will run REORG/RUNSTATS but you will not REBIND your plans and packages until performance is a question.
So you are left with the choice to abide by what your shop's approach is.
Thanks,
Anuj
Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
Anuj
Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
-
- New Member
- Posts: 3
- Joined: Wed Dec 23, 2015 4:44 pm
- Anuj Dhawan
- Founder
- Posts: 2805
- Joined: Sun Apr 21, 2013 7:40 pm
- Location: Mumbai, India
- Contact:
Re: Table REORG and bind the programs.
You're Welcome!
Thanks,
Anuj
Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
Anuj
Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute