MVSFORUMS.com

lacoe1 · Beginner Joined: 24 Feb 2005 Posts: 33 Topics: 17

If I add a column to the Index of a DB2 table, do I have to recompile and bind the application program accessing the table even if there are no changes to the program.

kolusu · Posted: Thu Nov 09, 2006 1:59 pm Post subject:

lacoe1,

yes you need to recompile and bind the application program so that it picks up the new access paths as the index has been changed

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

lacoe1 · Beginner Joined: 24 Feb 2005 Posts: 33 Topics: 17

Just curious: What error will I get if I donot recompile?

kolusu · Posted: Thu Nov 09, 2006 2:14 pm Post subject:

lacoe1,

You will not get an error. It is just the pgms will not be able to use the new index and old access paths will no longer be valid and your pgm performance will go down.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

lacoe1 · Beginner Joined: 24 Feb 2005 Posts: 33 Topics: 17

Thanks Kolusu!
But another, question:
If I have data that is sorted on 6 fields (4 ascending, 2 descending), and the table that I want this data to get loaded into has 4 fields (same as the 4 ascending fields in the sorted data) as the index. Will the data get loaded exactly as
it is sorted in the file or will the index affect it ?

bauer · Posted: Fri Nov 10, 2006 2:21 am Post subject:

kolusu,

I don't agree with your answer. I would say, if an column is added to an index it is only necessary to do an rebind of the packages / plans of the programs, which may use the index, recompile is not necessary.

Why do you say, recompile is necessary?

bauer

videlord · Beginner Joined: 09 Dec 2004 Posts: 147 Topics: 19

I think rebind is enough
no need to recompile the program

for the LOAD utility, the data will be loaded the same sequence as the input file

kolusu · Posted: Fri Nov 10, 2006 12:20 pm Post subject: