IBM Support

How to change Connector Variant in DataStage jobs using Oracle and Teradata Connector stages

Troubleshooting


Problem

Change variant in exisitng jobs which are using Oracles and Teradata Connector stages.

Cause

The GUI Connector Migration Tool converts Oracle and Teradata legacy stages to Oracle and Teradata Connectors in DataStage job designs but not the variant in existing connector stages. This document provides steps to change Oracle and Teradata Connector variant using CCMigration.exe from command line.

Environment

Connector Migration Tool is only a client side tool which will be installed as part of DataStage client software installation. There is no Server side version of this tool on Unix / Linux.

Resolving The Problem

Follow below steps to change variant in Oracle and Teradata connector stage.

1/ On your workstation launch DOS command window.
2/ Go to C:\IBM\InformationServer\Clients\CCMigrationTool\ path (this is default path in your case path might be different).
3/ Change Host name, Port number and Project name from and use dsadm user id password.

For Teradata Connector:
- For Server canvas jobs run below command to change variant from 8.1 to 12.
CCMigration.exe -h <HostName>:9080 -u dsadm -p **** -P <ProjectName> -M -V TeradataConnector=12 -T

- For Parallel canvas jobs run below command to change variant from 8.1 to 12.
CCMigration.exe -h <HostName>:9080 -u dsadm -p **** -P <ProjectName> -M -V TeradataConnectorPX=12 -T

For Oracle Connector:


- For Server canvas jobs run below command to change Oracle Connector variant from 10 to 11.
CCMigration.exe -h <HostName>:9080 -u dsadm -p **** -P <ProjectName> -M -V OracleConnector=11 -T

- For Parallel canvas jobs run below command to change Oracle Connector variant from 10 to 11.
CCMigration.exe -h <HostName>:9080 -u dsadm -p **** -P <ProjectName> -M -V OracleConnectorPX=11 -T

Connector migration tool command line options:
Command
Arguments
Usage
Description
    -h
 Hostname RequiredThe domain host to connect to
    -u
 Username RequiredThe user name with admin privileges
    -p
 Password RequiredThe password of the user
    -P
 Project RequiredThe DataStage project name
    -M

 RequiredMigrate jobs without making a backup copy
    -V
 Variant list OptionalSpecifies the target connector variant for migrated stages. The format of the list is a comma-separated list containing {StageTypeName=Variant}
    -T

 Enable this
mode		Enables the variant migration mode. All connector stages found in jobs and containers whose stage type matches those listed by the –V command will be modified.

[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.1;8.7;8.5;11.5;11.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21625196

Page Feedback