Purpose

Exports DataStage Assets to ISX files, one file per Asset. This adds a number of capabilities over the IBM-supplied commands, including…

Support for high-performance multi-threaded operation (using the -threads switch)
Support for incremental exports (using the -project-cache parameter)

See Repeatable DataStage Project Deployments for more details on how the -project-cache parameter is used to implement incremental exports. For more information on using the -project-cache parameter see our detailed explanation.

Note that the isx export commands requires access to a correctly-functioning istool command and so is only executable on a Windows-based DataStage Client Tier.

Syntax

Examples

Export by regex usage

Export a subset of a project using the -jobname parameter which accepts a regular expression filter.

C:\MettleCI\cli> mettleci isx export ^
     -domain myteam-svcs.corp.com:59445 ^
     -username myuser -password mypassword ^
     -server myteam-engn.corp.com ^
     -project myproject ^
     -jobname .*LD_S.*
Exporting [.*LD_S.*] from repository...
Exporting DataStage assets...
 * Export 'test2-engn.datamigrators.io/myproject/Jobs/Load/LD_SUPPLIER.pjb' - COMPLETED
 * Export 'test2-engn.datamigrators.io/myproject/Jobs/Load/LD_STOCK_HOLDING.pjb' - COMPLETED
 * Export 'test2-engn.datamigrators.io/myproject/Jobs/Load/LD_STOCKITEM.pjb' - COMPLETED
 * Export 'test2-engn.datamigrators.io/myproject/Jobs/Load/LD_SALE.pjb' - COMPLETED
Export complete

Incremental export usage

Incrementally export project binaries, C:/shared/myproject/export is a directory containing previously exported ISX files and C:/shared/myproject/cache contains state files related to incremental operations performed against myproject:

C:\MettleCI\cli\> mettleci isx export ^
     -domain myteam-svcs.corp.com:59445 ^
     -username myuser -password mypassword  ^
     -server myteam-engn.corp.com  ^
     -project myproject  ^
     -location C:\shared\myproject\export  ^
     -include-binaries  ^
     -project-cache C:\shared\myproject\cache
Analyzing test2-engn.datamigrators.io/myproject
Attempting to identify changes with 4 working threads.
Inspecting DataStage assets for changes...
 * Check test2-engn.datamigrators.io/myproject/Jobs/Connections/DMSqlServer_DW.dcn - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Connections/DMSqlServer_OLTP.dcn - COMPLETED
<SNIP>
 * Check test2-engn.datamigrators.io/myproject/Jobs/ParameterSets/pGlobal.pst - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/ParameterSets/pDMSqlServer_DW.pst - COMPLETED
Change identification complete
Inspecting ParameterSet definition changes...
ParameterSet definition change identification complete
Deleting assets...
 * Export 'C:\shared\myproject\export\Jobs\Transform\TR_PURCHASE.isx/Jobs/Transform/TR_PURCHASE.pjb' - DELETED
 * Export 'C:\shared\myproject\export\Jobs\Transform\TR_ORDERS.isx/Jobs/Transform/TR_ORDERS.pjb' - DELETED
Deletion complete
Exporting DataStage assets...
 * Export 'test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_ORDERS.pjb' - COMPLETED
 * Export 'test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_PURCHASE.pjb' - COMPLETED
Export complete
Attempting to identify last change with 4 working threads.
Inspecting DataStage assets for last change...
 * Check test2-engn.datamigrators.io/myproject/Jobs/ParameterSets/pDMSqlServer_OLTP.pst - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/ParameterSets/pGlobal.pst - COMPLETED
<SNIP>
 * Check test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_PURCHASE.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_ORDERS.pjb - COMPLETED
Last change identification complete

ISX Export Command

Purpose

Syntax

Examples

Export by regex usage

Incremental export usage

See also