workbench extension source delete command

Use the istool command workbench extension source delete to delete extended data source assets from the metadata repository.

Purpose

Use this command to delete extended data sources or when you want to schedule a deletion.

Requirements

You must have the Information Governance Catalog Information Asset Administrator role.

Information Governance Catalog must be installed on the same IBM® WebSphere® Application Server.

The version of istool command framework must be the same version as InfoSphere® Information Governance Catalog.

Run the command from the client tier, or from the engine tier if InfoSphere Information Governance Catalog was installed there.

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 extension source delete 
authentication parameters
-pattern matching_text_pattern
-output log_file_name
[generic parameters]

Parameters

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

-pattern | -pt matching_text_pattern: Specifies the text pattern to match in the name of the extended data source object.; Include the file extension in the text pattern. Use the percent sign (%) as a wildcard character. The pattern matching is not case-sensitive.
-output | -o log_file_name: Specifies the name of the log file that contains the output, including errors, of the command that was run. Include the directory path in log_file_name.; If the directory does not exist, the command fails.; The log file is created if it does not exist. If the log file does exists, the output is appended to the file. If the command is automated to run at different times, the log file displays the ongoing output of each command that was run.

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

Example 1:

You can delete extended data source of type application called "Amount due" and "Amount past due" from the metadata repository and create the log file C:\IBM\InformationServer\logs\amount_due_delete.log.

istool> workbench extension source delete 
-pt amount%due 
-t StoredProcedure
-o C:\IBM\InformationServer\logs\amount_due_delete.log
-dom mysys
-u myid -p mypassword

The output in the log file would be:

Deleting sources matching 'amount%due'
Found 2 matching extended data sources
Deleted Amount due
Deleted Amount past due
Completed deletion of extended data sources

Example 2:

You can delete extended data source of type file called "Amount due" and "Amount past due" from the metadata repository. No extended data sources of that type are found.

istool> workbench extension source delete 
-pt amount%due 
-t File
-o C:\IBM\InformationServer\logs\amount_due_delete.log
-dom mysys
-u myid -p mypassword

The output of the istool command would be:

Deleting sources matching 'amount%due'
Found 0 matching extended data sources
Completed deletion of extended data sources