Utilize the command Line to export and import Information Server DataStage assets

Technote (FAQ)


Question

Is it possible to automate exports and imports of Information Server DataStage assets via the command line?

Answer

One of the fastest ways to work with Information Server assets is by using the Information Server Manager GUI client or the command line tool, istool. The istool framework is the recommended method for managing assets in Information Server. IStool is located on all client and engine tier installations. The istool framework will work with assets to create an .isx file. This .isx file can be imported using the Information Manager GUI or the istool command line. The .isx format is not interchangeable with the .dsx format present in the DataStage Designer client.


There are a few other ways of utilizing the command line to work with assets:

  • The dsexport/dsimport commands are Windows applications and require user interaction via message boxes. These tools are located on the Client tier only.
  • The dscmdexport/dscmdimport commands are Windows command line applications and can be run unattended. Both sets of commands are run from the InfoSphere DataStage client directory (by default c:\IBM\InformationServer\Clients\Classic). These tools are located on the Client tier only.
  • There is also an utility called DSXimportService which is located on any tier that has the ASBNode installed (by default /IBM/InformationServer/ASBNode/bin)
    This tool will let you import an existing dsx via command line on the server.

Documentation links:

istool
http://pic.dhe.ibm.com/infocenter/iisinfsv/v8r5/topic/com.ibm.swg.im.iis.iisinfsv.assetint.doc/topics/using_istool.html
dsexport
http://pic.dhe.ibm.com/infocenter/iisinfsv/v9r1/topic/com.ibm.swg.im.iis.ds.design.doc/topics/dsexportcommand.html
dscmdexport
http://pic.dhe.ibm.com/infocenter/iisinfsv/v9r1/topic/com.ibm.swg.im.iis.ds.design.doc/topics/dscmdexportcommand.html
dsimport
http://pic.dhe.ibm.com/infocenter/iisinfsv/v9r1/topic/com.ibm.swg.im.iis.ds.design.doc/topics/r_ddesref_dsimport_command.html
dscmdimport
http://pic.dhe.ibm.com/infocenter/iisinfsv/v9r1/topic/com.ibm.swg.im.iis.ds.design.doc/topics/r_ddesref_dscmdimport_command.html
DSXimportService http://pic.dhe.ibm.com/infocenter/iisinfsv/v9r1/topic/com.ibm.swg.im.iis.ds.cliapi.ref.doc/topics/importcommands.html

Rate this page:

(0 users)Average rating

Document information


More support for:

InfoSphere DataStage

Software version:

8.0.1, 8.1, 8.5, 8.7, 9.1

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:

1635244

Modified date:

2013-06-27

Translate my page

Machine Translation

Content navigation