Impact analysis like when a column has been added to a DB2

hariibm · New User Joined: 05 Feb 2007 Posts: 61 Location: Chennai

Hi,
Please provide me with the document or a link which tells about impact analysis like when a column has been added to a DB2 table.. what are all the components will be affected etc.

Thanks,
hari.

mkk157 · Active User Joined: 17 May 2006 Posts: 310

Hi Hariibm,

Just visit the link for more information on Impact Analysis....
www.processimpact.com/process_assets/impact_analysis.doc

Karthigaiselvan · New User Joined: 11 Dec 2006 Posts: 35 Location: India

Hi Hari,

1.You will have to check if you have any full download jobs from that table. You may need to increase the record length of the downloaded file.
2.Check if there are any jobs / programs using this table with SELECT * query. This will get impacted.
3.If any of your jobs / programs using this table dont use SELECT * way, then you will not have any impact.

Craq Giegerich · Posted: Thu Jul 05, 2007 5:25 am

hariibm · New User Joined: 05 Feb 2007 Posts: 61 Location: Chennai

thanks for all your inputs/responses. But I need a generic impact analysis document where I can see what are all the components will be effected if something changes. Not only adding a column to the table.

I hope this is clear and please let me know if you need mroe information.

Thanks,
Hari

Devzee · Posted: Thu Jul 05, 2007 12:07 pm

There are many 3rd party tools available to do the impact analysis. Generates various kinds of impact analysis report.
Have you tried?