IBM Db2

Connect to IBM Db2 so you can browse schemas, build queries, and (where supported) render spatial maps.

Goal

Create a working IBM Db2 connection in Connection Manager.

Prerequisites

• Host name, port, database name, and credentials
• Firewall access from your workstation

Steps

1. Open Data → Connection Manager….
2. Add a connection and choose IBM Db2.
3. Enter connection details (host, port, database/service, user, password, and provider-specific options).
4. Click Test (or equivalent) to verify connectivity.
5. Save the connection.
6. On the Data tab, select the connection and open Query Builder to start a query.

[ Screenshot: IBM Db2 connection settings ]

Notes

Note

Db2 LUW is supported. Some specialized platforms (for example z/OS or Warehouse variants) may be unavailable in the connection form.

Tip

For spatial maps, see IBM Db2 Spatial.

Result

The connection appears in Connection Manager and can be selected for queries and compatible map sources.

See Also

• Data Sources overview
• Query Builder
• Parameters
• IBM Db2 Spatial maps