I am using db2 v7.I have a partitioned table which is index controlled.
Now I have to change the limit key values for the all partitions.
I think i have two options.As i dont have any tool which can do directly alter for me and create the required job itself, i am doing it manually !
1.alter the index , run reorg and runstats.
2.Unload the table,Drop.]]Then create the table with changed limit key values.Then load the table.
But i have dependent packages on the tables.so I am preferring for 1st option.But after alteration of index key values, Is it required to bind the package ?Or Rebind ?
Or it is better to go for 2nd option ?Here also I need to bind ?
My concern is about not to loose any Data and Packages.anyone please help.
At most of the shops I have worked with, activities such as ALTER/REBIND/DROP.. are performed/authorized in production only by/to the DBA group. Do you have such a team available? If yes, they should be able to assist depending on the volume of data/other parameters specific to your application.