MVSFORUMS.com

manojvoona · Beginner Joined: 05 Jan 2006 Posts: 43 Topics: 14

Hi,

I have a quick question on DB2 program recompilation.
Do we need to recompile all the online and batch DB2 program if a new field is added to the table ? we did not recompile last time when we added a new column at the end of db2 table.

Will it be different if I add in a feild in between instead of at the end.

As always appreciate for all the help

THanks
Manoj Voona

kolusu · Posted: Mon May 04, 2009 3:59 pm Post subject:

manojvoona,

As long as you don't have Select * in your programs even if you are adding the field in the middle.

However if someone is referencing a particular item using reference modification with a select * into a working storage variable, you might run into a problem.

if your program is NOT referring the column then you don't have to anything

Kolusu

manojvoona · Beginner Joined: 05 Jan 2006 Posts: 43 Topics: 14

Thanks Kolusu for confirmation...... for safety do you want us to rebind the plan ?

Thanks
Manoj

kolusu · Posted: Mon May 04, 2009 4:51 pm Post subject:

manojvoona,

Not required unless your data has grown by leaps and bounds and a reorg was done, which would make rebind pick the optimal path once again