refresh of the code from Production into the Project

mail2krishna79 · Post by **mail2krishna79** » Wed Mar 23, 2011 8:46 am

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

PaulVL · Post by **PaulVL** » Wed Mar 23, 2011 9:05 am

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.

mail2krishna79 · Post by **mail2krishna79** » Wed Mar 23, 2011 9:41 am

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?.

mail2krishna79 · Post by **mail2krishna79** » Wed Mar 23, 2011 9:46 am

One more question.
While importing code from production, if the jobs are running in production so is there any impact on running jobs?

GJ_Stage · Post by **GJ_Stage** » Wed Mar 23, 2011 10:09 am

There will not be any problem. Because Jobs are already exported from Production and now importing to DEV. But jobs are running in Production.

mail2krishna79 · Post by **mail2krishna79** » Thu Mar 24, 2011 12:46 pm

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)

PaulVL · Post by **PaulVL** » Thu Mar 24, 2011 1:16 pm

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.

mail2krishna79 · Post by **mail2krishna79** » Thu Mar 24, 2011 2:24 pm

Paul,
Thank you so much for your reply. your solutions are worked great.

I really appreciated your help.

Thanks
hk