Page 1 of 1
source system upgrade ( impact analysis )
Posted: Thu Jun 05, 2008 12:21 am
by 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
Re: source system upgrade ( impact analysis )
Posted: Thu Jun 05, 2008 12:34 am
by 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.
Posted: Thu Jun 05, 2008 6:12 am
by 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.
Posted: Thu Jun 05, 2008 9:30 pm
by kduke
You also need to know what views changed.
Re: source system upgrade ( impact analysis )
Posted: Thu Jun 05, 2008 11:59 pm
by 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
sreddy wrote: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
Re: source system upgrade ( impact analysis )
Posted: Fri Jun 06, 2008 12:56 am
by 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
Re: source system upgrade ( impact analysis )
Posted: Fri Jun 06, 2008 4:51 pm
by 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
----------------------------------------------------------------------------------
syeed wrote: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
Impact Analysis
Posted: Sun Jun 08, 2008 1:25 pm
by 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
chulett wrote: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. ...
Posted: Sun Jun 08, 2008 3:00 pm
by 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.
impact analysis
Posted: Mon Jun 09, 2008 10:59 am
by 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
chulett wrote: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. ...
impact analysis
Posted: Mon Jun 09, 2008 6:42 pm
by 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
chulett wrote: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. ...