> [!NOTE]
> **Note:** As of Looker 23.14, Looker does not support new connections to IBM DB2. Existing connections will continue to function 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/2602/enabling-secure-db-access) documentation page.

## Feature support

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

IBM DB2 supports the following features as of Looker 23.14:

| Feature | Supported? |
|---|---|
| Support Level | Supported |
| 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 | Yes |
| 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 |