Exporting the projects

Use the istool command line interface (CLI) to export all versions of InfoSphere® DataStage® projects. You can also use the dscmdexport command or the InfoSphere DataStage Manager client for Version 7.5.3 or earlier. You can use the InfoSphere DataStage Designer client for Version 8.0.1 or later to export InfoSphere DataStage projects. You can use the InfoSphere Information Server Manager for Version 8.1 or later to export InfoSphere DataStage projects. If you use the istool or dscmdexport command, you can create a script that exports all projects at one time.

About this task

Unless you need to migrate job level message handlers, you can export jobs without executables. Do not export compiled jobs. You will recompile all migrated jobs when the migration is complete. If any export file is larger than 2 GB, export the project into two or more smaller files.
Note: For best performance when using the istool command line interface (CLI) to move large volumes of assets, try to export no more than 2,000 jobs to the same archive file.

Procedure

Use the istool command line interface (CLI), the dscmdexport command, the InfoSphere Information Server Manager client, or the InfoSphere DataStage Designer client to export projects.
Option Description
To use the istool command line interface (CLI) to export projects, See the following topic for information about using the istool command line interface to export projects: Istool export command for InfoSphere DataStage and QualityStage assets.
Note: When using istool to export projects, you can use the -includedependent parameter to transfer common metadata assets, such as database tables that are related to the exported table definitions. However, depending on your migration strategy, you might prefer to transfer all common metadata assets by using the -commonmetadata parameter in a separate export command. You must transfer implemented data resources before transferring InfoSphere DataStage jobs.
The istool command line interface (CLI) is the only method that gives you the option to export common metadata assets that are associated with the projects.
To use the dscmdexport command to export projects
  1. On the DataStage client computer, open a command line editor and go to the DataStage client directory. For Version 7.5.3 and earlier, the default path is C:\Ascential\Program Files\Ascential\DataStageversion. For Version 8.0.1 and later, the default path is C:\IBM\InformationServer\Clients\Classic.
  2. Enter the following command:
    dscmdexport /AF=authfile |
    /D=domainname /U=username /P=password /H=hostname project_name export_file_path [/V]  
    The arguments are the following:
    • authfile is the name of the encrypted credentials file that contains the connection details.
    • domainname is the name of the services tier computer.
    • hostname is the name of the InfoSphere DataStage services tier computer.
    • username is your user name to log on to InfoSphere DataStage.
    • password is the password for the user name.
    • project_name is the name of the project that you are exporting.
    • export_file_path is the path name of the destination file. By convention, export files have the file extension .dsx.
    • /V turns the verbose option on so that you can follow the progress of the export procedure.
  3. Example: This example uses the command line to export the project named monthlyaudit that is located on the server named R101 and writes the project to a file named monthlyaudit.dsx. The target file is located in a directory named migrated_projects on the client computer:
    dscmdexport /D=DOM1 /U=BillG /P=paddock /H=R101 monthlyaudit C:\migrated_projects\monthlyaudit.dsx
To use the InfoSphere Information Server Manager client to export projects
  1. Open the InfoSphere Information Server Manager client and attach to the project that you want to export.
  2. Confirm that View > Host View is selected.
  3. Select Export > DataStage Components.
  4. In the Export window, specify details about the project that you want to export:
    • In the Export to file field, type or browse for the path name of the file in which to store the project. By default, export files have the file extension .dsx.
    • On the Components tab, select Whole Project.
  5. Click OK. The project is exported to the file that you specify.
  6. In the left pane of the InfoSphere Information Server Manager client, select the next project and repeat steps c through e.
To use the InfoSphere DataStage Designer client to export projects
  1. Select the project in the tree on the left pane of the Designer client.
  2. Right-click the project and select Export item from the context menu.

    This brings up the Repository Export dialog. All items in the project are automatically selected in this dialog.

  3. Edit the Export to file field. Specify the absolute path of the export file name.

    This file is created by the export process. For example, C:\Temp\project_export_file.dsx.

  4. Select Export.
  5. Select Close when the export is complete.
To export other projects, close the InfoSphere DataStage Designer client and open the InfoSphere DataStage Designer client against another project to repeat the export process.