ISTOOL for EXPORT IMPORT Datastage Components

ISTOOL for EXPORT IMPORT Information Server Components
This post help you to understand export and import of DataStage jobs and other components/assets from command line.
Use istool to export and import DataStage jobs and other Information Server components using UNIX command line.

Location of command:
UNIX: /opt/IBM/InformationServer/Clients/istools/cli
Windows: IBMInformationServerClientsistoolscli 

Export Datastage Components From Command Line

Complete Project Export :
cd /opt/IBM/InformationServer/Clients/istools/cli  
./istool export -dom XYZ123:9080 -u dsadm -p dsadm -ar /tmp/Test1.isx -ds XYZ123/Test1/*/*.*

JobWise Export :
cd /opt/IBM/InformationServer/Clients/istools/cli 
./istool export -dom XYZ123:9080 -u dsadm -p dsadm -ar /tmp/Test1.isx -ds XYZ123/Test1/Jobs/TestJob.pjb

Syntax : ./istool -dom [domain]:9080 -u [user] -p [password] -ar [Path/ExportFileName.isx] -ds [domain/ProjectName/Jobs/JobNameName.pjb] -[Options]

Import Datastage Components From Command Line
cd /opt/IBM/InformationServer/Clients/istools/cli 
./istool import -dom XYZ123:9080 -u dsadm -p dsadm -ar /tmp/Test1.isx -ds XYZ123/Test1

Syntax : ./istool -dom [domain]:9080 -u [user] -p [password] -ar [Path/ExportFileName.isx] -ds [domain/ProjectName]

Check List Of Datastage Projects from Command Line:

DSHOME=`cat /.dshome`;
echo $DSHOME

DSHOME=`cat /.dshome`
. ./dsenv
cd ./bin
./dsjob -lprojects        => { For Listing the Datastage Projects}
./dsjob -ljobs project   => { For Listing the Datastage Jobs in given Project}

Additional Information’s :

Components Extension’s

.pjb Extension   : Datastage Job’s
.tbd Extension   : Datastage Table Definitions
.isx  Extension   : You can import Individual Jobs/Whole Project with this extention

ISTOOL Exit codes: 
0  – Success 
1  – Warning 
2  – Partial failure 
3  – Export failed 
4  – Export preview failed 
5  – Invalid archive file 
10  – Failed to connect to Information Server domain 
11  – Invalid command syntax 

istool export [ Options ]

Possible values For: Options
 Long Name:  Short Name : Description:
 -help ,   -h   : print command usage
 -domain ,          -dom  : Name of Information Server domain
 -username , -u   : Name of user account on Information Server domain
 -password ,  -p   : Password for Information Server account
 -verbose ,  -v   : display progress
 -silent ,   -s   : silence command output
 -archive ,  -ar   : Archive file
 -preview ,  -pre   : Preview export task without executing
 -abortIfError ,  -abort  : Abort task on N errors
 -updatearchive, -up   : Update any existing Package file
 -datastage ,  -ds   : DataStage Assets

Options For : Exporting the DS Jobs.
 -includedependent ,  -incdep  : Include dependent items
 -nodesign ,   -nodes  : Exclude design items
 -includeexecutable ,  -incexec  : Include executable items

 -base ,    -base  : Prefix for Paths,DataStage item paths

2 thoughts on “ISTOOL for EXPORT IMPORT Datastage Components

  1. Hyderabadsys online training provides best online training for varied laptop IT courses Datastage coaching supported specific desires of the learners particularly we’ll provide innovative one to 1 categories that has nice opportunities within the gift IT market. Datastage we tend to additionally provides category area course to alter today’s competitive IT world. Learners will grasp the technology-subject from our extremely experienced & certified trainers which can be serving to the scholars to figure in real time comes. Learners will select either regular course or way categories or weekend coaching categories. It’s proud to be we tend to ar one among st the highest leading Datastage on-line coaching supplier from Republic of India. we tend to ar into this field with passion and dedication we tend to ar in to on-line training from a few years. Our team of well experienced Datastage trainers with immense real time IT expertise in on-line training is devoted towards providing quality training. Hyderabadsys has taken nice steps in providing very best quality on-line training.
    INDIA +91 9030400777
    USA +1-347-606-2716

  2. Datastage online training In production (and, of course, in development and check environments) DataStage is simply another application on the server, associate application that connects to knowledge sources and targets and processes (“transforms”) the information as they move through the applying. so DataStage is classed as associate “ETL tool”, the initials standing for extract, rework and cargo severally. DataStage “jobs”, as they’re legendary, will execute on a singleserver or on multiple machines in an exceedingly cluster or grid setting Datastage online training Datastage online Training.

Leave a Reply

Your email address will not be published.