server and parallel migration
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 97
- Joined: Tue Feb 21, 2006 6:45 am
server and parallel migration
Hi,
I am about to join a company which has newly acquired 7x version. They were currently working on server edition. My tasks will be to work on both parallel. I presume it could be migration as well. Dont mind my basic question. But could u pls shed light at elementary level how the migration process will occur (what about the hash stage, as it is not used in parallel). What could be role of an Admin and ETL developer in this regard.
I am about to join a company which has newly acquired 7x version. They were currently working on server edition. My tasks will be to work on both parallel. I presume it could be migration as well. Dont mind my basic question. But could u pls shed light at elementary level how the migration process will occur (what about the hash stage, as it is not used in parallel). What could be role of an Admin and ETL developer in this regard.
You can't migrate hashed files to PX; you need to redesign the jobs. The same re-design applies to almost all Server jobs in order to take advantage of the parallelism possible in PX.
The migration should be approached assuming the products are quite different, i.e. you will need to do some project planning. Most of the time the re-development time won't be worth migrating. It can cost just as many people-hours to redesign an existing Server job into a PX job as it did to originally design it. Plus you need to go through the whole testing system as well with the new job.
The migration should be approached assuming the products are quite different, i.e. you will need to do some project planning. Most of the time the re-development time won't be worth migrating. It can cost just as many people-hours to redesign an existing Server job into a PX job as it did to originally design it. Plus you need to go through the whole testing system as well with the new job.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 97
- Joined: Tue Feb 21, 2006 6:45 am
So u mean the existing server jobs should be left alone. And the new jobs taken up should be done in parallel.
One small doubt, is it that we just need to open the .dsx files of server jobs in 7x version and compile them (If we dont want to redesign). What about the environmental variable etc. Is it as simple as it sounds, just opening the .dsx files in 7x version or are there anymore precautions for it?
One small doubt, is it that we just need to open the .dsx files of server jobs in 7x version and compile them (If we dont want to redesign). What about the environmental variable etc. Is it as simple as it sounds, just opening the .dsx files in 7x version or are there anymore precautions for it?
The PX install will be an add-on if it is at the same version, so you won't need to do anything with PX jobs.
If you spent $1000 on designing a job that works acceptably, it will take a powerful business case to justify another $1000 in making it into a PX job which does nothing else except to run in half or a third of the time.
If you spent $1000 on designing a job that works acceptably, it will take a powerful business case to justify another $1000 in making it into a PX job which does nothing else except to run in half or a third of the time.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 97
- Joined: Tue Feb 21, 2006 6:45 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Server jobs will be around for the foreseeable future. This was reinforced in (unofficial) discussions with IBM technical person this week. The first question you must ask is whether there's any value in migrating, given that fact. If your server job performs well, and meets your time window, it's not broken, so don't fix it. If it doesn't meet your time window, consider converting it to multi-instance and running two or three instances in parallel.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: