source system upgrade ( impact analysis )

[sreddy]

Hi All


We have two different source systems, one of the source system is upgraded. Due to that some views are changed.

Now I am doing impact analysis on existing jobs. We have over 1000 server jobs. Now I am doing manually each category wise.

Any one provides me script that may help me a lot.


Thanks
SReddy

[Govindarajan]

Generate HTML report from your project (7.5.1 onwards) and search for the VIEW Name. You will be hitting the job name here and it would help you do the impact analysis.

[chulett]

Have you tried the Usage Analysis tool in the Manager? It can show you every job that uses a certain bit of metadata, such as the metadata for your source views.

[kduke]

You also need to know what views changed.

[sreddy]

Thanks


Now i am using very recent production .dsx file. Buy using Edit Plus
I am searching each job using View names what they are given.

Any one have related experience in your projects.



Thanks
SReddy

Hi All


We have two different source systems, one of the source system is upgraded. Due to that some views are changed.

Now I am doing impact analysis on existing jobs. We have over 1000 server jobs. Now I am doing manually each category wise.

Any one provides me script that may help me a lot.


Thanks
SReddy

[syeed]

Hi Reddy,

I have developed a PERL script which will surely help you in your process, please mail me on my mail ID wasesoft@gmail.com, so that i can send you the PERL utility over mail.

Thanks,
Waseem

[sreddy]

Thanks SYeed

:D Good to hear from yours. definitely i can mail to you.

Waiting for your valuable reply with "PERL" script.



Thanks
SReddy
dwpractices@gmail.com

----------------------------------------------------------------------------------

Hi Reddy,

I have developed a PERL script which will surely help you in your process, please mail me on my mail ID wasesoft@gmail.com, so that i can send you the PERL utility over mail.

Thanks,
Waseem

[sreddy]

Thanks for your valuable reply. I am following Usage Analysis.
Here i select the job just press the Usage Analysis Icon.
I found Relationship Type Category Name Source
related jobs and sequence jobs.

Out of these entire how can i check the jobs impacted with my view.


Can you send me briefly?


Thanks
SReddy

Have you tried the Usage Analysis tool in the Manager? It can show you every job that uses a certain bit of metadata, such as the metadata for your source views. ...

[chulett]

You would have had to have imported the metadata for the View and used it in your jobs. Then a Usage Analysis on it would show you all of the jobs that you've used it in.

[sreddy]

Thanks


You mean import the metadata first and then start the development right.
If i started new development, i have to do design mapping document.
Then starting development.


Thanks
sreddy

You would have had to have imported the metadata for the View and used it in your jobs. Then a Usage Analysis on it would show you all of the jobs that you've used it in. ...

[sreddy]

Thanks

You are right, but in our project they are not maintain metadata correctly.
That is why i am checking with query that may fetch Jobname & Category.
After that i had take job report checking impacted target tables.

SELECT NAME FMT '40L', CATEGORY FMT '40L' FROM DS_JOBS WHERE JOBNO IN (SELECT OBJIDNO FROM DS_JOBOBJECTS WHERE EVAL

Thanks
SReddy

You would have had to have imported the metadata for the View and used it in your jobs. Then a Usage Analysis on it would show you all of the jobs that you've used it in. ...