> [!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/2612/enabling-secure-db-access.md.txt) documentation page.

## Supported JDBC parameters

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

- `accountingInterval`
- `allowSqljDuplicateStaticQueries`
- `alternateUTF8Encoding`
- `charOutputSize`
- `clientApplcompat`
- `currentFunctionPath`
- `currentPackageSet`
- `currentSQLID`
- `currentSchema`
- `customerId`
- `decimalRoundingMode`
- `defaultSQLState`
- `diagLevelExceptionCode`
- `disableClientInputDataConversion`
- `disableSQLJProfileCaching`
- `disableTimezone`
- `enableDualTransportUsingDifferentProcess`
- `enableInetAddressGetHostName`
- `enableMultirowInsertSupport`
- `enableSeamlessFailoverErrorCodes`
- `enableSysplexWLB`
- `enableT2zosLBF`
- `enableT2zosLBFSPResultSets`
- `enableT2zosLBFSwitchWithIDAA`
- `encryptionAlgorithm`
- `extendedTableInfo`
- `indexName`
- `instanceId`
- `jmxEnabled`
- `keyword`
- `lobOutputSize`
- `maxRefreshInterval`
- `maxTransportObjectIdleTime`
- `maxTransportObjectWaitTime`
- `maxTransportObjects`
- `minTransportObjects`
- `onDataTruncation`
- `pkList`
- `planName`
- `progressiveStreaming`
- `queryPrefetch`
- `rollbackOnShutdown`
- `securityMechanism`
- `sendCharInputsUTF8`
- `ssid`

## 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 |