Hi,
We are planning to migrate all the datastage jobs and databases from the Solaris server to the new AIX server.
I am the thinking of the following points to be considered for the successful migration of the DS jobs:
1. Import all the jobs into a .dsx file and export that to new server.
2. Migrate the database to the new server.
3. Copying all the UNIX scripts that run the DS jobs from the old server to the new server.
Am i missing anything other than the ones that i have mentioned above?
Please advise.
Sue
Migration of DS from one server to another
Moderators: chulett, rschirm, roy
-
nikhilanshuman
- Participant
- Posts: 58
- Joined: Tue Nov 17, 2009 3:38 am
1 )You need to migrate your all <b>user defined Environment variables as well</b>.These variables are present in <b>dsparam</b> file of datastage home directory(can be seen in datastage administrator).Your jobs will not compile in the new environment if these variables are not setup there.
2) Creation of similar directory structure -> You datastage jobs create files in certain directories.Also,your scripts reside in a directory.You need to create a similar directory structure there as well.It will be good if you create a shell script containing all mkdir <dirname> command followed by chmod command.If this is done,running a shell script will create all directories at once.
3) Creation of project -> You need to create a Datastage project similar to this project in the new machine.
4) Sql scripts for lookup tables : In your current table,there might be some lookup tables from which your job are doing lookup.Create insert statements for all those tables where you think the data might be required in the new machine.
5) Setting up entries in tnsname.ora : You might need to setup your database in the new environment.Check if the entries for databases are there in the tnsnames.ora file.Also,you need to check the DSN settings on the new machine for your databases.
2) Creation of similar directory structure -> You datastage jobs create files in certain directories.Also,your scripts reside in a directory.You need to create a similar directory structure there as well.It will be good if you create a shell script containing all mkdir <dirname> command followed by chmod command.If this is done,running a shell script will create all directories at once.
3) Creation of project -> You need to create a Datastage project similar to this project in the new machine.
4) Sql scripts for lookup tables : In your current table,there might be some lookup tables from which your job are doing lookup.Create insert statements for all those tables where you think the data might be required in the new machine.
5) Setting up entries in tnsname.ora : You might need to setup your database in the new environment.Check if the entries for databases are there in the tnsnames.ora file.Also,you need to check the DSN settings on the new machine for your databases.
Nikhil
