Datastage Dev and Production Projects in Same Environment

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
synsog
Premium Member
Premium Member
Posts: 232
Joined: Sun Aug 01, 2010 11:01 pm
Location: Pune

Datastage Dev and Production Projects in Same Environment

Post by synsog »

Hi All,

V8.7 on Windows with Engine Tier on one Server and Services/Metadata Tier on another.

We will have a Datastage project say PRDEV on this Env and on this same box (Environment) have another project called PRPROD..So basically both Dev and Production projects will reside on the same box..I understand the operational risks of having both on the same box but from a Datastage Perspective

1. Can this be realistically done?
2. Migrating jobs from PRDEV To PRPROD can still be done through Information Server Manager?
3. Generally when we migrate the jobs from DEV to PROD env, the Project Names are always same but in this case it will not be, will this be an issue?
4. What issues we could run into?

Any information on this will be very helpful.
Thanks and appreciate your responses.
jwiles
Premium Member
Premium Member
Posts: 1274
Joined: Sun Nov 14, 2004 8:50 pm
Contact:

Post by jwiles »

1) Yes, it can be done. From a DS perspective, it's just another project
2) Yes.
3) That will depend upon your process design...is the project name used within the jobs and other objects in the project?
4) Some Potential Issues:
a - Developers editing/compiling/testing jobs will compete for resources with Production jobs on the same engine
b - Data storage conflicts--care must be taken to separate production storage from non-production storage, and to point to the correct storage in each project. Otherwise you risk mixing production and non-production data. With privacy and security laws such as they are today, this could be a large risk for your client depending upon their industry and location.
c - One environment = every thing down if the server (engine or services/metadata) fails.

Regards,
- james wiles


All generalizations are false, including this one - Mark Twain.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Just wanted to make a comment on #3.

Generally when we migrate the jobs from DEV to PROD env, the Project Names are always same but in this case it will not be, will this be an issue?

I've never worked for a client where the projects all had the exact same name across the environments, the environment was part of the name. And as noted, it's not an issue at all... actually more of a safety net IMHO.
-craig

"You can never have too many knives" -- Logan Nine Fingers
synsog
Premium Member
Premium Member
Posts: 232
Joined: Sun Aug 01, 2010 11:01 pm
Location: Pune

Post by synsog »

Thank You both for your help. This is very helpful
Post Reply