DSXchange

I am restoring from a backup into a new project due to some corruption, and the new project doesn't have the SAP pack installed. Is there a simple way to copy the installed stages from the old project, or do I have to dig out the CDs again?

== Update ==

I have created a package with the components and imported it into the new project. Seems odd that you can create the package in DS Manager, but have to use the AIX command line to import it.

You can export stages from within DataStage Manager (if you can still access the project via that) and import them in the new project.

Or using the cd's of course.

Ogmios

ogmios wrote:You can export stages from within DataStage Manager ... and import them in the new project.

Can you import them using DS Manager, or do you have to use the server shell?

Use Datastage manager then import ..

Thanks
Man

You have to use the command line to do the 'import' if, as the OP had done, you've created a package using the Packaging Wizard. This was (back in the day) how one had to migrate all released jobs - package them, ftp them to the target server and then run the dspackinst command like utility. Even better, dspackinst had to be executed by 'root' and may still need to be for all I know.

You may be able to install packages from the GUI in 7.5 now, I don't recall. I stopped releasing and packaging jobs when Version Control came on to the scene.

On the topic of using export/import to copy stages, I personally wouldn't do it that way. In my opinion, you are better off rerunning your server installation and letting the 'maintenance mode' of the server install script handle it. That way you can get the missing stages installed into all projects at once and you would also get them into the default project 'template' as well as an added bonus. That way, when you 'add' a new project on this server, the missing stages will not suddenly be missing again.

mandyli wrote:Use Datastage manager then import ..

The Export/Packager Wizard creates a package on the server, but the Import menu doesn't have an option to read that file (I'm using 7.0.1)

The dspackinst can be executed by the administrator id in 7.5. I do not know of a way to execute it via the GUI. The Plug-In Installation and Configuration Guide makes no mention of such an option.

L. Gharis

It's how it is. There is NO package installer GUI if your server is UNIX.

DataStage Packages must be installed on the server machine. If your server is a Windows O/S, then there is a GUI, but if it's UNIX there isn't.