Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

After adding Index - Need to compile or rebind

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: After adding Index - Need to compile or rebind
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    Post subject: I think u can rebind
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    Post subject: Re: DB2 .... Add new index
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    Post subject: rebind for addition in index
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    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 OO COBOL compile error Virendra Shambharkar COBOL Programming 3 Tue Jan 10, 2017 6:05 pm
No new posts Order BY AND Index Nileshkul DB2 2 Sat Dec 31, 2016 6:33 pm
No new posts I can not compile my program PL1 V3.R... Miguel Fernandez PL/I & Assembler 13 Tue Dec 06, 2016 8:30 pm
No new posts COBOL 5 Compile oerdgie COBOL Programming 3 Thu Oct 06, 2016 6:14 pm
No new posts Adding records from two files into on... shiitiizz SYNCSORT 4 Mon Sep 19, 2016 8:41 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us