Migration to parallel edition
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 6
- Joined: Thu Aug 07, 2008 12:49 am
- Location: Chennai
Migration to parallel edition
Hi,
We are thinking of migrating server jobs to parallel jobs.Can any one help me how to migrate the same?
We are thinking of migrating server jobs to parallel jobs.Can any one help me how to migrate the same?
Re: Migration to parallel edition
hi,sankarguru wrote:Hi,
We are thinking of migrating server jobs to parallel jobs.Can any one help me how to migrate the same?
You have first know the function(date,MTS function how it will work in Px when its migrated to px) so for intially you have to sample jobs in px toget the same output as server then you can start the job so that it will help full to do so and that consider best practice..
Regards
Naveen.K
Migration from a Server environment to a PX Environment is simple and almost automatic, as the PX product also includes the Server components.
The difficulty lies in changing those Server jobs to PX Jobs; this step is not automated and requires a lot of work to do correctly.
The difficulty lies in changing those Server jobs to PX Jobs; this step is not automated and requires a lot of work to do correctly.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Re: Migration to parallel edition
hi,sankarguru wrote:Hi,
We are thinking of migrating server jobs to parallel jobs.Can any one help me how to migrate the same?
You have first know the function(date,MTS function how it will work in Px when its migrated to px) so for intially you have to sample jobs in px toget the same output as server then you can start the job so that it will help full to do so and that consider best practice..
Regards
Naveen.K
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 334
- Joined: Fri Dec 01, 2006 5:17 am
- Location: Texas
or you can assign it to me.. :D ...i will charge you reasonably..ray.wurlod wrote:Send wads of money to IBM and they'll do it for you. ...
http://findingjobsindatastage.blogspot.com/
Theory is when you know all and nothing works. Practice is when all works and nobody knows why. In this case we have put together theory and practice: nothing works. and nobody knows why! (Albert Einstein)
Theory is when you know all and nothing works. Practice is when all works and nobody knows why. In this case we have put together theory and practice: nothing works. and nobody knows why! (Albert Einstein)
-
- Participant
- Posts: 6
- Joined: Thu Aug 07, 2008 12:49 am
- Location: Chennai
sankarguru wrote:Hi,
We have any tool in px to import the server jobs like we have datastage manager in server edition.
Hi,
There is tool is there IBM's tool X Migrator which belongs IBM VCS team
But after using the tool also u have to do small cosmetic's work
P.S: IBM will charge your all company wealth for using that tool :D
sankarguru wrote:Hi,
We have any tool in px to import the server jobs like we have datastage manager in server edition.
Hi,
There is tool is there IBM's tool X Migrator which belongs IBM VCS team
But after using the tool also u have to do small cosmetic's work
P.S: IBM will charge your all company wealth for using that tool :D
Yes, the tool is the same; PX is a superset of what the Server edition can do.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
First analyze following things...which tool can't do
--------------------------------------------------------
1. Number of jobs to be migrated
2. Sequencer's need not be touched; they will work same as in server. Only few changes are to be done for the sequencers.
3. Number of jobs where HASH file is being used; redesign jobs rather than migrating.
4. Number of jobs using fixed width files, handling fixed width file is different in PX.
5. In server NULL handling is optional, but in PX it is rigid. More work to be done.
6. ORA BULK stage to be taken care.
7. DataType handling and NULL handling should be done manually.
8. System variables, ICONV, OCONV etc should be taken care.
9. All basic coding to be re-coded in C++ language.
In case the above features are very less then start doing it by user self by redesigning the job. Tool will only replace server stages by parallel stages.
--------------------------------------------------------
1. Number of jobs to be migrated
2. Sequencer's need not be touched; they will work same as in server. Only few changes are to be done for the sequencers.
3. Number of jobs where HASH file is being used; redesign jobs rather than migrating.
4. Number of jobs using fixed width files, handling fixed width file is different in PX.
5. In server NULL handling is optional, but in PX it is rigid. More work to be done.
6. ORA BULK stage to be taken care.
7. DataType handling and NULL handling should be done manually.
8. System variables, ICONV, OCONV etc should be taken care.
9. All basic coding to be re-coded in C++ language.
In case the above features are very less then start doing it by user self by redesigning the job. Tool will only replace server stages by parallel stages.
Thanks, BK
-
- Participant
- Posts: 6
- Joined: Thu Aug 07, 2008 12:49 am
- Location: Chennai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: