0 / 0
IBM Db2 for DataStage connection

IBM Db2 for DataStage connection

To access your data with the IBM Db2 for DataStage connection, create a connection asset for it. This connection works with the DataStage IBM Db2 for DataStage connector, which has exclusive features for DataStage.

Use the IBM Db2 for DataStage connection to connect to data from any of the following databases:

Database Supported versions
IBM Db2 11.1 and 11.5
IBM Db2 for i 7.2 and 7.3
IBM Db2 for z/OS 11, 12, and 13
IBM Db2 Warehouse 11.5
IBM Db2 Warehouse on Cloud Not applicable
IBM Integrated Analytics System 1.0
Note:
  • Not all database products support the same set of features (for example, external tables are not available in Db2 for z/OS, Db2 for i, Db2 version 11.1 or later).
  • Database product requirements or limitations influence the behavior of Db2 connection (for example, change to default constraint-enforcement behavior on newly deployed Db2 Warehouse on Cloud systems).
  • External tables require IBM Data Server Client version 11.5 or later.

Create a connection with IBM Db2 for DataStage connection

To create the connection asset, you need these connection details:

  • Database name
  • Hostname or IP address
  • Port number. The default Db2 port number is 50000.
  • SSL certificate (if required by the database server)

For credentials, choose one of the following methods:

  • Username and password
  • API key: You can use an API key if your Db2 instance supports API keys for credentials. The API key connection property is supported by Db2 starting from version 11.5 Mod Pack 4.

The IBM Db2 for DataStage supports IBM Cloud Satellite connector. The IBM Cloud Satellite tile is available in the Private Connectivity section of the Create connection form. You can set up a Satellite Connector to securely connect to your data source from a Docker container in your on-prem infrastructure or set up a Satellite location with multiple hosts in your infrastructure, such as an on-prem data center or cloud. For more information, see Setting up a Satellite Connector.

Advanced settings (optional)

Keep conductor connection alive: Select to keep the connector conductor process connected during the job run. Selecting this option might speed up the processing. If you do not select this option, the connector conductor process disconnects from the database while the player processes run. The conductor then reconnects when the player processes are complete. To save resources for long-lasting jobs, do not select this option.

Options: Use this field to enter additional CLI/ODBC connection properties that are specific to the Db2 connection. Use a key=value format where each pair is separated by a semicolon character. For information on possible values, see CLI/ODBC configuration keywords listing by category in the Db2 documentation.

Choose the method for creating a connection based on where you are in the platform

In a project
Click Assets > New asset > Connect to a data source. See Adding a connection to a project.

In the Platform assets catalog
Click New connection. See Adding platform connections.

In a deployment space
Click Import assets > Data access > Connection. See Adding data assets to a deployment space.

Next step: Add data assets from the connection

Where you can use this connection

You can use the IBM Db2 for DataStage connection in the following workspaces and tools:

Projects

Catalogs

  • Platform assets catalog

Parent topic: Supported connections

Generative AI search and answer
These answers are generated by a large language model in watsonx.ai based on content from the product documentation. Learn more