|
View previous topic :: View next topic
|
| 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 |
|
 |
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: 25
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 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 |
|
|
anuradha
Active User
Joined: 06 Jan 2004
Posts: 247
Location: Hyderabad
|
|
|
|
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 |
|
|
|
|
