Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 27 Next »

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.

Syntax

Examples

Export by regex usage

Export a subset of a project using the -jobname switch which uses a regular expression filter.

$> mettleci isx export \
     -domain test2-svcs.datamigrators.io:59445 \
     -username myuser -password mypassword \
     -server test2-engn.datamigrators.io \
     -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:

$> mettleci isx export \
     -domain test2-svcs.datamigrators.io:59445 -username myuser -password mypassword  \
     -server test2-engn.datamigrators.io  \
     -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

See also

An example using mettle isx export to support a multi-job compliance query.

  • No labels

© 2015-2024 Data Migrators Pty Ltd.