Question & Answer
Question
How can I improve performance during an import into Datastage?
Answer
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
[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.1;8.7;8.5;8.1;8.0.1;11.5;11.3;11.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
22 June 2018
UID
swg21596357