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
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 :
------------------------------------------------
-------------------------------
.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