Saturday, 8 March 2014

ISTOOL for EXPORT IMPORT Information Server Components

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: 
------------------------
- Success 
- Warning 
- Partial failure 
- Export failed 
- Export preview failed 
- 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