when does REBIND process come in

prabhucs01 · New User Joined: 07 Mar 2005 Posts: 43

when does REBIND process come in

In which situation REBIND scenario occurs

how it is done.

thanks in advance...

ofer71 · Posted: Wed Jan 18, 2006 12:53 am

A general explanation in the manual:

prabs2006 · Active User Joined: 12 Jan 2006 Posts: 103

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

Thanks & Regards
Prabs

futuredba · New User Joined: 08 Jan 2006 Posts: 22 Location: Delhi

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.

jackal · New User Joined: 21 Jan 2006 Posts: 48 Location: india

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

prabs2006 · Active User Joined: 12 Jan 2006 Posts: 103

Hi

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

Thanks & Regards
Prabs

saranya_sn · New User Joined: 03 Jul 2005 Posts: 12 Location: India

If the records are in the correct order and type to load, you can use the file aid option too

kaurav · New User Joined: 19 Oct 2005 Posts: 7

Saranya,

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

TIA
Regards,
Kaushik

saranya_sn · New User Joined: 03 Jul 2005 Posts: 12 Location: India

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