Migrating jobs from v 7.5.1 to IIS v8.1
Moderators: chulett, rschirm, roy
Migrating jobs from v 7.5.1 to IIS v8.1
Right now we are using datastage 7.5.1, we are planning to get the new version
IISv8.1 . Has any one migrated their jobs from 7.5.1 to IIS v8.1.
Can you please let me know what are the things to be taken care of for this migration.
If you have faced any problems migrating what where they?
Thanks
sheema
IISv8.1 . Has any one migrated their jobs from 7.5.1 to IIS v8.1.
Can you please let me know what are the things to be taken care of for this migration.
If you have faced any problems migrating what where they?
Thanks
sheema
Last edited by sheema on Wed Feb 11, 2009 2:26 pm, edited 1 time in total.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
When someone says "installed" I assume that that includes setting up and testing database connectivity (perhaps even installing, configuring and testing database client software on the new DataStage server if applicable), because there would be no point in proceeding unless this had been done.
There are some components that don't get exported, such as hashed files (if you have server jobs that use these), scripts and message handlers. You need to "make arrangements" to have these moved.
There are some components that don't get exported, such as hashed files (if you have server jobs that use these), scripts and message handlers. You need to "make arrangements" to have these moved.
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: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
The only problem I've had is that it takes 3-30 days to install 8.1. 3 days if you have experts helping you or you have carried out every prerequisite and nothing goes wrong. 30 days if you don't have any experts and something goes wrong. I think it's worth paying for IBM to come in and install.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Installing Version 8.1 is easier than installing Version 8.0.1 as V 8.0.1 has 13 patches. As you are migrating from 7.5.1 to 8.1, the process would be easy. Installing the server would take couple of hours and configuring the installation would consume more time, I suggest you go through the guide provided with the application which would help you a lot.
If you have admin access to the tool of both versions, then go to environment in project properties and make sure you define same in 8.1 as 7.5 under User Defined Environment variables with little changes to the paths mentioned.
Datastage Export/Import would take care of parameters defined.
Sql statements does not work exactly as of 7.5 in 8.1 when you join tables of Oracle database with higher version Oracle client connector. Works fine when I tried using Toad or Sql Plus but not in the stage.
Make sure Sql statements work in 8.1 from 7.5 once you are good with connectivity with database.
If you have admin access to the tool of both versions, then go to environment in project properties and make sure you define same in 8.1 as 7.5 under User Defined Environment variables with little changes to the paths mentioned.
Datastage Export/Import would take care of parameters defined.
Sql statements does not work exactly as of 7.5 in 8.1 when you join tables of Oracle database with higher version Oracle client connector. Works fine when I tried using Toad or Sql Plus but not in the stage.
Make sure Sql statements work in 8.1 from 7.5 once you are good with connectivity with database.
Could you expand on this, please?mekrreddy wrote:Sql statements does not work exactly as of 7.5 in 8.1 when you join tables of Oracle database with higher version Oracle client connector. Works fine when I tried using Toad or Sql Plus but not in the stage.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
I had the opportunity to install 8.0 before it became 8.0.1. That took three months to work out all the bugs in the installation process. I didn't have an IBM person on site but he had a remote connection to the server and between us we finally got it configured and working. In fairness, it wan't a DataStage issue but IIS install/configure issue on Windows 2003 with the new IIS infrastructure and webSphere overhead. We ended up uninstalling it (it was installed solely for review) and rebuilding the server.ray.wurlod wrote:Even one of the IBM experts needed more than ten attempts to upgrade from 8.0.1 to 8.1. Wild horses could not extract that expert's name from me.
Just last week I had time to install the latest 8.0.1. I was told that, even though it was still 8.0.1, the install process had been significantly revamped from earlier releases of 8.0.1. I was able to get it installed and configured very easily compared to the prior experience. I haven't done a lot of testing but have been successful building, compiling, and excuting jobs as well as importing from 7.5.
Planning to upgrade this server to 8.1 when I can get my hands on it.
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
DSParams file to be copied from 7x to 8.1 ????
sheema wrote: Did you copy the Configuration file and the parameters file too.
How did you do that.
mekrreddy wrote: Datastage Export/Import would take care of parameters defined.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>