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
 
when does REBIND process come in

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
prabhucs01
Warnings : 1

New User


Joined: 07 Mar 2005
Posts: 43

PostPosted: Tue Jan 17, 2006 6:54 pm    Post subject: when does REBIND process come in
Reply with quote

when does REBIND process come in

In which situation REBIND scenario occurs

how it is done.


thanks in advance...
Back to top
View user's profile Send private message

ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Wed Jan 18, 2006 12:53 am    Post subject:
Reply with quote

A general explanation in the manual:
Quote:
The creation of a new application plan for an application program that has been bound previously. If, for example, you have added an index for a table that your application accesses, you must rebind the application in order to take advantage of that index.


And as always, you can read more about it in the fine manual.

O.
Back to top
View user's profile Send private message
prabs2006

Active User


Joined: 12 Jan 2006
Posts: 103

PostPosted: Fri Jan 20, 2006 11:09 am    Post subject:
Reply with quote

Hi,
Adding further to the above info, rebind is also done whenever Runstats is performed.

Thanks & Regards
Prabs
Back to top
View user's profile Send private message
futuredba

New User


Joined: 08 Jan 2006
Posts: 22
Location: Delhi

PostPosted: Fri Jan 20, 2006 8:10 pm    Post subject:
Reply with quote

Hi,
I would like to add sth to it. REBIND is always done when u think that the access path choosen by the optimizer is not appropiate.
the reason for this can be a better existing path which is not in optimizer's knowledge(coz u have added an index or performed RUnstats utility) or the path is not valid anymore(coz the index has been dropded which the optimizer was using).
in the first case, ur program will work though it isnt using the best avaliable method but in 2nd case u have to rebind it. coz when u bind ur package/plan, it will choose the most efficient method. but it doesnt keep itself updated with the changes done by u after the binding process is over.
Back to top
View user's profile Send private message
jackal
Currently Banned

New User


Joined: 21 Jan 2006
Posts: 48
Location: india

PostPosted: Sat Jan 21, 2006 9:27 am    Post subject: want to insert 1000 records
Reply with quote

i want to insert 1000 records in a table each time i have to give insert query?any alternate method is there?

thanx in advance..
regard..
manjinder
Back to top
View user's profile Send private message
prabs2006

Active User


Joined: 12 Jan 2006
Posts: 103

PostPosted: Mon Jan 23, 2006 9:59 am    Post subject:
Reply with quote

Hi

Put the recs in a flat file and load it using the DB2 load utility

Thanks & Regards
Prabs
Back to top
View user's profile Send private message
saranya_sn

New User


Joined: 03 Jul 2005
Posts: 12
Location: India

PostPosted: Tue Jan 24, 2006 4:57 am    Post subject:
Reply with quote

If the records are in the correct order and type to load, you can use the file aid option too
Back to top
View user's profile Send private message
kaurav

New User


Joined: 19 Oct 2005
Posts: 7

PostPosted: Tue Jan 24, 2006 10:13 am    Post subject: when does REBIND process come in
Reply with quote

Saranya,

Could you pls throw some light on the file aid option?

TIA
Regards,
Kaushik
Back to top
View user's profile Send private message
saranya_sn

New User


Joined: 03 Jul 2005
Posts: 12
Location: India

PostPosted: Tue Jan 24, 2006 10:46 pm    Post subject:
Reply with quote

Select the FileAid for DB2, then
Select Extract and Load Tables, then
Select Load from a dataset to a Table


Give your DB2 table name or the databse/tablespace and give your dataset names.

Hope this helps.

I cannot provide any screen shots since its against company policies.

I apologise.

Regards,
Saranya
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 Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am
No new posts Storing huge volume of data, compare ... Pradeep K M All Other Mainframe Topics 3 Mon Jan 16, 2017 5:08 pm
No new posts Viewing executing process in NDM .. q... Debb.Brant IBM Tools 0 Wed Dec 14, 2016 10:55 pm
No new posts Should we Rebind Plan if no SQL changes sappy_mf DB2 2 Thu Mar 03, 2016 2:13 pm
No new posts How to make REXX process different GDGs? venksiv CLIST & REXX 15 Thu Sep 24, 2015 5:35 pm

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