I am trying to replicate production environment to a test environment.
All jobs have parameters set in properties, which include
database name/password and bunch of directories.
In prod environment the database is myProdDb and in test is myTestDb
I want to change all the parameters for all jobs that have been imported in test environment to reflect this change. Is there any way other than making the change manually?
Second question -- how can we keep two jobs in different environment synch'ed ?
thanks in advance
Happy new year to everyone :D
regards
Praveen
keeping two datastage environments in sync
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 9
- Joined: Mon Sep 25, 2006 12:54 pm
- Location: US
-
- Charter Member
- Posts: 9
- Joined: Mon Sep 25, 2006 12:54 pm
- Location: US
parameter setup
"1) Set the parameters in the profile of your different user and nourish them by operationsystemparameters, so you never have to edit anywhere within DataStage.
(2) Use Version management. "
Wolfgang,
thanks for your reply.
We do not have version management, and I am not sure how much it costs and if I will be able to get it.
The unix environment has .profile that contains the parameters, but each job has a bunch of parameters with default value column containing the local setup. I did not understand what you meant by " nourish them by operationsystemparameters." Do I need to remove all the paramers in the job ? How will job know to look in unix environment for default values
Regards
Praveen
(2) Use Version management. "
Wolfgang,
thanks for your reply.
We do not have version management, and I am not sure how much it costs and if I will be able to get it.
The unix environment has .profile that contains the parameters, but each job has a bunch of parameters with default value column containing the local setup. I did not understand what you meant by " nourish them by operationsystemparameters." Do I need to remove all the paramers in the job ? How will job know to look in unix environment for default values
Regards
Praveen
Praveen
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Version Control is free, and is on your DataStage clients CD. Be warned, however, that there is no Version Control in version 8.0; it will be replaced (in version 8.2?) with "something more closely integrated with source control tools such as ClearCase".
There are third party tools such as Parameter Manager for DataStage or Kim Duke's Parameter Navigator with DWNav available. Visit the sister site Tools4DataStage to get more information.
There are third party tools such as Parameter Manager for DataStage or Kim Duke's Parameter Navigator with DWNav available. Visit the sister site Tools4DataStage to get more information.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Export the entire PROD Project to a single dsx, open the dsx in some editor and do a global search and replace of MyProdDb with MytestDb, save and exit. Import the project to test and done. It's a hack and points to very poor design of your environment(s) but it will work. One primary use of parameters is so that one doesn't have to do this hack.