DB2 connection properties
This is list of properties that are compatible with db2.
They are inside given data source configuration file. For example: db2Test-source_1.conf These properties are saved in this format there:
"properties": {
"ApplicationName": "testApp",
"testQuery": "SELECT 1",
"defaultCatalog": "test",
"url": "jdbc:db2://localhost:50000/${database}"
},
⚠️ Note: You can use SHIFT with mouse scroll to scroll horizontally!
| Key | Description | Possible values | Default |
|---|---|---|---|
| accessToken | An IAM access token for token-based authentication to Db2. The data type of this property is String. | String ( up to 8000 bytes ) | - |
| accountingInterval | Specifies when Db2 should cut accounting records for the connection. The data type of this property is String. "COMMIT" or any other value (meaning end of connection) | String | END OF CONNECTION |
| alternateGroupDatabaseName | Define an alternate group of databases for client affinity automatic failover. The data type of this property is String. | String | - |
| alternateGroupPortNumber | Define an alternate group of ports for client affinity automatic failover. The data type of this property is String. | String | - |
| alternateGroupServerName | Define an alternate group of hosts for client affinity automatic failover. The data type of this property is String. | String | - |
| affinityFailbackInterval | Specifies the length of the interval, in seconds, that the IBM Data Server Driver for JDBC and SQLJ waits between attempts to fail back an existing connection to the primary server. A value that is less than or equal to 0 means that the connection does not fail back. The default is DB2BaseDataSource.NOT_SET (0). | Integer | 0 |
| allowNextOnExhaustedResultSet | Specifies how the IBM Data Server Driver for JDBC and SQLJ handles a ResultSet.next() call for a forward-only cursor that is positioned after the last row of the ResultSet. The data type of this property is int. | Integer | 2 |
| allowNullResultSetForExecuteQuery | Specifies whether the IBM Data Server Driver for JDBC and SQLJ returns null when Statement.executeQuery, PreparedStatement.executeQuery, or CallableStatement.executeQuery is used to execute a CALL statement for a stored procedure that does not return any result sets. 0 = NO_SET, 1 = YES, 2 = NO. | Integer (0, 1, 2) | - |
| apiKey | An API key for IBM Cloud that the driver can exchange for an IAM access token. The data type of this property is String. | String ( up to 8000 bytes ) | - |
| atomicMultiRowInsert | Specifies whether batch operations that use PreparedStatement methods to modify a table are atomic or non-atomic. The data type of this property is int. 1 = atomic batch, 2 = non atomic, 0 same as 2. | Integer (0, 1, 2) | 0 |
| blockingReadConnectionTimeout | The amount of time in seconds before a connection socket read times out. This property applies only to IBM Data Server Driver for JDBC and SQLJ type 4 connectivity, and affects all requests that are sent to the data source after a connection is successfully established. The default is 0. A value of 0 means that there is no timeout. | Integer | 0 ( no timeout) |
| charOutputSize | Specifies the maximum number of bytes to use for INOUT or OUT stored procedure parameters that are registered as Types.CHAR charOutputSize applies only to IBM Data Server Driver for JDBC and SQLJ type 2 connectivity to DB2 for z/OS database servers. The data type of this property is short. | Short | 32767 |
| clientAccountingInformation | Specifies accounting information for the current client for the connection. The data type of this property is String. | String (max 255 bytes) | - |
| clientApplcompat | IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only. The data type of this property is String. | String | - |
| clientApplicationInformation | Specifies the application or transaction name of the end user's application. You can use this property to provide the identity of the client end user for accounting and monitoring purposes. The data type of this property is String. | String ( up to 32b (OS), up to 255b) | - |
| clientDebugInfo | Specifies a value for the CLIENT DEBUGINFO connection attribute, to notify the data server that stored procedures and user-defined functions that are using the connection are running in debug mode. CLIENT DEBUGINFO is used by the DB2 Unified Debugger. The data type of this property is String. The maximum length is 254 bytes. | String (up to 254 bytes) | - |
| clientProgramId | Specifies a client program identifier that can be used to identify the end user program. The data type of this property is String. | String (80 bytes) | - |
| clientProgramName | IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only. The data type of this property is String. | String (max 20 bytes) | db2jcc_application |
| clientRerouteAlternateServerName | Specifies one or more server names for client reroute. The data type of this property is String. | String (e.g. "host1,host2") | - |
| clientRerouteAlternatePortNumber | Specifies one or more port numbers for client reroute. The data type of this property is String. | String | - |
| clientRerouteServerListJNDIName | Identifies a JNDI reference to a DB2ClientRerouteServerList instance in a JNDI repository of reroute server information. clientRerouteServerListJNDIName applies only to IBM Data Server Driver for JDBC and SQLJ type 4 connectivity, and to connections that are established through the DataSource interface. | String | - |
| clientRerouteServerListJNDIContext | Specifies the JNDI context that is used for binding and lookup of the DB2ClientRerouteServerList instance. clientRerouteServerListJNDIContext applies only to IBM Data Server Driver for JDBC and SQLJ type 4 connectivity, and to connections that are established through the DataSource interface. | javax.naming.Context | - |
| clientUser | IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on Db2 for z/OS only. The data type of this property is String. | String (max 128 bytes) | - |
| clientWorkstation | IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on Db2 for z/OS only. The data type of this property is String. | String (max 255 bytes) | - |
| commandTimeout | IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only. The data type of this property is int. | Integer | 0 ( no timeout ) |
| connectionCloseWithInFlightTransaction | Specifies whether the IBM Data Server Driver for JDBC and SQLJ throws an SQLException or rolls back a transaction without throwing an SQLException when a connection is closed in the middle of the transaction. 0 = NOT_SET, 1 = CONNECTION_CLOSE_WITH_EXCEPTION, 2 = CONNECTION_CLOSE_WITH_ROLLBACK, 3 = CONNECTION_CLOSE_WITH_COMMIT | Integer (0, 1, 2, 3) | - |
| concurrentAccessResolution | Controls the “currently committed” semantics for read transactions. The data type of this property is int. USE_CURRENTLY_COMMITTED (1), WAIT_FOR_OUTCOME (2), NOT_SET (0) | Integer (0, 1, 2) | NOT_SET |
| connectNode | Specifies the target database partition server that an application connects to. The data type of this property is int. | Integer (0 - 999) | 0 |
| connectionTimeout | IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only. The data type of this property is int. | Integer | - |
| currentDegree | Sets the CURRENT DEGREE (parallelism degree) special register for dynamic SQL. The data type of this property is String. | String | - |
| currentExplainMode | Sets the CURRENT EXPLAIN MODE special register. The data type of this property is String. | String (EXPLAIN, NO, YES) | - |
| currentExplainSnapshot | Sets the CURRENT EXPLAIN SNAPSHOT special register. The data type of this property is String. | String(NO, YES) | - |
| currentFunctionPath | Specifies an SQL path (comma-separated list of schemas) used to resolve unqualified data types and function names in SQL statements. The data type of this property is String. | String | - |
| currentLocaleLcCtype | Specifies the LC_CTYPE locale that is used to execute SQL statements that use a built-in function that references a locale. The data type of this property is String. | String | - |
| currentLockTimeout | Specifies whether DB2 Database for Linux, UNIX, and Windows servers wait for a lock when the lock cannot be obtained immediately. The data type of this property is int. | Integer (-1 and 32767) | -1 (Do no wait) |
| currentMaintainedTableTypesForOptimization | Sets the CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION. The data type of this property is String. | String (ALL, SYSTEM, USER, NONE) | - |
| currentPackagePath | List of package collections for DB2 packages. The data type of this property is String. | String | - |
| currentPackageSet | Specifies the package collection (library) on the server to use for DB2 packages. The data type of this property is String. For type 4 connections, default is NULLID | String | NULLID / None |
| currentQueryOptimization | Specifies the query optimization class for dynamic SQL, by setting the CURRENT QUERY OPTIMIZATION special register. The data type of this property is int. | Integer | 5 |
| currentRefreshAge | Specifies a timestamp duration value that is the maximum duration since a REFRESH TABLE statement was processed on a system-maintained REFRESH DEFERRED materialized query table such that the materialized query table can be used to optimize the processing of a query. The data type of this property is long. | Long | 0 |
| currentSchema | Sets the default schema name. The data type of this property is String. | String | - |
| cursorSensitivity | Should ResultSet.TYPE_SCROLL_SENSITIVE map to sensitive dynamic, sensitive static, or asensitive cursor on the server. 0 = insensitive, 1 = sensitive dynamic, 2 = asensitive. The data type of this property is int. | Integer (0, 1, 2) | 0 |
| currentSQLID | Specifies: The authorization ID that is used for authorization checking on dynamically prepared CREATE, GRANT, and REVOKE SQL statements. The owner of a table space, database, storage group, or synonym that is created by a dynamically issued CREATE statement. The implicit qualifier of all table, view, alias, and index names specified in dynamic SQL statements. .The data type of this property is String. | String | - |
| databaseName | Specifies the name for the data source. This name is used as the database portion of the connection URL. The name depends on whether IBM Data Server Driver for JDBC and SQLJ type 4 connectivity or IBM Data Server Driver for JDBC and SQLJ type 2 connectivity is used. | String | - |
| dateFormat | Defines the format for date values when using PreparedStatement.setString() for a DATE column, and the format of the string returned by ResultSet.getString() on a DATE column. The data type of this property is int. 1 = ISO, 2 = USA, 3 = EUR, 4 = JIS. | Integer | 1 |
| decimalRoundingMode | Sets the rounding mode for decimal floating-point (DECFLOAT) operations performed by the driver . Affects how results are rounded to the target precision. The data type of this property is int. 1 = Round down, 2 = round ceiling, 3 = round half even, 4 = round half up. | Integer (1, 2, 3, 4) | 3 |
| decimalSeparator | Specifies the decimal separator for input and output, for decimal, floating point, or decimal floating-point data values. The data type of this property is int. 0 = NOT SET, 1 = SEPARATOR PERIOD, 2 = SEPARATOR COMMA. | Integer (0, 1, 2) | 0 |
| decimalStringFormat | Specifies the string format for data that is retrieved from a DECIMAL or DECFLOAT column when the SDK for Java™ is Version 1.5 or later. The data type of this property is int. 0 = FORMAT NOT SET, 1 = FORMAT TO STRING, 2 = FORMAT TO PLAIN STRING. | Integer (0, 1, 2) | 0 |
| defaultIsolationLevel | Specifies the default transaction isolation level for new connections. The data type of this property is int. When defaultIsolationLevel is set on a DataSource, all connections that are created from that DataSource have the default isolation level that is specified by defaultIsolationLevel. | Integer | Depends on data source |
| deferPrepares | Specifies whether invocation of the Connection.prepareStatement method results in immediate preparation of an SQL statement on the data source, or whether statement preparation is deferred until the PreparedStatement.execute method is executed. The data type of this property is boolean. | Boolean | false |
| description | A description of the data source. The data type of this property is String. | String | - |
| downgradeHoldCursorsUnderXa | Specifies whether cursors that are defined WITH HOLD can be opened under XA connections. | Boolean | false |
| driverType | For the DataSource interface, determines which driver to use for connections. The data type of this property is int. Valid values are 2 or 4. 2 is the default. | Integer(2, 4) | 2 |
| dumpPool | Specifies the types of statistics on global transport pool events that are written, in addition to summary statistics. The data type of this property is int. 0 = NOT_SET, 1 = DUMP_REMOVE_OBJECT, 2 = DUMP_GET_OBJECT, 4 = DUMP_WAIT_OBJECT, 8 = DUMP_SET_AVAILABLE_OBJECT, 16 = DUMP_CREATE_OBJECT, 32 = DUMP_SYSPLEX_MSG, 128 = DUMP_POOL_ERROR. You can combine the constants by using numeric addition to trace multiple options. | Integer (options in desc.) | 0 |
| dumpPoolStatisticsOnSchedule | Specifies how often, in seconds, global transport pool statistics are written to the file that is specified by dumpPoolStatisticsOnScheduleFile. The data type of this property is int. | Integer | -1 ( stats are not written) |
| dumpPoolStatisticsOnScheduleFile | Specifies the name of the file to which global transport pool statistics are written. The global transport pool is used for the connection concentrator and Sysplex workload balancing. The data type of this property is String. | String | - |
| enableAlternateGroupSeamlessACR | Specifies whether failover to an alternate group is seamless or non-seamless. The data type of this property is Boolean. | Boolean | false |
| enableClientAffinitiesList | Specifies whether the IBM Data Server Driver for JDBC and SQLJ enables client affinities for cascaded failover support. The data type of this property is int. 1 = enable, 0 = disable. | Integer (0, 1) | 0 |
| enableExtendedIndicators | Specifies whether support for extended indicators is enabled in the IBM Data Server Driver for JDBC and SQLJ. The data type of this property is int. | Integer (0, 1, 2) | 0 |
| enableNamedParameterMarkers | Specifies whether support for named parameter markers is enabled in the IBM Data Server Driver for JDBC and SQLJ. The data type of this property is int. Not set = 0, YES = 1, NO = 2. | Integer (0, 1, 2) | 0 |
| enableConnectionConcentrator | IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only. The data type of this property is Boolean. | Boolean | false |
| enableMultiRowInsertSupport | Specifies whether the IBM Data Server Driver for JDBC and SQLJ uses multi-row INSERT for batched INSERT or MERGE operations, when the target data server is a Db2 for z/OS server that supports multi-row INSERT. The data type of this property is Boolean. | Boolean | true |
| enableRowsetSupport | Specifies whether the IBM Data Server Driver for JDBC and SQLJ uses multiple-row FETCH for forward-only cursors or scrollable cursors, if the data server supports multiple-row FETCH. The data type of this property is int. | Integer (0, 1, 2) | 0 |
| enableSeamlessFailover | Specifies whether the IBM Data Server Driver for JDBC and SQLJ uses seamless failover for client reroute. The data type of this property is int. Not set = 0, YES = 1, NO = 2. | Integer (0, 1, 2) | 2 |
| enableSysplexWLB | IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only. The data type of this property is Boolean. | Boolean | false |
| encryptionAlgorithm | Specifies whether the IBM Data Server Driver for JDBC and SQLJ uses 56-bit DES (weak) encryption (value = 1) or 256-bit AES (strong) encryption (value = 2). The data type of this property is int. | Integer | - |
| enableExtendedDescribe | Specifies whether the IBM Data Server Driver for JDBC and SQLJ requests extended describe information from the data server when it prepares a statement. The data type of this property is int. Not set = 0, YES = 1, NO = 2. | Integer(0, 1, 2) | 0 |
| enableT2zosLBF | IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on Db2 for z/OS only. The data type of this property is int. Not set = 0, YES = 1, NO = 2. | Integer(0, 1, 2) | 0 |
| enableT2zosLBFSPResultSets | IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on Db2 for z/OS only. The data type of this property is int. Not set = 0, YES = 1, NO = 2. | Integer(0, 1, 2) | 0 |
| enableTimeoutOnCursor | Control how statement timeout values are applied to specific SQL operations. The data type of this property is int. | Boolean | false |
| extendedTableInfo | he extendedTableInfo property specifies whether information about extended table types is returned from a DatabaseMetaData.getTables method call. Not set = 0, YES = 1, NO = 2. | Integer(0, 1, 2) | - |
| fetchSize | Specifies the default fetch size for ResultSet objects that are generated from Statement objects. The data type of this property is int. | Integer | 0 |
| floatingPointStringFormat | Specifies the format for data that is retrieved from a DOUBLE, FLOAT, or REAL column with the ResultSet.getString method. The data type of this property is int. LUW_TYPE2_DRIVER_FLOATING_POINT_STRING_FORMAT (2), JCC_DRIVER_FLOATING_POINT_STRING_FORMAT (1), NOT_SET (0) | Integer(0, 1, 2) | 0 |
| fullyMaterializeInputStreams | If true, any Java InputStreams provided as parameters are fully read into memory before sending to the server. The data type of this property is Boolean. | Boolean | false |
| fullyMaterializeLobData | Indicates whether the driver retrieves LOB locators for FETCH operations. The data type of this property is boolean. | Boolean | false |
| gssCredential | Used to establish a connection using Kerberos security with a delegated credential. The data type of this property is Object. | String | - |
| implicitRollbackOption | Specifies the actions that the IBM Data Server Driver for JDBC and SQLJ takes when a transaction encounters a deadlock or a timeout. 1 = not close connection, 2 = close connection, 0 = not set (throws exception) | Integer (0, 1, 2) | 0 |
| interruptProcessingMode | Specifies the behavior of the IBM Data Server Driver for JDBC and SQLJ when an application executes the Statement.cancel method. 1 = graceful cancel, 2 = forceful closes. | Integer (1, 2) | 1 |
| jdbcCollection | Specifies the collection ID for the packages that are used by an instance of the IBM Data Server Driver for JDBC and SQLJ at run time. The data type of this property is String. | String | NULLID |
| keepAliveTimeOut | IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only. The KeepAliveTimeout keyword determines the number of seconds before the keepalive probes are sent as well as duration between probes. The data type of this property is int. | Integer | 15 |
| keepDynamic | Specifies if EnableKeepDynamic function is available to the various applications. The data type of this property is int. | Integer (0, 1) | 0 |
| kerberosServerPrincipal | The data type of this property is String. | String | - |
| keyUsage | IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only. The data type of this property is int. 0 = NOT_SET, 1 = digitalSignature, 2 = nonRepudiation, 4 = keyEncipherment, 8 = dataEncipherment, 16 = keyAgreement, 32 = keyCertSign, 64 = cRLSign, 128 = encipherOnly, 256 = decipherOnly. You can combine the preferred keyUsage constants by using numeric addition. | Integer (options in desc.) | 0 |
| loginTimeout | The maximum time in seconds to wait for a connection to a data source. After the number of seconds that are specified by loginTimeout have elapsed, the driver closes the connection to the data source. The data type of this property is int. The default is 0. A value of 0 means that the timeout value is the default system timeout value. This property is not supported for IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on DB2 for z/OS. | Integer | 0 (default system timeout) |
| logWriter | The character output stream to which all logging and trace messages for the DataSource object are printed. The data type of this property is java.io.PrinterWriter. The default value is null, which means that no logging or tracing for the DataSource is output. | java.io.PrinterWriter | - |
| maxConnCachedParamBufferSize | IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on Db2 for z/OS only. The data type of this property is int. | Integer | 1048576 (It is 1MB) |
| maxRetriesForClientReroute | During automatic client reroute, limit the number of retries if the primary connection to the data source fails. | Integer | 5 |
| maxStatements | Controls an internal statement cache that is associated with a Connection. The data type of this property is int. | Integer | 0 |
| maxRowsetSize | IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on Db2 for z/OS only. The data type of this property is int. | Integer | 32767 |
| maxTransportObjectIdleTime | time in sec., a connection stays idle in the pool before it is closed, until minTransportObject is reached. The data type of this property is int. | Integer | 60 |
| maxTransportObjectWaitTime | f maxTransportObjects is reached - time in sec., an application waits to get a connection before throwing a SQLException. The data type of this property is int. | Integer | 5 |
| maxTransportObjects | max # of connections to DB2 server from this DataSource. The data type of this property is int. | Integer | -1 (no limit) |
| memberConnectTimeout | IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only. The data type of this property is int. For Db2 for z/OS® servers, the default value is 1 second. | Integer | - / 1 (see desc.) |
| minTransportObjects | property in the IBM Data Server Driver for JDBC and SQLJ, specifies the lower limit for the number of transport objects in a global transport object pool. The data type of this property is int. | Integer | 0 |
| optimizationProfile | Specifies the name of an optimization profile to use for dynamic SQL, equivalent to setting the OPTIMIZATION PROFILE special register. The data type of this property is String. | String | - |
| optimizationProfileToFlush | Specifies the name of an optimization profile in the server’s cache to flush (remove). The data type of this property is String. | String | - |
| password | The password to use for establishing connections. The data type of this property is String. | String | - |
| pdqProperties | Specifies properties that control the interaction between the IBM Data Server Driver for JDBC and SQLJ and the client optimization feature of pureQuery. The data type of this property is String. | String | - |
| pkList | IBM Data Server Driver for JDBC and SQLJ type 2 connectivity only. The data type of this property is String. If you specify this property, do not specify planName. If pkList, planName, and db2.jcc.pkList are not specified, then the value of pkList is NULLID. | String | NULLID (see desc.) |
| planName | IBM Data Server Driver for JDBC and SQLJ type 2 connectivity only. The data type of this property is String. If you specify this property, do not specify pkList. If pkList, planName, and db2.jcc.planName are not specified, NULLID. is used as the package list for the underlying CREATE THREAD call. | String | NULLID (see desc.) |
| plugin | The name of a client-side JDBC security plug-in. The data type of this property is Object. | Object | - |
| pluginName | Name of the server-side security plugin to use. The data type of this property is String. | String | gss_dashdb_iam (depends on env) |
| portNumber | The port number where the DRDA® server is listening for requests. The data type of this property is int. | Integer | 446 / 448 |
| progressiveStreaming | Specifies whether the JDBC driver uses progressive streaming when progressive streaming is supported on the data source. | Integer (0, 1, 2) | 0 |
| queryCloseImplicit | Specifies whether cursors are closed immediately after all rows are fetched. queryCloseImplicit applies only to connections to IBM Data Server Driver for JDBC and SQLJ type 4 connectivity to DB2 for z/OS Version 8 or later, and IBM Data Server Driver for JDBC and SQLJ type 4 connectivity or IBM Data Server Driver for JDBC and SQLJ type 2 connectivityDB2 Database for Linux, UNIX, and Windows Version 9.7 or later. | Integer (0, 1, 2, 3) | 0 |
| queryDataSize | Specifies a hint that is used to control the amount of query data, in bytes, that is returned from the data source on each fetch operation. This value can be used to optimize the application by controlling the number of trips to the data source that are required to retrieve data. | Integer | 32767 |
| queryTimeoutInterruptProcessingMode | Specifies what happens when the query timeout interval for a Statement object expires. 1 = graceful cancel, 2 = forceful closes. | Integer (1, 2) | 1 |
| readOnly | Specifies whether the connection is read-only. The data type of this property is Boolean. | Boolean | false |
| reportLongTypes | Specifies whether DatabaseMetaData methods report LONG VARCHAR and LONG VARGRAPHIC column data types as long data types. The data type of this property is short. | Short (0, 1, 2) | 0 |
| resultSetHoldability | Specifies whether cursors remain open after a commit operation. The data type of this property is int. NOT_SET (0), HOLD_CURSORS_OVER_COMMIT (1), CLOSE_CURSORS_AT_COMMIT (2). | Integer (0, 1, 2) | 0 |
| resultSetHoldabilityForCatalogQueries | Specifies whether cursors for queries that are executed on behalf of DatabaseMetaData methods remain open after a commit operation. DB2BaseDataSource.HOLD_CURSORS_OVER_COMMIT (1)Leave cursors for catalog queries open after a commit operation, regardless of the resultSetHoldability setting.DB2BaseDataSource.CLOSE_CURSORS_AT_COMMIT (2)Close cursors for catalog queries after a commit operation, regardless of the resultSetHoldability setting. DB2BaseDataSource.NOT_SET (0) Use the resultSetHoldability setting for catalog queries. | Integer (0, 1, 2) | 0 |
| retrieveMessagesFromServerOnGetMessage | Specifies whether JDBC SQLException.getMessage or SQLWarning.getMessage calls cause the IBM Data Server Driver for JDBC and SQLJ to invoke a DB2 for z/OS stored procedure that retrieves the message text for the error. The data type of this property is boolean. The default is false, which means that the full message text is not returned to the client. | Boolean | false |
| retryIntervalForClientReroute | For automatic client reroute, specifies the amount of time in seconds between connection retries. | Positive Integer + unit of time (E.g. 1m30s) | - |
| retryWithAlternativeSecurityMechanism | IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only. The data type of this property is int. 1 = YES, 2 = NO. | Integer (1, 2) | - |
| returnAlias | Specifies whether the JDBC driver returns rows for table aliases and synonyms for DatabaseMetaData methods that return table information, such as getTables. The data type of this property is short | Integer (1, 2) | 1 |
| securityMechanism | Specifies the DRDA security mechanism. The data type of this property is int. 3 = CLEAR_TEXT_PASSWORD_SECURITY, 4 = USER_ONLY_SECURITY, 7 = ENCRYPTED_PASSWORD_SECURITY, 8 = STRONG_PASSWORD_SUBSTITUTE_SECURITY, 9 = ENCRYPTED_USER_AND_PASSWORD_SECURITY. | Integer (3, 4, 7, 8, 9) | 3 |
| sendCharInputsUTF8 | Specifies whether the IBM Data Server Driver for JDBC and SQLJ converts character input data to the CCSID of the Db2 for z/OS database server, or sends the data in UTF-8 encoding for conversion by the database server. The data type of this property is int. 1 = YES, 2 = NO. | Integer (1, 2) | - |
| sendDataAsIs | Specifies that the IBM Data Server Driver for JDBC and SQLJ does not convert input parameter values to the target column data types. The data type of this property is boolean. The default is false. | Boolean | - |
| serverName | The host name or the TCP/IP address of the data source. The data type of this property is String. | String | - |
| sessionTimeZone | Specifies the setting for the CURRENT SESSION TIME ZONE special register. The data type of this property is String. | String (-12:59 to +14:00) | - |
| sqljAvoidTimeStampConversion | Specifies whether the IBM Data Server Driver for JDBC and SQLJ prevents Java's adjustment of a timestamp value. The data type of this property is Boolean. | Boolean | false |
| sqljEnableClassLoaderSpecificProfiles | Specifies whether the IBM Data Server Driver for JDBC and SQLJ allows using and loading of SQLJ profiles with the same Java name in multiple J2EE application (.ear) files. The data type of this property is Boolean. | Boolean | - |
| ssid | IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on Db2 for z/OS only. The data type of this property is String. | String | - |
| sslCertLocation | IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only. The data type of this property is String. | String | - |
| sslCipherSuites | IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only. The data type of this property is String. | String | - |
| sslConnection | Specifies whether the IBM Data Server Driver for JDBC and SQLJ uses an SSL socket to connect to the data source. If sslConnection is set to true, the connection uses an SSL socket. If sslConnection is set to false, the connection uses a plain socket. The data type of this property is Boolean. | Boolean | - |
| sslKeyStoreLocation | IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only. The data type of this property is String. | String | - |
| sslKeyStorePassword | IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only. The data type of this property is String. | String | - |
| sslKeyStoreType | IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only. The data type of this property is String. | String | - |
| sslTrustStoreLocation | Specifies the name of the Java truststore on the client that contains the server certificate for an SSL connection. The data type of this property is String. | String | - |
| sslTrustStorePassword | Specifies the password for the Java truststore on the client that contains the server certificate for an SSL connection. The data type of this property is String. | String | - |
| sslTrustStoreType | IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only. The data type of this property is String. | String | - |
| sslVersion | IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only. The data type of this property is int. | String (E.g. TLSv1.3) | - |
| statementConcentrator | Specifies whether the IBM Data Server Driver for JDBC and SQLJ uses the data source's statement concentrator functionality. The data type of this property is int. 1 = STATEMENT_CONCENTRATOR_OFF, 2 = STATEMENT_CONCENTRATOR_WITH_LITERALS. | (1, 2) | - |
| streamBufferSize | Specifies the size, in bytes, of the JDBC driver buffers for chunking LOB or XML data. The JDBC driver uses the streamBufferSize value whether or not it uses progressive streaming. The data type of this property is int. | Integer | 1048576 (1MB) |
| stripTrailingZerosForDecimalNumbers | Specifies whether the IBM Data Server Driver for JDBC and SQLJ removes trailing zeroes when it retrieves data from a DECFLOAT, DECIMAL, or NUMERIC column. This property is meaningful only if the SDK for Java is Version 1.5 or later. The data type of this property is int. | (1 (yes), 2 (no)) | - |
| supportsAsynchronousXARollback | Specifies whether the IBM Data Server Driver for JDBC and SQLJ supports asynchronous XA rollback operations. The data type of this property is int. 1 = YES, 2 = NO. | Integer | 2 |
| sysSchema | Specifies the schema of the shadow catalog tables or views that are searched when an application invokes a DatabaseMetaData method. The data type of this property is String. | String | - |
| timerLevelForQueryTimeOut | Specifies the level at which the IBM Data Server Driver for JDBC and SQLJ creates a java.util.Timer object for waiting for query execution to time out. -1 = QUERYTIMEOUT_DISABLED, 1 = QUERYTIMEOUT_STATEMENT_LEVEL, 2 = QUERYTIMEOUT_CONNECTION_LEVEL | (-1, 1, 2) | - |
| timeFormat | Specifies: The format in which the String argument of the PreparedStatement.setString method against a TIME column must be specified. The format in which the result of the ResultSet.getString or CallableStatement.getString method against a TIME column is returned. The data type of this property is int. Timeformat: 1 = ISO, 2 = USA, 3 = EUR, 4 = JIS. | (1, 2, 3, 4) | - |
| timestampFormat | Specifies the format in which the result of the ResultSet.getString or CallableStatement.getString method against a TIMESTAMP column is returned. | String | - |
| timestampOutputType | Determines the Java type used when retrieving TIMESTAMPs via standard getters. The data type of this property is int. 1 = JDBC_TIMESTAMP, 2 = JCC_DBTIMESTAMP | Integer (1, 2) | - |
| timestampPrecisionReporting | Specifies whether trailing zeroes are truncated in the result of a Resultset.getString call for a TIMESTAMP value. The data type of this property is int. 1 = TIMESTAMP_JDBC_STANDARD, 2 = TIMESTAMP_ZERO_PADDING. | Integer (1, 2) | - |
| traceDirectory | Specifies a directory into which trace information is written. The data type of this property is String. When traceDirectory is specified, trace information for multiple connections on the same DataSource is written to multiple files. | String | - |
| traceFile | Specifies the name of a file into which the IBM Data Server Driver for JDBC and SQLJ writes trace information. The data type of this property is String. The traceFile property is an alternative to the logWriter property for directing the output trace stream to a file. | String | - |
| traceFileAppend | Specifies whether to append to or overwrite the file that is specified by the traceFile property. The data type of this property is boolean. The default is false, which means that the file that is specified by the traceFile property is overwritten. | Boolean | - |
| traceFileCount | Specifies the maximum number of trace files for circular tracing. The IBM Data Server Driver for JDBC and SQLJ uses this property only when traceOption is set to DB2BaseDataSource.TRACE_OPTION_CIRCULAR (1). The data type of this property is int. The default value is 2. | Integer | - |
| traceFileSize | Specifies the maximum size of each trace file, for circular tracing. The IBM Data Server Driver for JDBC and SQLJ uses this property only when traceOption is set to DB2BaseDataSource.TRACE_OPTION_CIRCULAR (1). The data type of this property is int. The default value is 10485760 (10 MB). | Integer | - |
| traceLevel | Specifies what to trace. The data type of this property is int. | Integer | - |
| traceOption | Specifies the way in which trace data is collected. The data type of this property is int. | String (0, 1) | - |
| useCachedCursor | Specifies whether the underlying cursor for PreparedStatement objects is cached and reused on subsequent executions of the PreparedStatement. The data type of this property is Boolean. | Boolean | - |
| useJDBC4ColumnNameAndLabelSemantics | Specifies how the IBM Data Server Driver for JDBC and SQLJ handles column labels in ResultSetMetaData.getColumnName, ResultSetMetaData.getColumnLabel, and ResultSet.findColumn method calls. The data type of this property is int. | (1 (yes), 2 (no)) | - |
| useJDBC41DefinitionForGetColumns | Specifies whether the DatabaseMetaData.getColumns method returns a result set with a column with the name SCOPE_CATALOG or SCOPE_CATLOG. | (1 (yes), 2 (no)) | - |
| user | The user ID to use for establishing connections. | String | - |
| useIdentityValLocalForAutoGeneratedKeys | Specifies whether the IBM Data Server Driver for JDBC and SQLJ uses only the SQL built-in function IDENTITY_VAL_LOCAL to determine automatically generated key values. The data type of this property is Boolean. | Boolean | - |
| useRowsetCursor | Specifies whether the IBM Data Server Driver for JDBC and SQLJ always uses multiple-row FETCH for scrollable cursors if the data source supports multiple-row FETCH. The data type of this property is Boolean. | Boolean | - |
| useTransactionRedirect | Specifies whether the DB2 system directs SQL statements to different database partitions for better performance. The data type of this property is Boolean. | Boolean | - |
| xaNetworkOptimization | Specifies whether XA network optimization is enabled for IBM Data Server Driver for JDBC and SQLJ type 4 connectivity. You might need to disable XA network optimization in an environment in which an XA Start and XA End are issued from one Java process, and an XA Prepare and an XA Commit are issued from another Java process. With XA network optimization, the XA Prepare can reach the data source before the XA End, which results in an XAER_PROTO error. To prevent the XAER_PROTO error, disable XA network optimization. | Boolean | true |
| xmlFormat | The data type of this property is int. XML_FORMAT_TEXTUAL = 0, XML_FORMAT_BINARY = 1. | (0, 1) | |
| DBANSIWARN | Specifies whether the IBM Data Server Driver for JDBC and SQLJ instructs the IBM Informix database to return an SQLWarning to the application if an SQL statement does not use ANSI-standard syntax. | Boolean (false and 0, true and 1) | false |
| DBDATE | Specifies the end-user format of DATE values. | String | Y4MD- |
| DBPATH | Specifies a colon-separated list of values that identify the database servers that contain databases. | String | . |
| DBSPACETEMP | Specifies a comma-separated or colon-separated list of existing dbspaces in which temporary tables are placed | String | - |
| DBTEMP | Specifies the full path name of an existing directory in which temporary files and temporary tables are placed. | String | /tmp |
| DBUPSPACE | Specifies the maximum amount of system disk space and maximum amount of memory, in kilobytes, that the UPDATE STATISTICS statement can use when it constructs multiple column distributions simultaneously. The format of DBUPSPACE is "maximum-disk-space:maximum-memory". | String | - |
| DELIMIDENT | Specifies whether delimited SQL identifiers can be used in an application. | Boolean | false |
| IFX_DIRECTIVES | Specifies whether the optimizer allows query optimization directives from within a query. | String (1 or on, 0 or off) | - |
| IFX_EXTDIRECTIVES | Specifies whether the optimizer allows external query optimization directives from the sysdirectives system catalog table to be applied to queries in existing applications. Possible values are: | String (1 or on, 0 or off) | - |
| IFX_UPDDESC | Specifies whether a DESCRIBE of an UPDATE statement is permitted. Any non-null value indicates that a DESCRIBE of an UPDATE statement is permitted. | String | 1 |
| IFX_XASTDCOMPLIANCE_XAEND | Specifies whether global transactions are freed only after an explicit rollback, or after any rollback. | String (0, 1) | - |
| INFORMIXOPCACHE | Specifies the size of the memory cache, in kilobytes, for the staging-area blobspace of the client application. The data type of this property is String. A value of "0" indicates that the cache is not used. | String | - |
| INFORMIXSTACKSIZE | Specifies the stack size, in kilobytes, that the database server uses for the primary thread of a client session. | String | - |
| NODEFDAC | Specifies whether the database server prevents default table privileges (SELECT, INSERT, UPDATE, and DELETE) from being granted to PUBLIC when a new table is created during the current session, in a database that is not ANSI compliant. | String (yes, no) | no |
| OPTCOMPIND | Specifies the preferred method for performing a join operation on an ordered pair of tables. The data type of this property is String. | Integer (0, 1, 2) | 2 |
| OPTOFC | Use the OPTOFC environment variable to enable optimize-OPEN-FETCH-CLOSE functionality in IBM® Informix® ESQL/C applications or other APIs (such as JDBC, ODBC, OLE DB, LIBDMI, and Lib C++) that use DECLARE and OPEN statements to establish a cursor. | String (0, 1) | 0 |
| PDQPRIORITY | The PDQPRIORITY environment variable determines the degree of parallelism that the database server uses and affects how the database server allocates resources, including memory, processors, and disk reads. | String | - |
| PSORT_DBTEMP | The PSORT_DBTEMP environment variable specifies the location where the database server writes the temporary files that the PSORT_NPROCS environment variable uses to perform a sort. | String | - |
| PSORT_NPROCS | The PSORT_NPROCS environment variable enables the database server to improve the performance of the parallel-process sorting package by allocating more threads for sorting | String (Max: 10) | - |
| STMT_CACHE | JDBC driver property: STMT_CACHE. | String | - |
| beginTranForResultSetScrollingAPIs | Attempt transaction enlistment when result set scrolling interfaces are used. | Boolean | true |
| beginTranForVendorAPIs | Attempt transaction enlistment when vendor interfaces are used. | Boolean | true |
| connectionSharing | Specifies how connections are matched for sharing. | String (MatchCurrentState, MatchOriginalRequest) | MatchOriginalRequest |
| enableClientInformation | ... | ||
| propagateClientIdentityUsingTrustedContext | ... |