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
 
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 Create procedure issues -628 when add... chandraBE DB2 1 Mon Sep 18, 2017 12:16 pm
No new posts Confusion b/w index and subscript Deepak kumar25 Mainframe Interview Questions 7 Thu Aug 31, 2017 6:50 am
No new posts Adding a userid to SMTP Security table Yolanda Harvey JCL & VSAM 1 Sun Aug 13, 2017 6:16 pm
No new posts SQL - select data available in index Nileshkul DB2 3 Mon Jun 26, 2017 1:30 am
No new posts Adding big TEXT lines to each record ... bshkris SYNCSORT 4 Sat May 06, 2017 1:40 am

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