Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Explain me the concept of rebind in DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
seema_vidya

New User


Joined: 24 Jun 2005
Posts: 5

PostPosted: Fri Jun 24, 2005 11:52 am    Post subject: Explain me the concept of rebind in DB2
Reply with quote

Can anyone explain me the concept of rebind in DB2 as i have not worked on db2 till now. If explained with an example i will be greatfull to you all.
Back to top
View user's profile Send private message

brganeshbabu

New User


Joined: 23 Jun 2005
Posts: 34
Location: Chennai

PostPosted: Tue Jun 28, 2005 1:09 pm    Post subject:
Reply with quote

You know why Bind is done. If at all u don't know I will explain it. Bind is done to create a plan and package from the DBRM. The plan and package will contain the access path of the query you have given and the possible ways the query can be executed. Out of which the system will identify the efficient one. These details of the table are obtained from the RUNSTATS utility.
Consider this scenario, suppose you have bind a sql yesterday. You have an index for that table. Say, DB2 is going to execute that query you have given, through that index. Today you or someone who has authority deletes that index. When u execute the query tomorrow it will not take the plan that has already created. DB2 automatically rebinds during the execution of the query, since the index is marked incorrect. This is the scenario where you can find rebind.
I think I have explained your doubt.
Back to top
View user's profile Send private message
mdtendulkar

Active User


Joined: 29 Jul 2003
Posts: 238
Location: USA

PostPosted: Wed Jun 29, 2005 4:30 am    Post subject:
Reply with quote

seema_vidya,

Following links is a series of explanation for BIND, Plan, Packages in DB2

Part 1

Part 2

Part 3

Hope this helps

Regards
Mayuresh
Back to top
View user's profile Send private message
bimalpattanayak

New User


Joined: 08 Apr 2005
Posts: 3

PostPosted: Thu Jun 30, 2005 2:28 pm    Post subject:
Reply with quote

dbrm passed thru bind program ikjeft01 is converted to package which is the compiled form of dbrm.again we pass the package thru bind program
which gives plan which is the executable format of dbrm that is equivalent to link editing.dbrm is just like the source code of sql statements.
Back to top
View user's profile Send private message
brganeshbabu

New User


Joined: 23 Jun 2005
Posts: 34
Location: Chennai

PostPosted: Thu Jun 30, 2005 3:44 pm    Post subject:
Reply with quote

Hi mtendulkar,
This link is really nice. I think vidya, u can very well understand the concepts of bind.
Back to top
View user's profile Send private message
partha

New User


Joined: 05 May 2005
Posts: 2

PostPosted: Fri Jul 01, 2005 4:46 pm    Post subject:
Reply with quote

Hi
Packages should be rebound when any of the following are true, based on current statistics from the catalog:
Changes greater then 20% (NLEAF, NPAGES, NACTIVE) Cluster ratio less then 80% NLEVELS increases greater then 2 HIGH2KEY and LOW@KEY ranges change greater then 10% Cardinality and ROW Count change greater then 20%
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Should we Rebind Plan if no SQL changes sappy_mf DB2 2 Thu Mar 03, 2016 2:13 pm
No new posts Can someone explain me this JCL line ... PeterHolland JCL & VSAM 9 Sat Dec 12, 2015 7:22 am
No new posts JCL overriding concept s.saranya srinivasan JCL & VSAM 14 Wed Oct 07, 2015 4:07 pm
No new posts Rebind package not working as intended Abhinav Chandra DB2 10 Tue Oct 01, 2013 7:24 pm
No new posts Is Rebind required for dynamic SQL Co... Furor DB2 1 Thu Sep 19, 2013 9:35 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us