Hi !
I am trying to import a project (dsx file size 3.5 GB) in a fresh 8.1 installation and the import is running for last almost 4 days.
It used to take only about 6-8 hours in 7.5
Any ideas ?
Migrating to 8.1 : Project import taking too long
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It was showing progress.
Then we opened a ticket with IBM and this is what they are suggesting. We are working on this and will let you know how it went.
---------------------------
First make sure that you didn't include executables in your export - as all the jobs will need to be re-compiled anyway in 8.1. If these are just your job designs. Here is our technote for resolving this issue:
Abstract - When importing a large number of job designs, the import takes a considerable amount of time to complete.
Resolution:
Changing the VOC file from a static file to a dynamic file speeds up the updating of the VOC. To change the VOC to a dynamic file, do the following steps:
Make sure no DataStage Clients are connected to the project which will have it's VOC changed.
Change directory to the DSEngine directory.
Source the dsenv
$ . ./dsenv
Execute the following:
$ bin/uvsh
> LOGTO <project name>
> CREATE.FILE VOC.NEW DYNAMIC
> COPY FROM VOC TO VOC.NEW ALL
> QUIT
Change directory to the project's directory
Execute the following:
$ mv VOC VOC.orig
$ mv VOC.NEW VOC
7. Confirm that the new VOC file has the same permission's as VOC.orig
The new dynamic VOC is ready for use and you can now proceed with the Large DataStage job import.
----------------------------------------
Then we opened a ticket with IBM and this is what they are suggesting. We are working on this and will let you know how it went.
---------------------------
First make sure that you didn't include executables in your export - as all the jobs will need to be re-compiled anyway in 8.1. If these are just your job designs. Here is our technote for resolving this issue:
Abstract - When importing a large number of job designs, the import takes a considerable amount of time to complete.
Resolution:
Changing the VOC file from a static file to a dynamic file speeds up the updating of the VOC. To change the VOC to a dynamic file, do the following steps:
Make sure no DataStage Clients are connected to the project which will have it's VOC changed.
Change directory to the DSEngine directory.
Source the dsenv
$ . ./dsenv
Execute the following:
$ bin/uvsh
> LOGTO <project name>
> CREATE.FILE VOC.NEW DYNAMIC
> COPY FROM VOC TO VOC.NEW ALL
> QUIT
Change directory to the project's directory
Execute the following:
$ mv VOC VOC.orig
$ mv VOC.NEW VOC
7. Confirm that the new VOC file has the same permission's as VOC.orig
The new dynamic VOC is ready for use and you can now proceed with the Large DataStage job import.
----------------------------------------
vishal
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: