Migration to parallel edition

[sankarguru]

Hi,

We are thinking of migrating server jobs to parallel jobs.Can any one help me how to migrate the same?

[naveen19]

Hi,

We are thinking of migrating server jobs to parallel jobs.Can any one help me how to migrate the same?

hi,

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

[ArndW]

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.

[naveen19]

Hi,

We are thinking of migrating server jobs to parallel jobs.Can any one help me how to migrate the same?

hi,

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

[ray.wurlod]

Send wads of money to IBM and they'll do it for you.

[AmeyJoshi14]

Send wads of money to IBM and they'll do it for you. ...

or you can assign it to me.. :D ...i will charge you reasonably..

[sankarguru]

Hi,

We have any tool in px to import the server jobs like we have datastage manager in server edition.

[naveen19]

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

[naveen19]

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

[ArndW]

Yes, the tool is the same; PX is a superset of what the Server edition can do.

[tkbharani]

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.

[sankarguru]

Hi Bharani,

Thanks for the reply. it would be better if you provide any additional information on it.can we migrate entire server job to Px for making changes to the function which is not supported by Px.how we can import the server jibs to parrallel job?

[ray.wurlod]

There is no "one size fits all" answer other than:
1. analyze what the server job does
2. implement that logic in a parallel job