Many thanks for visiting my Blog..!!Please share this blog using below share buttons and leave your Comments/Feedback/Appreciations on Tab: Feedback
Share This Blog..!!

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: \IBM\InformationServer\Clients\istools\cli 


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`
cd $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
                     

No comments:

Post a Comment

disqus