| Author |
Message |
deen
New User
Joined: 20 Aug 2003
Posts: 3
|
|
|
|
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 ....  |
|
| Back to top |
|
 |
References
|
 Posted: Wed Aug 20, 2003 7:45 pm Post subject: Re: After adding Index - Need to compile or rebind |
|
|
|
|
happyraman1
New User
Joined: 20 Aug 2003
Posts: 2
|
|
|
|
| I think rebinding would do as it is where optimzation occurs |
|
| Back to top |
|
|
kiran
New User
Joined: 08 Apr 2004
Posts: 26
Location: hyd
|
|
|
|
| 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 .... |
I think u've to precomile once again. because u r adding a new index. if it is wrong pls let me know the correct answer. |
|
| Back to top |
|
|
anuradha
Global Moderator
Joined: 06 Jan 2004
Posts: 257
|
|
|
|
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 |
|
|
|
|
