IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

After adding Index - Need to compile or rebind


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
deen

New User


Joined: 20 Aug 2003
Posts: 3

PostPosted: Wed Aug 20, 2003 7:45 pm
Reply with quote

I'm using DB2 on mainframe (os390) with cobol & cics. If i add new index, do i need to compile or just rebind the existing programs.


Plz help me .... icon_cry.gif
Back to top
View user's profile Send private message
happyraman1

New User


Joined: 20 Aug 2003
Posts: 2

PostPosted: Wed Aug 20, 2003 10:23 pm
Reply with quote

I think rebinding would do as it is where optimzation occurs
Back to top
View user's profile Send private message
kiran

New User


Joined: 08 Apr 2004
Posts: 25
Location: hyd

PostPosted: Thu Apr 15, 2004 12:37 pm
Reply with quote

deen wrote:
I'm using DB2 on mainframe (os390) with cobol & cics. If i add new index, do i need to compile or just rebind the existing programs.


Plz help me .... icon_cry.gif


I think u've to precomile once again. because u r adding a new index. If the index column is not used in any SELECT for a given program, you'd bind it to get the proper access path.
Back to top
View user's profile Send private message
anuradha

Active User


Joined: 06 Jan 2004
Posts: 247
Location: Hyderabad

PostPosted: Fri Apr 16, 2004 4:08 pm
Reply with quote

Hello kiran,

If new index is added we dont need to precompile again.As happyraman1 said Rebind is enough.It will get the data from catalog (which already got when bind is done).

Rebind is used when the program has not changed,but authorizations have been changed,or new index have been created etc.

Hope you got it.

Thanks
Anu
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Adding a header when change data DFSORT/ICETOOL 6
No new posts REXX - Adding variables CLIST & REXX 8
No new posts Rebind issue - Package DB2 2
No new posts JCL for pl1 db2 precompile, compile a... JCL & VSAM 4
No new posts Add column to existing records using ... JCL & VSAM 2
Search our Forums:

Back to Top