workbench importOMD command

Use the istool command workbench importOMD to import operational metadata of jobs from earlier versions of IBM® InfoSphere® DataStage®.

Purpose

Use this command to import operational metadata or when you want to schedule an import.

In InfoSphere DataStage, Version 11.3, the operational metadata is automatically imported into the metadata repository. To support the display and use of operational metadata from jobs that were run in an earlier version of InfoSphere DataStage, manually import operational metadata.

Requirements

  • You must have the Information Governance Catalog Information Asset Administrator role.
  • The version of istool command framework must be the same version as IBM InfoSphere Information Governance Catalog.
  • You must allocate more memory to the istool process. For details, see this technote.
  • Run the command from the client tier, or from the engine tier if InfoSphere Information Governance Catalog was installed there.
  • You must copy the XML file with operational metadata from \IBM\InformationServer\ASBNode\conf\etc\XmlFiles\ to a temporary directory.
  • Import the DSX file of the job before you import the operational metadata of the job. Otherwise, the message
    No job exists in the metadata repository with the same job name, project name, and host name as in the XML import file.
    is displayed.
  • If the XML import file is from a different InfoSphere DataStage installation, then edit the XML import file to match the project and host names of the target system.

Command syntax

The preferred way to run this command is in the istool command-line window. If you run this command in your operating system command-line window or in scripts, you must add istool before the command name.

istool> workbench importOMD
authentication parameters
-filename import_file
[generic parameters] 

Parameters

These parameters are specific to the workbench importOMD command. For authentication parameters and generic parameters, see Common commands and parameters.

-filename | -f import_file
Specifies the file name or the directory path of the files that contains the operational metadata for import into the metadata repository. The files must be in an extensible markup language (XML) format.
You can import a single file or several files. Separate file names in a list by using a comma (,). Enclose the file name or the directory name in double quotation marks (").

Output

A return value of 0 indicates successful completion; any other value indicates failure. The reason for the failure is displayed in a screen message.

For more information, see the system log file in either of the following directories:
For Microsoft Windows operating system environment
C:\Documents and Settings\username\istool_workspace\.metadata\.log
where username is the name of the operating system account of the user who runs this command.
For UNIX or Linux operating system environment
user_home/username/istool_workspace/.metadata/.log
where user_home is the root directory of all user accounts, and username is the name of the operating system account of the user who runs this command.

Example

A single XML file contains operational metadata of a job that was compiled and run in InfoSphere DataStage, version 9.1. You copy this XML file to C:\omd_import_dir. Then, run this command to import operational metadata from the directory into the metadata repository:
istool> workbench importOMD 
-dom mysys
-u myid -p mypassword
-f "C:\omd_import_dir\myfile.xml"

This command imports operational metadata from several XML files in the same directory:
istool> workbench importOMD 
-dom mysys
-u myid -p mypassword
-f "C:\omd_import_dir\myfiles"