Recommended Resources
Abstract
IBM InfoSphere Information Server DataStage jobs use various connector stages to perform data extract, transform and load operations. Due to business requirements it is sometimes required to replace one connector stage with another. Rapid Job Update Tool automates the task allowing easy migration between stages.
Content
The Rapid Job Update Tool (RJUT) performs a number of job migration tasks including:
- Replacing one connector stage with another
- Setting properties in connector stages
- Modifying column definitions in jobs
- Exporting and importing SQL statements within jobs
Most functions can either be invoked through the tool's user interface or from a command line. Detailed description of Rapid Job Update Tool is available as a PDF document inside the package.
The following sections provide information about Rapid Job Update Tool packages for particular IBM InfoSphere Information Server version. Each table contains list of supported connectors with the information about the stage properties compatibility with the tool. You should use matching version of Rapid Job Update Tool and IBM InfoSphere Information Server.
For example, when the ODBC Connector is described to be at IBM InfoSphere Information Server, version 11.7.0.2 level, it means that stage properties supported by Rapid Job Update Tool are compatible with connector released with IBM InfoSphere Information Server, version 11.7.0.2. There may be newer connector patches published after IBM InfoSphere Information Server, version 11.7.0.2, but there were no changes to configuration properties.
Another example is DB2 connector, that is defined to be on patch level for APAR JR61510. It means, that patch JR61510 introduced changes to connector configuration properties over version released with IBM InfoSphere Information Server 11.7.0.2. The presence of APAR JR6150 in the table for IBM InfoSphere Information Server, version 11.7.0.2 informs that Rapid Job Update Tool supports DB2 connector stage at both 11.7.0.2 and JR61510 patch levels.
Rapid Job Update Tool for IBM InfoSphere Information Server, version 11.7.0.x
Fixes (2019-11-28)
- #7905 RJUT is incorrectly processing properties when columns callout dialog is used in connector descriptor
- #7904 RJUT hangs on configuring column types conversion
| Connector | Level |
|---|---|
| DB2 Connector | JR61510: DB2 Connector support for external tables in read and write modes |
| Netezza Connector | IBM InfoSphere Information Server, version 11.7.0.2 |
| ODBC Connector | IBM InfoSphere Information Server, version 11.7.0.2 |
| Oracle Connector | IBM InfoSphere Information Server, version 11.7.0.2 |
| Teradata Connector | IBM InfoSphere Information Server, version 11.7.0.2 |
| WebSphere MQ Connector | IBM InfoSphere Information Server, version 11.7.0.2 |
Rapid Job Update Tool for IBM InfoSphere Information Server, version 11.7.1.x
File for IIS version 11.7.1.0-11.7.1.2: RapidJobUpdateTool_is11710-11712_20200930.zip
File for IIS version 11.7.1.3-11.7.1.4: RapidJobUpdateTool_is11713-11714_20230214.zip
Changes (2023-02-15)
- Separate RJUT binaries for IIS 11.7.1.0-2 and 11.7.1.3-4
- Support for Before/After SQL in BigQuery Connector
- Support user-defined SQL statement in BigQuery Connector
- Support to migrate from Teradata Connector to BigQuery Connector
- #7905 RJUT is incorrectly processing properties when columns callout dialog is used in connector descriptor
- #7904 RJUT hangs on configuring column types conversion
| Connector | Description |
|---|---|
| BigQuery Connector | JR62847: Add support for Before / After SQL in the BigQuery Connector |
| DB2 Connector | IBM InfoSphere Information Server, version 11.7.1.1 |
| Netezza Connector | IBM InfoSphere Information Server, version 11.7.1.1 |
| ODBC Connector | IBM InfoSphere Information Server, version 11.7.1.1 |
| Oracle Connector | IBM InfoSphere Information Server, version 11.7.1.1 |
| Teradata Connector | IBM InfoSphere Information Server, version 11.7.1.1 |
| WebSphere MQ Connector | IBM InfoSphere Information Server, version 11.7.1.1 |
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"ARM Category":[{"code":"a8m50000000L0seAAC","label":"Tools and Commands"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"11.7.0;11.7.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
15 February 2023
UID
ibm11096702