IBM Support

How can I improve performance during an import into Datastage?

Technote (FAQ)


How can I improve performance during an import into Datastage?


One way to improve performance of an import is to exclude the executables.
Here are three different ways to exclude executables from the import.

  • Exclude the executables from the export.
    In DataStage Designer export using the option export Jobs without executables.
  • Create an xml file instead of a dsx file.
    Executables are not included in xml files.
    (The xml option is available with dscmdexport but only with /JOB option)
  • Use the IS Manager or istool command.
    See Technote: How to use ISTOOL for EXPORT IMPORT Information Server Components
    The IS Manager and istool command is the recommended way to move jobs
    into new projects.
    You can use the istool command line interface (CLI) to export assets to an archive file. The default extension of the archivefile is .isx.
    When using the istool command, if you do not use the parameter -incexe, it will not include executables.

Related information

Slow import of large number of DataStage job designs
JR38163 (8.1) Performance of Windows Clients for Import

Document information

More support for: InfoSphere DataStage

Software version: 8.0.1, 8.1, 8.5, 8.7

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Reference #: 1596357

Modified date: 19 June 2012

Translate this page: