Overview
IBM Db2 is IBM's relational database – runs on-prem, IBM Cloud, or z/OS mainframe. The Automize Db2 connector covers SQL queries, execute, bulk operations.
- Regions: Wherever your Db2 instance runs.
- Plans: IBM licensing varies by edition.
Setting up the connection
- Db2 admin → DB user with required schema grants.
- In Automize → Settings → Connectors → IBM Db2. Paste hostname + port + database + credentials.
Find your credentials at https://www.ibm.com/products/db2.
Rate limits
Per-DB capacity.
Data model
Relational DB:
Database ─── Schemas ─── Tables ─── Rows
└─ Stored procedures + functionsAvailable operations
10 operations available. Click any row to jump to its detail.
| Operation | Category | What it does |
|---|---|---|
| Bulk Insert | General | Insert rows in batches |
| Call Procedure | General | Call a stored procedure |
| Execute | General | Execute an INSERT/UPDATE/DELETE statement |
| Execute Many | General | Execute a statement with multiple parameter sets |
| Export CSV | General | Export query results to a CSV file |
| Import CSV | General | Import a CSV file into a table |
| List Columns | General | List columns of a table |
| List Tables | General | List tables in the database |
| Query | General | Execute a SELECT query and return results |
| Table Exists | General | Check if a table exists |
Operations
Bulk Insert
Insert rows in batches
| Parameter | Required | Type | Description |
|---|---|---|---|
Table table | Yes | string | Table name |
Rows rows | Yes | list | List of row dicts |
Batch Size batch_size | No | integer | Batch size |
Tips
- Bulk load – multi-row INSERT or LOAD utility.
Call Procedure
Call a stored procedure
| Parameter | Required | Type | Description |
|---|---|---|---|
Procedure procedure | Yes | string | Procedure name |
Params params | No | list | Procedure parameters |
Tips
- Invoke stored procedure with IN/OUT params.
Execute
Execute an INSERT/UPDATE/DELETE statement
| Parameter | Required | Type | Description |
|---|---|---|---|
Sql sql | Yes | string | SQL statement |
Params params | No | list | Bind parameters |
Tips
- INSERT/UPDATE/DELETE. Returns affected rows.
Execute Many
Execute a statement with multiple parameter sets
| Parameter | Required | Type | Description |
|---|---|---|---|
Sql sql | Yes | string | SQL statement |
Params List params_list | Yes | list | List of parameter sets |
Export CSV
Export query results to a CSV file
| Parameter | Required | Type | Description |
|---|---|---|---|
Sql sql | Yes | string | SQL SELECT statement |
File Path file_path | Yes | string | Output CSV path |
Params params | No | list | Bind parameters |
Import CSV
Import a CSV file into a table
| Parameter | Required | Type | Description |
|---|---|---|---|
Table table | Yes | string | Target table |
File Path file_path | Yes | string | Path to CSV file |
Has Header has_header | No | boolean | CSV has header row |
List Columns
List columns of a table
| Parameter | Required | Type | Description |
|---|---|---|---|
Table table | Yes | string | Table name |
Schema schema | No | string | Schema name |
List Tables
List tables in the database
| Parameter | Required | Type | Description |
|---|---|---|---|
Schema schema | No | string | Schema name |
Query
Execute a SELECT query and return results
| Parameter | Required | Type | Description |
|---|---|---|---|
Sql sql | Yes | string | SQL SELECT statement |
Params params | No | list | Bind parameters |
Tips
- SELECT statement. Returns rows.
Table Exists
Check if a table exists
| Parameter | Required | Type | Description |
|---|---|---|---|
Table table | Yes | string | Table name |
Schema schema | No | string | Schema name |
FAQ
- z/OS vs LUW vs Cloud?
- z/OS (mainframe), LUW (Linux/Unix/Windows), IBM Cloud all share core SQL. APIs differ slightly – connector handles common cases.