IBM Data Virtualization Manager for z/OS connector
Use the IBM® Data Virtualization Manager for z/OS® connector to work in your z/OS mainframe environment. IBM Data Virtualization Manager for z/OS integrates data sources across multiple types and locations. It provides virtual, integrated views of data on IBM Z . You do not need to move, replicate, or transform the data because the IBM Data Virtualization Manager for z/OS enables users and applications to have read and write access to IBM Z Z data in place.
Prerequisite
Create the connection. For instructions, see Connecting to a data source in DataStage® and the IBM Data Virtualization Manager for z/OS connection.
Writing data to the IBM Data Virtualization Manager for z/OS connector as a target
If you want to configure IBM IBM Data Virtualization Manager for
z/OS connector
for DataStage as a target, you can:
- Double-click the IBM IBM Data Virtualization Manager for z/OS connector icon in the project canvas.
- In the Stage tab under the Properties section, find the General target properties.
- In the General target properties, choose one of the Write
mode option.
Table 1. Write mode methods Write mode Procedure Insert Provide: schema name, table name, table action, key column names, heap size, and batch size. Update Provide: schema name, table name, key column names, heap size, and batch size. Update statement Provide: SQL update statement for updating data in the table, heap size, and batch size. Update statement with table action Provide: schema name, table name, table action, SQL update statement for updating data in the table, heap size, and batch size. Note: While choosing the Table action, you can choose: Append or Truncate option. IBM Data Virtualization Manager for z/OS connector does not support create operation. When the Append option is selected, table will not be created, if it does not exist and flow run will fail.
Reading data from the IBM Data Virtualization Manager for z/OS connector as a source
If you want to configure IBM IBM Data Virtualization Manager for
z/OS connector
for DataStage as a source, you can:
- Double-click the IBM IBM Data Virtualization Manager for z/OS connector icon in the project canvas.
- In the Stage tab under the Properties section, find the General source properties.
- In the General source properties, choose one of the Read
method option.
Table 2. Read methods Read method Procedure General Provide: schema name, key column names, table name, decimal rounding mode, and default maximum length for columns. Select statement Provide: key column names, decimal rounding mode, default maximum length for columns, and SQL statement.