Page 1 of 1

refresh of the code from Production into the Project

Posted: Wed Mar 23, 2011 8:46 am
by mail2krishna79
Hi,
I need to do refresh of the code from production into development project and recompile.
since I am working on this first time, can you please help me how to do this?
I appreciated your help

Thank
Hk

Posted: Wed Mar 23, 2011 9:05 am
by PaulVL
A) If you have a DataStage Administration team, contact them.
B) use IS Manager client to export all jobs (see below) into an ISX file.
C) Be very very careful in overlaying without prompt into your DEV project.
D) I recommend making a new project in DEV (but that's just me being paranoid)
E) Use IS Manager tool to load the ISX file into DEV.

I would NOT load all dependent items into DEV.
Just the jobs, routines, parameter sets, etc...

Table definitions are a "maybe" since you'll most likely not point to your PROD databases from DEV.

remember that PROD parameters are not the same as the ones you would use in DEV.

Posted: Wed Mar 23, 2011 9:41 am
by mail2krishna79
Thank you so much for your answer Paul. This post is very useful for me
Do you want me to export isx file without executables using IS Manager?.

Posted: Wed Mar 23, 2011 9:46 am
by mail2krishna79
One more question.
While importing code from production, if the jobs are running in production so is there any impact on running jobs?

Posted: Wed Mar 23, 2011 10:09 am
by GJ_Stage
There will not be any problem. Because Jobs are already exported from Production and now importing to DEV. But jobs are running in Production.

Posted: Thu Mar 24, 2011 12:46 pm
by mail2krishna79
Here one more question

In Options Include Items are checked by default.
Can you please tell me do i need to keep it as it is or uncheck these below items.

1) Include Source Code with Routines
2) Include Source with Job Executables
3) Include Source Content with data quality specifications

All above items are by default selected (checked)

Posted: Thu Mar 24, 2011 1:16 pm
by PaulVL
I don't think you need the executable since you will be recompiling anyways.

won't hurt, it will just make your isx file a bit bigger.

if you have questions on if you should export this or that... export them both into 2 different files. no harm in that.

apply one to your environment, if you find stuff missing., try the other.

It's DEV. You'll be recompiling, you be referencing different sources and destinations to test.


Might want to double check any Quality Stage stuff to make sure it makes it over.

Posted: Thu Mar 24, 2011 2:24 pm
by mail2krishna79
Paul,
Thank you so much for your reply. your solutions are worked great.

I really appreciated your help.

Thanks
hk