DB2 table change - How impact analysis can be done?

If any DB2 column changed,how impact analysis can be done fo this?

Questions by clrMFint

Showing Answers 1 - 1 of 1 Answers


  • Sep 20th, 2014

Impact Analysis for DB2 table change:

1.What is changing-If it is column size then find out all the programs using that column in them.ADJUST THE CODE ACCORDINGLY.If working storage value is being populated by that HOST variable(Generated by DCLGEN) then increase their sizes.Also find out all the files related to that column for impact analysis.

2.If any column is being added then how are you going to handle that in all related programs/files.

3.If any column is being deleted then analyze all the programs/logic/files to handle that change.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions