> [!NOTE]
> **Note:** As of Looker 23.14, Looker does not support new connections to IBM DB2. Existing connections will continue to work as expected.

## Encrypting network traffic

It is a best practice to encrypt network traffic between the Looker application and your database. Consider one of the options that are described on the [Enabling secure database access](https://docs.cloud.google.com/looker/docs/2622/enabling-secure-db-access.md.txt) documentation page.

## Supported JDBC parameters

For IBM DB2 on AS400, Looker supports the following JDBC parameters in the [**Additional JDBC parameters**](https://docs.cloud.google.com/looker/docs/2622/connecting-to-your-db.md.txt#additional_jdbc_parameters) field for the connection. See the documentation for your database for information on these parameters.

- `access`
- `auto commit`
- `batch style`
- `block size`
- `blocking enabled`
- `commit hold`
- `concurrent access resolution`
- `cursor hold`
- `cursor sensitivity`
- `data truncation`
- `date format`
- `date separator`
- `decfloat rounding mode`
- `decimal separator`
- `direct map`
- `errors`
- `libraries`
- `lob threshold`
- `maximum blocked input rows`
- `naming`
- `password`
- `user`

## Feature support

For Looker to support some features, your database dialect must also support them.

IBM DB2 for AS400 and System i supports the following features as of Looker 23.12:

| Feature | Supported? |
|---|---|
| Support Level | Integration |
| Looker (Google Cloud core) | No |
| Symmetric Aggregates | No |
| Derived Tables | Yes |
| Persistent SQL Derived Tables | Yes |
| Persistent Native Derived Tables | Yes |
| Stable Views | Yes |
| Query Killing | Yes |
| SQL-based Pivots | No |
| Timezones | No |
| SSL | Yes |
| Subtotals | No |
| JDBC Additional Params | Yes |
| Case Sensitive | Yes |
| Location Type | Yes |
| List Type | No |
| Percentile | No |
| Distinct Percentile | No |
| SQL Runner Show Processes | No |
| SQL Runner Describe Table | Yes |
| SQL Runner Show Indexes | Yes |
| SQL Runner Select 10 | Yes |
| SQL Runner Count | Yes |
| SQL Explain | No |
| Oauth Credentials | No |
| Context Comments | Yes |
| Connection Pooling | No |
| HLL Sketches | No |
| Aggregate Awareness | Yes |
| Incremental PDTs | No |
| Milliseconds | Yes |
| Microseconds | Yes |
| Materialized Views | No |
| Approximate Count Distinct | No |