Datastage upgrade

vij · Post by **vij** » Tue Aug 05, 2008 7:19 am

Hi,

We are upgrading the Datastage server to new version from 7.5.1. for this process, we export/import every job in to dsx files from the old server to the new one.

Is there any easiest way of doing this export/import? may be like export/import of all the jobs at one shot at the project level?

Thanks in advance,
Vij

chulett · Post by **chulett** » Tue Aug 05, 2008 7:40 am

What new version, exactly? And is the server changing as well? That will affect the answer.

vij · Post by **vij** » Wed Aug 06, 2008 7:11 am

Hi chulett ,

here is the heads up:

Actually we use Datastage 7.5.1 and we wanted to upgrade the DB2 to version 9.01 from version 8.0. As the exsisting datastage version won't support the new version of DB2, we are upgrading the datastage with some patches, so that it can support the new DB version.

with regard to this, is there any easiest way of export/import of datastage jobs apart from doing a manual export of every job from the old datastage server and import of the exported code to the new datastage server?

chulett · Post by **chulett** » Wed Aug 06, 2008 7:46 am

Ok, confusing. You still haven't stated upgrading from 7.5.1 to what? And what "new datastage server" are you talking about - are you building a completely new box for this upgrade to be installed on?

vij · Post by **vij** » Wed Aug 06, 2008 7:54 am

yes, we are going to have a new Datastage box to support the upgrade of DB

chulett · Post by **chulett** » Wed Aug 06, 2008 8:05 am

It would be much simpler if you just "upgrade in place". For a new server - yes, you will need to export and import all projects. That and transfer all existing data/hashed/etc files you'll need to persist.

chulett · Post by **chulett** » Wed Aug 06, 2008 8:06 am

ps. You don't export/import individual jobs but rather one export of the entire project, one per project you want to migrate.