Page 1 of 1
replacing DB2 enterprise stage with teradata enterprise stag
Posted: Sat Sep 20, 2008 9:50 pm
by ramesh_inform
Hi
Iam involved in a mogration project where we are migrating from DB2 platform to Teradata platform.
So there are several jobs where the target stage is DB2 and they need to be changed to Teradata.
Is there any way that we can take export of job which contains DB2 stage and change the script to make it change to teradata.
I tried changing the DSX and i could add only teradata parameters to the job which were not present before.
Or else is there any way automise the jobs ?
Posted: Sun Sep 21, 2008 1:03 am
by ray.wurlod
No.
Posted: Sun Sep 21, 2008 11:09 pm
by John Smith
From experience it takes prob less then 2 minutes to replace the db2 stage with a teradata stage and recompile , how many jobs do you have?
Posted: Mon Sep 22, 2008 1:47 am
by ramesh_inform
around 1500 jobs..........
anyways i dont think changing the dsx will be the feasible solution.
It is not possible. i've tried many ways but unsuccessful.
Posted: Mon Sep 22, 2008 1:58 am
by ray.wurlod
Well, according to John's figures you should be able to finish the whole lot in about 3000 minutes.
Posted: Mon Sep 22, 2008 2:28 am
by hamzaqk
you can write your own ultility which can do this for you. thats what has been done in the project i am working on right now. :D
Posted: Mon Sep 22, 2008 3:45 am
by ray.wurlod
Perhaps you could outsource the work to hamzaqk's organization?
(I was going to use the term "offshore" until I realized that there is no sea between India and Pakistan!)
Posted: Mon Sep 22, 2008 10:29 pm
by ramesh_inform
hamzaqk
Could u please give me some idea on how to proceed?
Posted: Tue Sep 23, 2008 12:58 am
by ray.wurlod
I believe that their organization will contract to do that work using their own intellectual property (if asked nicely, with a purchase order).
Posted: Tue Sep 23, 2008 7:57 am
by chulett
If you had just made the changes manually rather then looking for an 'easier' way, you probably would have been done by now.
Posted: Tue Sep 23, 2008 5:48 pm
by John Smith
The exercise would have been perfect for any new hires/grads looking for work experience. Or even students can do it given the right instructions. Chuck in 10 kids into it and you're done in a day. Pay them minimal wage
Posted: Tue Sep 23, 2008 10:14 pm
by ramesh_inform
thanke every one ...we are doing it manually
