AddToCreateTable

OPTIONAL

A string that is automatically added to all Create Table statements. This field is primarily for users who need to add an 'in database' clause.

AllowImplicitResultSetCloseForXA

OPTIONAL

{true | false}. DB2 provides a mechanism that automatically closes a result set when all rows of the result set have been fetched. This mechanism increases application performance by reducing the number of database round trips. The WebLogic DB2 driver uses this mechanism by default.

Note: Problems have been noted when using this mechanism. As a workaround, you should add AllowImplicitResultSetCloseForXA=false to the properties in your data source configuration.

The default is true.

AlternateID

OPTIONAL

Sets the default DB2 schema used by unqualified SQL identifiers to the specified value. The value must be a valid DB2 schema.

BatchPerformanceWorkaround

OPTIONAL

{true | false}. For DB2 UDB 8.1, the native DB2 batch mechanism is used. This property determines whether certain restrictions are enforced to facilitate data conversions.

• When set to false, the methods used to set the parameter values of a batch operation performed using a PreparedStatement must match the database data type of the column the parameter is associated with. This is because DB2 servers do not perform implicit data conversions.

• When set to true, this restriction is removed; however, parameter sets may not be executed in the order they were specified.

The default is false.

See Performance Workaround for Batch Inserts and Updates for more information.

Note: For data sources used as a JMS JDBC store that use the WebLogic Type 4 JDBC driver for DB2, the BatchPerformanceWorkaround property must be set to true.

CatalogIncludesSynonyms

OPTIONAL

{true | false}. When set to true, synonyms are included in the result sets returned from the following DatabaseMetaData methods: getColumns, getProcedureColumns, and getIndexInfo. When set to false, synonyms are omitted from result sets.

The default is true.

CatalogSchema

OPTIONAL

The DB2 schema to use for catalog functions. The value must be the name of a valid DB2 schema.

The default is SYSCAT for DB2 UDB, SYSIBM for DB2 OS/390, and QSYS2 for DB2 iSeries.

To improve performance, views of system catalog tables can be created in a schema other than the default catalog schema. Setting this property to a schema that contains views of the catalog tables allows the driver to use those views. To ensure that catalog methods function correctly, views for specific catalog tables must exist in the specified schema. The views that are required depend on your DB2 database. See Using a Non-Default Schema for Catalog Methods for the required views of catalog tables.

CharsetFor65535

OPTIONAL

The code page to use to convert character data stored as bit data in character columns (Char, Varchar, Longvarchar, Char for Bit Data, Varchar for Bit Data, Longvarchar for Bit Data) defined with CCSID 65535. All character data stored as bit data retrieved from the database using columns defined with CCSID 65535 is converted using the specified code page. The value must be a string containing the name of a valid code page supported by your Java Virtual Machine, for example, CharsetFor65535=CP950. This property has no effect when writing data to character columns defined with CCSID 65535.

CodePageOverride

OPTIONAL

A code page to be used to convert Character and Clob data. The specified code page overrides the default database code page. All Character and Clob data retrieved from or written to the database is converted using the specified code page. The value must be a string containing the name of a valid code page supported by your Java Virtual Machine, for example, CodePageOverride=CP950.

CollectionId

OPTIONAL

The collection (group of packages) to which the package is bound.

This property is ignored for DB2 UDB.

The default is NULLID.

ConnectionRetryCount

OPTIONAL

The number of times the driver retries connection attempts until a successful connection is established. Valid values are 0 and any positive integer.

If set to 0, the driver does not retry connections if a successful connection is not established on the driver's first attempt to create a connection.

The default is 0.

ConnectionRetryDelay

OPTIONAL

The number of seconds the driver will wait between connection retry attempts when ConnectionRetryCount is set to a positive integer.

The default is 3.

CreateDefaultPackage

OPTIONAL

{true | false}. Determines whether the default package should be created. For DB2 OS/390 and DB2 iSeries, the package is created in the collection specified by the CollectionId property. This would be used if the package does not yet exist.

For more information about creating DB2 packages, see Creating a DB2 Package.

The default is false.

DatabaseName

The name of the database to which you want to connect (used with UDB).

DynamicSections

OPTIONAL

Specifies the number of statements that the DB2 driver package can prepare for a single user.

The default is 200.

Grantee

OPTIONAL

Specifies the name of the schema to which you want to grant EXECUTE privileges for DB2 packages. This property is ignored if the GrantExecute property is set to false.

See Creating a DB2 Package for more information about creating DB2 packages.

The default is PUBLIC.

GrantExecute

OPTIONAL

{true | false}. Determines whether EXECUTE privileges for DB2 packages are granted to a schema other than the one used to create them. If set to true, EXECUTE privileges are granted to the schema specified by the Grantee property. If set to false, EXECUTE privileges are not granted to another schema.

See Creating a DB2 Package for more information about creating DB2 packages.

The default is true.

InsensitiveResultSetBufferSize

{-1 | 0 | x}. Determines the amount of memory used by the driver to cache insensitive result set data. It must have one of the following values:

If set to -1, the driver caches all insensitive result set data in memory. If the size of the result set exceeds available memory, an OutOfMemoryException is generated. Because the need to write result set data to disk is eliminated, the driver processes the data more efficiently.

If set to 0, the driver caches all insensitive result set data in memory, up to a maximum of 2 GB. If the size of the result set data exceeds available memory, the driver pages the result set data to disk. Because result set data may be written to disk, the driver may have to reformat the data to write it correctly to disk.

If set to x, where x is a positive integer that specifies the size (in KB) of the memory buffer used to cache insensitive result set data. If the size of the result set data exceeds the buffer size, the driver pages the result set data to disk. Because the result set data may be written to disk, the driver may have to reformat the data to write it correctly to disk. Specifying a buffer size that is a power of 2 results in more efficient memory use.

The default is 2048 (KB)

LocationName

The name of the DB2 location that you want to access (used with OS/390 and iSeries).

LoginTimeout

OPTIONAL

The maximum time in seconds that attempts to create a database connection will wait. A value of 0 specifies that the timeout is the default system timeout if there is one; otherwise it specifies that there is no timeout.

PackageOwner

OPTIONAL

Specifies the owner of DB2 packages.

See Creating a DB2 Package for more information about creating DB2 packages.

The default is NULL.

Password

A case-sensitive password used to connect to your DB2 database. A password is required only if security is enabled on your database. If so, contact your system administrator to get your password.

PortNumber

OPTIONAL

The TCP port on which the database server listens for connections. The default is 50000.

ReplacePackage

OPTIONAL

{true | false}. Specifies whether the current bind process should replace an existing DB2 package. On DB2 UDB, this property must be used in conjunction with CreateDefaultPackage.

For more information about creating DB2 packages, see Creating a DB2 Package.

The default is false.

SecurityMechanism

OPTIONAL

{ClearText | EncryptedPassword | EncryptedUIDPassword}. Determines the security method the driver uses to authenticate the user to the DB2 server when establishing a connection. If the specified authentication method is not supported by the DB2 server, the connection fails and the driver generates an exception.

If set to ClearText, the driver sends the password in clear text to the DB2 server for authentication.

If set to EncryptedPassword, the driver sends an encrypted password to the DB2 server for authentication.

If set to EncryptedUIDPassword, the driver sends an encrypted user ID and password to the DB2 server for authentication.

The default is ClearText.

Requires JDK 1.4 or higher.

SendStreamAsBlob

OPTIONAL

{true | false}. Determines whether binary stream data that is less than 32K bytes is sent to the database as Long Varchar for Bit Data or Blob data. Binary stream data that is less than 32K bytes can be inserted into a Long Varchar for Bit Data column, which has a maximum length of 32K bytes, or a Blob column. Binary streams that are larger than 32K bytes can only be inserted into a Blob column. The driver always sends binary stream data larger than 32K bytes to the database as Blob data.

If set to true, the driver sends binary stream data that is less than 32K to the database as Blob data. If the target column is a Long Varchar for Bit Data column and not a Blob column, the Insert or Update statement fails. The driver automatically retries the Insert or Update statement, sending the data as Long Varchar for Bit Data, if the stream passed into the driver is resettable. Sending binary stream data that is less than 32K bytes in length initially as a Blob significantly improves performance if the Insert or Update column is a Blob column.

If set to false, the driver sends binary stream data that is less than 32K to the database as Long Varchar for Bit Data data. If the target column is a Blob column and not a Long Varchar for Bit Data column, the Insert or Update statement fails. The driver retries the Insert or Update statement, sending the data as Blob data.

The default is false.

ServerName

The name or IP address of the database server.

StripNewlines

OPTIONAL

{true | false}. Specifies whether new-line characters in a SQL statement are sent to the DB2 server. When StripNewlines=true, the DB2 driver removes all new-line characters from SQL statements.

The default is true.

UseCurrentSchema

OPTIONAL

{true | false}. Specifies whether results are restricted to the tables in the current schema if a DatabaseMetaData.getTables call is called without specifying a schema or if the schema is specified as the wildcard character %. Restricting results to the tables in the current schema improves the performance of calls for getTables methods that do not specify a schema.

If set to true, results that are returned from the getTables method are restricted to tables in the current schema. If set to false, results of the getTables method are not restricted.

The default is false.

User

The case-sensitive user name used to connect to your DB2 database.

WithHoldCursors

OPTIONAL

{true | false}. Determines whether the cursor stays open on commit—either DB2 closes all open cursors (Delete cursors) after a commit or leaves them open (Preserve cursors). If set to true, the cursor behavior is Preserve. If set to false, the cursor behavior is Delete. Rolling back a transaction closes all cursors regardless of how this property is specified.

The default is true.

CollectionId=collection_name
(where collection_name is the name of the collection or library to which DB2 packages are bound)

DB2 OS/390 and iSeries

CreateDefaultPackage=true

DB2 UDB, OS/390, and iSeries

ReplacePackage=true

DB2 UDB

DynamicSections=x
(where x is a positive integer)

DB2 UDB, OS/390, and iSeries

Bigint¹

BIGINT

Blob²

BLOB

Char

CHAR

Char for Bit Data

BINARY

Clob

CLOB

Date

DATE

DBClob³

CLOB

Decimal

DECIMAL

Double

DOUBLE

Float

FLOAT

Integer

INTEGER

Long Varchar

LONGVARCHAR

Long Varchar for Bit Data

LONGVARBINARY

Numeric

NUMERIC

Real

REAL

Rowid⁴

VARBINARY

Smallint

SMALLINT

Time

TIME

Timestamp

TIMESTAMP

Varchar

VARCHAR

Varchar for Bit Data

VARBINARY

DB2 UDB

SYSCAT.TABLES
SYSCAT.COLUMNS
SYSCAT.PROCEDURES
SYSCAT.PROCPARAMS
SYSCAT.COLAUTH
SYSCAT.TABAUTH
SYSCAT.KEYCOLUSE
SYSCAT.INDEXES
SYSCAT.INDEXCOLUSE
SYSCAT.REFERENCES
SYSCAT.SYSSCHEMATA
SYSCAT.TYPEMAPPINGS
SYSCAT.DBAUTH

DB2 OS/390

SYSIBM.SYSTABCONST
SYSIBM.SYSTABLES
SYSIBM.SYSSYNONYMS
SYSIBM.SYSCOLUMNS
SYSIBM.SYSPROCEDURES
SYSIBM.SYSROUTINES
SYSIBM.SYSPARMS
SYSIBM.SYSCOLAUTH
SYSIBM.SYSTABAUTH
SYSIBM.SYSKEYS
SYSIBM.SYSINDEXES
SYSIBM.SYSRELS
SYSIBM.SYSFOREIGNKEYS
SYSIBM.SYSSCHEMAAUTH
SYSIBM.SYSDBAUTH

DB2 iSeries

QSYS2.SYSCST
QSYS2.SYSKEYCST
QSYS2.SYSPROCS
QSYS2.SYSPARMS
QSYS2.SYSTABLES
QSYS2.SYSSYNONYMS
QSYS2.SYSCOLUMNS
QSYS2.SQLTABLEPRIVILEGES
QSYS2.SYSKEYS
QSYS2.SYSINDEXES
QSYS2.SYSREFCST

JDBC Isolation Level

DB2 Isolation Level

None

No Commit¹

Read Committed

Cursor Stability

Read Uncommitted

Uncommitted Read

Repeatable Read

Read Stability

Serializable

Repeatable Read

Server Version

Driver Version

Pre 3.4.72

3.4.72 or higher

Pre 3.5.14

3.5.14 or higher

Pre-DB2 v8 FP11

Unavailable/Not required

May need to be used

Unavailable/Not required

May need to be used

DB2 v8 FP11 or higher

Unavailable/Not required

Do not use

Unavailable/Not required

Do not use

Accounting information to be stored in the database. This value sets the CURRENT CLIENT_ACCTNG register (DB2 for Linux/UNIX/Windows) or the CLIENT ACCTNG register (DB2 for z/OS and DB2 for iSeries) in the database.This value is for database administration/monitoring purposes

Data Type: String

Valid Values: string where string is the accounting information. The default value is an empty string.

A string that is appended to the end of all CREATE statements. This field is primarily for users who need to add an 'in database' clause.

Data Type: String

Valid Values: string where string is the set of characters appended to all CREATE statements.

True or false. DB2 provides a mechanism that automatically closes a result set when all rows of the result set have been fetched. This mechanism increases application performance by reducing the number of database round trips. The WebLogic DB2 driver uses this mechanism by default.

Note: Problems have been noted when using this mechanism. As a workaround, you should add AllowImplicitResultSetCloseForXA=false to the properties in your data source configuration.

The default is true.

Sets the default DB2 schema used by unqualified SQL identifiers to the specified value.

For DB2 for Linux/UNIX/Windows and DB2 for iSeries, this property sets the value in the DB2 CURRENT SCHEMA special register.

For DB2 for z/OS, this property sets the value in the DB2 CURRENT SQLID special register.

Valid Values:

• For DB2 for Linux/UNIX/Windows and DB2 for iSeries, a valid DB2 schema name. This value is not validated by the database server.

• For DB2 for z/OS, this value is validated by the database server. Refer to your IBM documentation for valid values for the CURRENT SQLID register.

A list of alternate database servers that is used to failover new or lost connections, depending on the failover method selected. See the FailoverMode property for information about choosing a failover method.

Data type: String

Valid Values:

(servername1[:port1][;property=value[;...]

,servername2[:port2][;property=value[;...]]]...]

The server name (servername1, servername2, and so on) is required for each alternate server entry. Port number (port1, port2, and so on) and connection properties (property=value) are optional for each alternate server entry. If the port is unspecified, the port number of the primary server is used. If the port number of the primary server is unspecified, the default port number of 2003 is used. Optional connection properties are DatabaseName and InformixServer.

Example: The following URL contains alternate server entries for server2 and server3. The alternate server entries contain the optional DatabaseName property.

jdbc:weblogic:db2://server1:50000;DatabaseName=TEST; User=test;Password=secret;AlternateServers=(server2:50000; DatabaseName=TEST2,server3:50000;DatabaseName=TEST3)

Default: None

The name of the application to be stored in the database. This value sets the CURRENT CLIENT_APPLNAME register (DB2 for Linux/UNIX/Windows) or CLIENT APPLNAME register (DB2 for z/OS and DB2 for iSeries) in the database. For DB2 V9.1 and higher for Linux/UNIX/Windows, this value also sets the APPL_NAME value of the SYSIBMADM.APPLICATIONS table. These values are used for database administration/monitoring purposes.

Valid Values: string where string is the name of the application. Your database may impose character length restrictions on the value. If the value exceeds a restriction, the driver truncates it.

Data Type: String

Default is empty string.

Determines which authentication method the driver uses when establishing a connection.

Valid Values: Kerberos, encryptedUIDPassword, encryptedPassword, clearText , or client.

If kerberos, the driver uses Kerberos authentication. The driver ignores any user ID or password specified.

If encryptedUIDPassword, the driver uses user ID/password authentication. The driver sends an encrypted user ID and password to the DB2 server for authentication. If a user ID and password are not specified, the driver throws an exception. If this value is set, the driver can also use data encryption (see the EncryptionMethod property for details).

If encryptedPassword, the driver uses user ID/password authentication. The driver sends a user ID in clear text and an encrypted password to the DB2 server for authentication. If a user ID and password are not specified, the driver throws an exception. If this value is set, the driver can also use data encryption (see the EncryptionMethod property for details).

If set to clearText (the default), the driver uses user ID/password authentication. The driver sends the user ID and password in clear text to the DB2 server for authentication. If a user ID and password are not specified, the driver throws an exception. If this value is set, the driver can also use data encryption (see the EncryptionMethod property for details).

If client, the driver uses client authentication. The DB2 server relies on the client to authenticate the user and does not provide additional authentication. The driver ignores any user ID or password specified.

The User property provides the user ID. The Password property provides the password.

If the specified authentication method is not supported by the DB2 server, the connection fails and the driver throws an exception.

The default is clearText.

See Authentication for more information about using authentication with the DB2 driver.

The DB2 driver uses the native DB2 batch mechanism. This property determines whether certain restrictions are enforced to facilitate data conversions.

Valid Values: true | false

• When set to false, the methods used to set the parameter values of a batch operation performed using a PreparedStatement must match the database data type of the column the parameter is associated with. This is because DB2 servers do not perform implicit data conversions.

• When set to true, restrictions are removed; however, parameter sets may not be executed in the order they were specified.

The default is false.

See Batch Inserts and Updates for more information.

Note: For data sources used as a JMS JDBC store that use the Oracle Type 4 JDBC driver for DB2, the BatchPerformanceWorkaround property must be set to true.

Provides a suggestion to the driver for the number of rows to load to the database at a time when bulk loading data. Performance can be improved by increasing the number of rows the driver loads at a time because fewer network round trips are required. Be aware that increasing the number of rows that are loaded also causes the driver to consume more memory on the client.

NOTES:

• This property suggests the number of rows regardless of which bulk load method is used: using a DDBulkLoad object or using bulk load for batch inserts.

• The DDBulkObject.setBatchSize() method overrides the value set by this property.

Valid Values: x where x is a positive integer. The default is 2048.

Data Type: long

Determines whether synonyms are included in the result sets returned from the DatabaseMetaData.getColumns() method.

Data Type: True or false.

If set to true (the default), synonyms are included in the result sets returned from the DatabaseMetaData.getColumns() method.

If set to false, synonyms are omitted from result sets returned from the DatabaseMetaData.getColumns() method.

See Performance Considerations for information about configuring this property for optimal performance.

The default is true.

Determines which type of metadata information is included in result sets when an application calls DatabaseMetaData methods.

Valid Values: 0 | 2 | 6 and the default value is 2.

Data Type: int

If 0, result sets do not contain synonyms.

If 2, result sets contain synonyms that are returned from the following DatabaseMetaData methods: getColumns(), getExportedKeys(), getFunctionColumns(), getFunctions(), getImportedKeys(), getIndexInfo(), getPrimaryKeys(), getProcedureColumns(), and getProcedures().

If 6, a hint is provided to the driver to emulate getColumns() calls using the ResultSetMetaData object instead of querying database catalogs for column information. Result sets contain synonyms. Using emulation can improve performance because the SQL statement that is formulated by the emulation is less complex than the SQL statement that is formulated using getColumns(). The argument to getColumns() must evaluate to a single table. If it does not, because of a wildcard or null value, for example, the driver reverts to the default behavior for getColumns() calls.

The DB2 schema to use for catalog functions. The value must be the name of a valid DB2 schema. The default depends on the platform of the DB2 database.

Valid Values: string where string is the name of a valid DB2 schema. The default is SYSCAT (DB2 for Linux/UNIX/Windows); SYSIBM (DB2 for z/OS); or QSYS2 (DB2 for iSeries).

Data Type: String

To improve performance, views of system catalog tables can be created in a schema other than the default catalog schema. Setting this property to a schema that contains views of the catalog tables allows the driver to use those views. To ensure that catalog methods function correctly, views for specific catalog tables must exist in the specified schema. The views that are required depend on your DB2 database. See Non-Default Schemas for Catalog Methods for the required views of catalog tables.

See Performance Considerations for information about configuring this property for optimal performance.

The code page to use to convert character data stored as bit data in character columns (Char, Varchar, Longvarchar, Char for Bit Data, Varchar for Bit Data, Longvarchar for Bit Data) defined with CCSID 65535. All character data stored as bit data retrieved from the database using columns defined with CCSID 65535 is converted using the specified code page. The value must be a string containing the name of a valid code page supported by your JVM, for example, CharsetFor65535=CP950. This property has no effect when writing data to character columns defined with CCSID 65535.

The host name of the client machine to be stored in the database. This value sets the CURRENT CLIENT_WRKSTNNAME register (DB2 for Linux/UNIX/Windows) or CLIENT WRKSTNNAME register (DB2 for z/OS and DB2 for iSeries) in the database. This value is used for database administration/monitoring purposes.

Valid Values: string where string is the host name of the client machine. Your database may impose character length restrictions on the value that is set by this property. If the value exceeds a restriction, the driver truncates it. Default is empty string.

Data Type: String

The user ID to be stored in the database. This property sets the CURRENT CLIENT_USERID register (DB2 for Linux/UNIX/Windows) and CLIENT USERID register (DB2 for z/OS and DB2 for iSeries) in the database. This value is used for database administration/monitoring purposes.

Valid Values: string where string is a valid user ID. Your database may impose character length restrictions on the value that is set by this property. If the value exceeds a restriction, the driver truncates it. Default is empty string.

Data Type: String

A code page to be used to convert Character and Clob data. The specified code page overrides the default database code page or column collation. All Character and Clob data retrieved from or written to the database is converted using the specified code page. The value must be a string containing the name of a valid code page supported by your JVM, for example, CodePageOverride=CP950.

Data Type: String

By default, the driver automatically determines which code page to use to convert Character data. Use this property only if you need to change the driver's default behavior.

This property is recognized for backward compatibility, but we recommend that you use the PackageCollection property instead to specify the name of the collection or library (group of packages) to which DB2 packages are bound.

The number of times the driver retries connection attempts until a successful connection is established.

Valid Values: 0 | x where x is any postive integer.

Data Type: int

If 0, the driver does not retry connections if a successful connection is not established on the driver's first attempt to create a connection.

If set to x, the driver retries connection attempts the specified number of times. If a connection is not established during the retry attempts, the driver returns an exception that is generated by the last database server to which it tried to connect.

The ConnectionRetryDelay property specifies the wait interval, in seconds, used between retry attempts.

The default is 5.

The number of seconds the driver waits between connection retry attempts when ConnectionRetryCount is set to a positive integer.

Valid Values: 0 | x where x is a number of seconds.

If 0, the driver does not delay between retries.

If x, the driver waits between connection retry attempts the specified number of seconds.

The default is 1.

Controls how data conversions are handled for null values.

Valid Values: 0 | 1

Data Type: int

If 0, the driver does not perform the data type check if the value of the column is null. This allows null values to be returned even though a conversion between the requested type and the column type is undefined.

If 1 (the default), the driver checks the data type being requested against the data type of the table column storing the data. If a conversion between the requested type and column type is not defined, the driver generates an 'unsupported data conversion' exception regardless of the data type of the column value.

Determines whether the driver automatically creates required DB2 packages.

Valid Values: true | false

If true, the DB2 driver automatically creates required DB2 packages, even if they already exist. Existing DB2 packages are replaced by the new packages.

If false (the default), the driver determines if the required DB2 packages exist. If they do not, the driver automatically creates them.

For DB2 for Linux/UNIX/Windows, this property must be used in conjunction with the ReplacePackage property.

For DB2 for z/OS and DB2 for iSeries, DB2 packages are created in the collection or library specified by the PackageCollection property.

For more information about creating DB2 packages, see Creating a DB2 Package.

A list of DB2 schema names that are used to resolve unqualified function names and data type references in dynamically prepared SQL statements. It also is used to resolve unqualified stored procedure names that are specified in CALL statements. This property sets the CURRENT PATH register in the database.

Valid Values: schema_name[[,schema_name]...] where schema_name is a valid DB2 schema name.

Data Type: String

Default is null.

An alias for the DatabaseName property.

The name of the database to which you want to connect. This property is supported only for DB2 for Linux/UNIX/Windows.

Note: This property is an alias for LocationName when connecting to DB2 for z/OS or iSeries.

Valid Values: string where string is the name of a DB2 database. Default is None.

Data Type: StringAlias: Database property. If both the Database and DatabaseName properties are specified in a connection URL, the last property that is positioned in the connection URL is used. For example, if your application specifies the following connection URL, the value of the Database connection property would be used instead of the value of the DatabaseName connection property.

jdbc:weblogic:db2://server1:50000;DatabaseName=jdbc; Database=acct;User=test;Password=secret

See also Database Connection Property.

The maximum number of prepared statements that the DB2 driver can have open at any time. The value must be a positive integer.

The default is 200.

Specifies whether the driver uses the native bulk load protocols in the database instead of the batch mechanism for batch inserts. Bulk load bypasses the data parsing that is usually done by the database, providing an additional performance gain over batch operations. This property allows existing applications with batch inserts to take advantage of bulk load without requiring changes to the application code.

Valid Values: true | false

If true, the driver uses the native bulk load protocols for batch inserts. Any value set for BatchPerformanceWorkaround is ignored.

If false, the driver uses the batch mechanism for batch inserts.

Data Type: boolean

Default is false.

Determines whether a cancel request sent by the driver as the result of a query timing out is subject to the same query timeout value as the statement it cancels.

Valid Values: true | false

Data Type: boolean

If true, the cancel request times out using the same timeout value, in seconds, that is set for the statement it cancels. For example, if your application calls Statement.setQueryTimeout(5) on a statement and that statement is cancelled because its timeout value was exceeded, the driver sends a cancel request that also will time out if its execution exceeds 5 seconds. If the cancel request times out, because the server is down, for example, the driver throws an exception indicating that the cancel request was timed out and the connection is no longer valid.

If false (the default), the cancel request does not time out.

Determines whether data is encrypted and decrypted when transmitted over the network between the driver and database server.

NOTE: Connection hangs can occur when the driver is configured for SSL and the database server does not support SSL. You may want to set a login timeout using the LoginTimeout property to avoid problems when connecting to a server that does not support SSL.

Valid Values: noEncryption | DBEncryption | requestDBEncryption| SSL

If noEncryption, data is not encrypted or decrypted.

If DBEncryption, data is encrypted using DES encryption if the database server supports it. If the database server does not support DES encryption, the connection fails and the driver throws an exception. The AuthenticationMethod property must be set to a value of clearText, encryptedPassword, or encryptedUIDPassword. This value is not supported for DB2 for iSeries.

If requestDBEncryption, data is encrypted using DES encryption if the database server supports it. If the database server does not support DES encryption, the driver attempts to establish an unencrypted connection. The AuthenticationMethod property must be set to a value of clearText, encryptedPassword, or encryptedUIDPassword. This value is not supported for DB2 for iSeries.

If SSL, data is encrypted using SSL. If the database server does not support SSL, the connection fails and the driver throws an exception. When SSL is enabled, the following properties also apply:

• HostNameInCertificate

• KeyStore (for SSL client authentication)

• KeyStore (for SSL client authentication)

• KeyStorePassword (for SSL client authentication)

• KeyPassword (for SSL client authentication)

• TrustStore

• TrustStorePassword

• ValidateServerCertificate

Data Type: String

The default is noEncryption.

Determines whether the driver fails the entire failover process or continues with the process if exceptions occur while trying to reestablish a lost connection. This property is ignored if FailoverMode=connect.

Valid Values: nonAtomic | atomic | atomicWithRepositioning | disableIntegrityCheck

If nonAtomic, the driver continues with the failover process and posts any exceptions on the statement on which they occur.

If atomic, the driver fails the entire failover process if an exception is generated as the result of restoring the state of the connection. If an exception is generated as a result of restoring the state of work in progress, the driver continues with the failover process, but generates an exception warning that the Select statement must be reissued.

If atomicWithRepositioning, the driver fails the entire failover process if any exception is generated as the result of restoring the state of the connection or the state of work in progress.

If disableIntegrityCheck, the driver does not verify that the rows restored during the failover process match the original rows. This value is applicable only when FailoverMode=select.

Data Type: String

Default is nonAtomic.

Specifies the type of failover method the driver uses.

Valid Values: connect | extended| select

If connect, the driver provides failover protection for new connections only.

If extended, the driver provides failover protection for new and lost connections, but not any work in progress.

If select, the driver provides failover protection for new and lost connections. In addition, it preserves the state of work performed by the last Select statement executed on the Statement object.

NOTES:

• The AlternateServers property specifies one or multiple alternate servers for failover and is required for all failover methods.

• The FailoverGranularity property determines which action the driver takes if exceptions occur during the failover process.

• The FailoverPreconnect property specifies whether the driver tries to connect to multiple database servers (primary and alternate) at the same time.

Data Type: String

Default is connect.

Specifies whether the driver tries to connect to the primary and an alternate server at the same time. This property is ignored if FailoverMode=connect.

Valid Values: true | false

If true, the driver tries to connect to the primary and an alternate server at the same time. This can be useful if your application is time-sensitive and cannot absorb the wait for the failover connection to succeed.

If false, the driver tries to connect to an alternate server only when failover is caused by an unsuccessful connection attempt or a lost connection. This value provides the best performance, but your application typically experiences a short wait while the failover connection is attempted.

NOTE: The AlternateServers property specifies one or multiple alternate servers for failover.

Data Type: boolean

Default is false.

The name of the schema to which you want to grant EXECUTE privileges for DB2 packages. This property is ignored if the GrantExecute property is set to false.

Valid Values: string where string is a valid DB2 schema.

Data Type: String

IMPORTANT: Using a value other than PUBLIC restricts access to use the driver. For example, if you set this property to TSMITH, only the user TSMITH would be allowed access to use the driver against the server.

Default is PUBLIC.

Determines which DB2 schema is granted EXECUTE privileges for DB2 packages.

Valid Values: true | false

Data Type: boolean

If true, EXECUTE privileges are granted to the schema that is specified by the Grantee property.

If false, EXECUTE privileges are granted to the schema that created the DB2 packages.

The default is true.

Specifies a host name for certificate validation when SSL encryption is enabled (EncryptionMethod=SSL) and validation is enabled (ValidateServerCertificate=true). This property is optional and provides additional security against man-in-the-middle (MITM) attacks by ensuring that the server the driver is connecting to is the server that was requested.

NOTES:

• If SSL encryption or certificate validation is not enabled, this property is ignored.

• If SSL encryption and validation is enabled and this property is unspecified, the driver uses the server name specified in the connection URL or data source of the connection to validate the certificate.

Valid Values: host_name | #SERVERNAME# where host_name is a valid host name.

If host_name, the driver compares the specified host name to the DNSName value of the SubjectAlternativeName in the certificate. If a DNSName value does not exist in the SubjectAlternativeName or if the certificate does not have a SubjectAlternativeName, the driver compares the host name with the Common Name (CN) part of the certificate's Subject name. If the values do not match, the connection fails and the driver throws an exception.

If #SERVERNAME# is specified, the driver compares the server name that is specified in the connection URL or data source of the connection to the DNSName value of the SubjectAlternativeName in the certificate. If a DNSName value does not exist in the SubjectAlternativeName or if the certificate does not have a SubjectAlternativeName, the driver compares the host name to the CN part of the certificate's Subject name. If the values do not match, the connection fails and the driver throws an exception. If multiple CN parts are present, the driver validates the host name against each CN part. If any one validation succeeds, a connection is established.

Data Type: String

Default is empty string.

Specifies the path and file name of the file to be used to load the contents of the statement pool. When this property is specified, statements are imported into the statement pool from the specified file. If the driver cannot locate the specified file when establishing the connection, the connection fails and the driver throws an exception.

Valid Values: string where string is the path and file name of the file to be used to load the contents of the statement pool.

Data Type: String

Default is empty string.

Specifies one or multiple SQL commands to be executed by the driver after it has established the connection to the database and has performed all initialization for the connection. If the execution of a SQL command fails, the connection attempt also fails and the driver throws an exception indicating which SQL command or commands failed.

Valid Values: command[[;command]...] where command is a SQL command.

NOTE: Multiple commands must be separated by semicolons. In addition, if this property is specified in a connection URL, the entire value must be enclosed in parentheses when multiple commands are specified.

Example: The following connection URL adds USER2 to the CURRENT PATH special register and sets the CURRENT PRECISION special register to DEC31.

jdbc:datadirect:db2://server1:50000; InitializationString=(SET CURRENT PATH=current_path, USER2;SET CURRENT PRECISION='DEC31')

NOTE: Setting the CURRENT PRECISION special register is only valid for DB2 for z/OS.

Data Type: String

Determines the amount of memory used by the driver to cache insensitive result set data.

Valid Values -1 | 0 | x

Data Type: int

If -1, the driver caches all insensitive result set data in memory. If the size of the result set exceeds available memory, an OutOfMemoryException is generated. Because the need to write result set data to disk is eliminated, the driver processes the data more efficiently.

If 0, the driver caches all insensitive result set data in memory, up to a maximum of 2 GB. If the size of the result set data exceeds available memory, the driver pages the result set data to disk. Because result set data may be written to disk, the driver may have to reformat the data to write it correctly to disk.

If x, where x is a positive integer that specifies the size (in KB) of the memory buffer used to cache insensitive result set data. If the size of the result set data exceeds the buffer size, the driver pages the result set data to disk. Because the result set data may be written to disk, the driver may have to reformat the data to write it correctly to disk. Specifying a buffer size that is a power of 2 results in more efficient memory use.

The default is 2048 (KB)

Determines whether the driver uses its internal conversion algorithm or the JVM conversion algorithm when converting double or float values to string values.

Valid Values: true | false

If true, the driver uses the JVM algorithm when converting double or float values to string values.

If false, the driver uses its internal algorithm when converting double or float values to string values. Using this value improves performance; however, slight rounding differences can occur when compared to the same conversion using the JVM algorithm. These differences are within the allowable error of the double and float data types.

The default is false.

Determines how the driver describes database data types that map to the following JDBC 4.0 data types: NCHAR, NVARCHAR, NLONGVARCHAR, NCLOB, and SQLXML. This property is applicable only when the application is using Java SE 6.

Valid Values 0 | 1

Data Type: int

If 0, the driver describes the data types as JDBC 4.0 data types when using Java SE 6.

If 1, the driver describes the data types using JDBC 3.0-equivalent data types, regardless of JVM. This allows your application to continue using JDBC 3.0 types in a Java SE 6 environment. In addition, the JDBC 4.0 method ResultSet.getHoldability() returns the value of the JDBC 3.0 method Connection.getHoldability().

Default is 1.

Specifies the password that is used to access the individual keys in the keystore file when SSL is enabled (EncryptionMethod=SSL) and SSL client authentication is enabled on the database server.

This property is useful when individual keys in the keystore file have a different password than the keystore file.

Valid Values: string where string is a valid password.

Data Type: String

Default: None

Specifies the directory of the keystore file to be used when SSL is enabled (EncryptionMethod=SSL) and SSL client authentication is enabled on the database server. The keystore file contains the certificates that the client sends to the server in response to the server's certificate request.

This value overrides the directory of the keystore file that is specified by the javax.net.ssl.keyStore Java system property. If this property is not specified, the keystore directory is specified by the javax.net.ssl.keyStore Java system property.

NOTE: The keystore and truststore files can be the same file.

Valid Values: string where string is a valid directory of a keystore file.

Data Type: String

Default: None

Specifies the password that is used to access the keystore file when SSL is enabled (EncryptionMethod=SSL) and SSL client authentication is enabled on the database server. The keystore file contains the certificates that the client sends to the server in response to the server's certificate request.

This value overrides the password of the keystore file that is specified by the javax.net.ssl.keyStorePassword Java system property. If this property is not specified, the keystore password is specified by the javax.net.ssl.keyStorePassword Java system property.

NOTE: The keystore and truststore files can be the same file.

Valid Values: string where string is a valid password.

Data Type: String

Default: None

Determines whether the driver uses client load balancing in its attempts to connect to the database servers (primary and alternate). You can specify one or multiple alternate servers by setting the AlternateServers property.

Valid Values: true | false

If true, the driver uses client load balancing and attempts to connect to the database servers (primary and alternate) in random order. The driver randomly selects from the list of primary and alternate servers which server to connect to first. If that connection fails, the driver again randomly selects from this list of servers until all servers in the list have been tried or a connection is successfully established.

If false, the driver does not use client load balancing and connects to each server based on their sequential order (primary server first, then, alternate servers in the order they are specified).

Default: false

Data Type: boolean

The name of the DB2 location that you want to access.

For DB2 for z/OS, your system administrator can determine the name of your DB2 location using the following command: DISPLAY DDF.

For DB2 for iSeries, your system administrator can determine the name of your DB2 location using the following command. The name of the database that is listed as *LOCAL is the value you should use for this property.

For WRKRDBDIRE, this property is supported only for DB2 for z/OS and DB2 for iSeries.

Valid Values: stringwhere string is the DB2 location.

Default: None

Data Type: String

Alias: DatabaseName property. If both the DatabaseName and LocationName connection properties are specified in a connection URL, the last property positioned in the connection URL is used.

The amount of time, in seconds, the driver waits for a connection to be established before returning control to the application and throwing a timeout exception.

Valid Values 0 | x where x is a positive integer.

If 0, the driver does not time out a connection request.

If x, the driver waits for the specified number of seconds before returning control to the application and throwing a timeout exception.

Default: 0

Data Type: int

The maximum number of pooled prepared statements for this connection. Setting MaxPooledStatements to an integer greater than zero (0) enables the driver's internal prepared statement pooling, which is useful when the driver is not running from within an application server or another application that provides its own prepared statement pooling.

Valid Values: 0 | x where x is a positive integer.

If 0, the driver's internal prepared statement pooling is not enabled.

If set to x, the driver enables the Statement Pool Monitor and uses the specified value to cache a certain number of prepared statements created by an application.

If the value set for this property is greater than the number of prepared statements that are used by the application, all prepared statements that are created by the application are cached. Because CallableStatement is a sub-class of PreparedStatement, CallableStatements also are cached.

Example: If the value of this property is set to 20, the driver caches the last 20 prepared statements that are created by the application.

Default: 0

Data Type: int

Alias: MaxStatements property

An alias for the MaxPooledStatements property.

The name of the collection or library (group of packages) to which DB2 packages are bound.

This property is ignored for DB2 for Linux/UNIX/Windows.

Note: This property replaces the CollectionId property; however, the CollectionId property is still recognized for backward compatibility. If both the PackageCollection and CollectionId properties are specified, the CollectionId property is ignored.

See Creating a DB2 Package for more information about creating DB2 packages.

The default is NULLID.

The owner to be used for any DB2 packages that are created.

See Creating a DB2 Package for more information about creating DB2 packages.

The default is NULL.

Data Type: String

A case-sensitive password used to connect to your DB2 database. A password is required only if security is enabled on your database. If so, contact your system administrator to get your password.

Valid Values: string where string is a valid password. The password is case-sensitive.

Default: None

Data Type: String

The TCP port on which the database server listens for connections. The default is 50000.

The product and version information of the driver on the client to be stored in the database. This value sets the CLIENT_PRDID value in the database. For DB2 V9.1 and higher for Linux/UNIX/Windows, this value is located in the SYSIBMADM.APPLICATIONS table.

Valid Values DDJVVRRM where:

• DDJ is an identifier for the DataDirect Connect for JDBC driver.

• VV identifies a 2-digit version number (with high-order 0 in the case of a 1-digit version).

• RR identifies a 2-digit release number (with high-order 0 in the case of a 1-digit release).

• M identifies a 1-character modification level (0-9 or A-Z).

Example: DDJ04100

Default: empty stringData Type: String

Positive integer, -1, or zero (0). Sets the default query timeout (in seconds) for all statements created by a connection.

If set to a positive integer, the driver uses the value as the default timeout for any statement created by the connection. To override the default timeout value set by this connection option, call the Statement.setQueryTimeout() method to set a timeout value for a particular statement.

If set to -1, the query timeout functionality is disabled. The driver silently ignores calls to the Statement.setQueryTimeout() method.

If set to 0 (the default), the default query timeout is infinite (the query does not time out).

The default is 0.

Determines whether the current bind process will replace the existing DB2 packages used by the driver.

For DB2 for Linux/UNIX/Windows, this property must be used in conjunction with the CreateDefaultPackage property.

Valid Values: true | false

If true, the current bind process replaces the existing DB2 packages that are used by the driver.

If false, the current bind process does not replace the existing DB2 packages.

Default: false

Data Type: boolean

The DB2 driver can return table name information in the ResultSet metadata for Select statements if your application requires that information.

Valid Values 0 | 1

If set to 0 (the default) and the ResultSetMetaData.getTableName() method is called, the DB2 driver does not perform additional processing to determine the correct table name for each column in the result set. In this case, the getTableName() method may return an empty string for each column in the result set.

If set to 1 and the ResultSetMetaData.getTableName() method is called, the DB2 driver performs additional processing to determine the correct table name for each column in the result set. The DB2 driver also can return schema name and catalog name information when the ResultSetMetaData.getSchemaName() and ResultSetMetaData.getCatalogName() methods are called if the driver can determine that information.

For information about configuring this property for optimal performance, see Performance Considerations.

The default is 0.

Data Type: int

This property is recognized for backward compatibility, but we recommend that you use the AuthenticationMethod property to set the authentication method used by the driver.

Determines whether binary stream data that is less than 32K bytes is sent to the database as Long Varchar for Bit Data or Blob data. Binary streams that are larger than 32K bytes can only be inserted into a Blob column. The driver always sends binary stream data larger than 32K bytes to the database as Blob data.

Valid Values: true | false

If true, the driver sends binary stream data that is less than 32K to the database as DB2 Blob data. If the target column is a Long Varchar for Bit Data column and not a Blob column, the Insert or Update statement fails. The driver automatically retries the Insert or Update statement, sending the data as Long Varchar for Bit Data, if the pointer in the stream can be reset to the beginning of the stream. If you know that you are sending the binary stream data to a Blob column, setting this value improves performance.

If false, the driver sends binary stream data that is less than 32K to the database as Long Varchar for Bit Data data. If the target column is a Blob column and not a Long Varchar for Bit Data column, the Insert or Update statement fails. The driver retries the Insert or Update statement, sending the data as Blob data, if the pointer in the stream can be reset to the beginning of the stream.

See Performance Considerations for information about configuring this property for optimal performance.

The default is false.

Data Type: boolean

Specifies either the IP address in IPv4 or IPv6 format, or the server name (if your network supports named servers) of the database server.

This property is supported only for data source connections.

Valid Values: string where string is a valid IP address or server name.

Example: 122.23.15.12 or DB2ServerDefault: None

Data Type: String

Enables DataDirect Spy to log detailed information about calls that are issued by the driver on behalf of the application. Spy is not enabled by default.

Valid Values: (spy_attribute[;spy_attribute]...) where spy_attribute is any valid Spy attribute. See Tracking JDBC Calls with WebLogic JDBC Spy for a list of supported attributes.NOTE: If coding a path on Windows to the log file in a Java string, the backslash character () must be preceded by the Java escape character, a backslash. For example:

log=(file)C:tempspy.log.Example: The following value instructs the driver to log all JDBC activity to a file using a maximum of 80 characters for each line.

(log=(file)/tmp/spy.log;linelimit=80)

Default: None

Data Type: String

Specifies whether new-line characters in a SQL statement are sent to the DB2 server. If you know that the SQL statements used in your application do not contain newline characters, instructing the driver to not remove them eliminates parsing by the DB2 server and improves performance.

Valid Values: true | false

If true, the driver removes all newline characters from SQL statements.

If false, the driver does not remove any newline characters from SQL statements.

Default: false

Data Type: boolean

See Performance Considerations for information about configuring this property for optimal performance.

Specifies the directory of the truststore file to be used when SSL is enabled using the EncryptionMethod property and server authentication is used. The truststore file contains a list of the Certificate Authorities (CAs) that the client trusts. This value overrides the directory of the truststore file that is specified by the javax.net.ssl.trustStore Java system property. If this property is not specified, the truststore directory is specified by the javax.net.ssl.trustStore Java system property.

This property is ignored if ValidateServerCertificate=false.

Valid Values: string where string is the directory of the truststore file.

Defaul:t None

Data Type: String

Specifies the password that is used to access the truststore file when SSL is enabled using the EncryptionMethod property and server authentication is used. The truststore file contains a list of the Certificate Authorities (CAs) that the client trusts.

This value overrides the password of the truststore file that is specified by the javax.net.ssl.trustStorePassword Java system property. If this property is not specified, the truststore password is specified by the javax.net.ssl.trustStorePassword Java system property.

This property is ignored if ValidateServerCertificate=false.

Valid Values: string where string is a valid password for the truststore file.

Default: NoneData Type: String

Specifies whether results are restricted to the tables and views in the current schema if a DatabaseMetaData.getTables or DatabaseMetaData.getColumns() method is called without specifying a schema or if the schema is specified as the wildcard character %. Restricting results to the tables and views in the current schema improves the performance of calls for getTables() methods that do not specify a schema.

Valid Values: true | false

If true, results that are returned from the getTables() and getColumns() methods are restricted to tables and views in the current schema.

If false (the default), results of the getTables() and getColumns() methods are not restricted.

See Performance Considerations for information about configuring this property for optimal performance.

The default is false.

Data Type: boolean

The case-sensitive user name used to connect to the DB2 database.

Valid Values: string where string is a valid user name. The user name is case-sensitive.Default: None

Data Type: String

Determines whether the driver validates the certificate that is sent by the database server when SSL encryption is enabled (EncryptionMethod=SSL). When using SSL server authentication, any certificate that is sent by the server must be issued by a trusted Certificate Authority (CA). Allowing the driver to trust any certificate that is returned from the server even if the issuer is not a trusted CA is useful in test environments because it eliminates the need to specify truststore information on each client in the test environment.

Valid Values: true | false

If true, the driver validates the certificate that is sent by the database server. Any certificate from the server must be issued by a trusted CA in the truststore file. If the HostNameInCertificate property is specified, the driver also validates the certificate using a host name. The HostNameInCertificate property is optional and provides additional security against man-in-the-middle (MITM) attacks by ensuring that the server the driver is connecting to is the server that was requested.

If false, the driver does not validate the certificate that is sent by the database server. The driver ignores any truststore information that is specified by the TrustStore and TrustStorePassword properties or Java system properties.

NOTE: Truststore information is specified using the TrustStore and TrustStorePassword properties or by using Java system properties.

Default: true

Data Type: boolean

Determines whether the cursor stays open on commit—either DB2 leaves all cursors open (Preserve cursors) or closes all open cursors (Delete cursors) after a commit. Rolling back a transaction closes all cursors regardless of how this property is specified.

Valid Values true | false

If true, the cursor behavior is Preserve.

If false, the cursor behavior is Delete.

The default is true.

Data Type: boolean

Determines whether the driver maps XML data to the CLOB or BLOB data type.

Valid Values: clob | blob

If clob, the driver maps XML data to the CLOB data type.

If blob, the driver maps XML data to the BLOB data type.

See Returning and Inserting/Updating XML Data for more information.

The default is clob.

Data Type: String

DB2 for z/OS and iSeries

DB2 for Linux/UNIX/Windows, z/OS, and iSeries

DB2 for Linux/UNIX/Windows

DB2 for Linux/UNIX/Windows, z/OS, and iSeries

BIGINT

BINARY

BLOB

CHAR

BINARY

CLOB

NOTE: If JDBCBehavior=0, the data type depends on the JVM used by the application: NCLOB (if using Java SE 6) or CLOB (if using another JVM).

DATE

CLOB

DECIMAL

DECIMAL

DOUBLE

FLOAT

CHAR

NOTE: If JDBCBehavior=0, the data type depends on the JVM used by the application: NCHAR (if using Java SE 6) or CHAR (if using another JVM).

INTEGER

LONGVARCHAR

LONGVARBINARY

LONGVARCHAR

NOTE: If JDBCBehavior=0, the data type depends on the JVM used by the application: LONGNVARCHAR (if using Java SE 6) or LONGVARCHAR (if using another JVM).

NUMERIC

REAL

VARBINARY

SMALLINT

TIME

TIMESTAMP

VARBINARY

VARCHAR

VARBINARY

VARCHAR

NOTE: If JDBCBehavior=0, the data type depends on the JVM used by the application: NVARCHAR (if using Java SE 6) or VARCHAR (if using another JVM).

CLOB

NOTE: If JDBCBehavior=0, the data type depends on the JVM used by the application: SQLXML (if using Java SE 6) or CLOB (if using another JVM).

The database server must be running one of the following database versions:

• DB2 v8.1 or higher for Linux/UNIX/Windows

• DB2 v7.x or higher for z/OS

The Kerberos server is the machine where the user IDs for authentication are administered. The Kerberos server is also the location of the Kerberos KDC.

• Network authentication must be provided by one of the following methods:

• Windows Active Directory on one of the following operating systems:

  Windows Server 2003

  Windows 2000 Server Service Pack 3 or higher

• MIT Kerberos 1.4.2 or higher

J2SE 1.4.2 or higher must be installed.

SYSCAT.TABLES

SYSCAT.COLUMNS

SYSCAT.PROCEDURES

SYSCAT.PROCPARAMS

SYSCAT.COLAUTH

SYSCAT.TABAUTH

SYSCAT.KEYCOLUSE

SYSCAT.INDEXES

SYSCAT.INDEXCOLUSE

SYSCAT.REFERENCES

SYSCAT.SYSSCHEMATA

SYSCAT.TYPEMAPPINGS

SYSCAT.DBAUTH

SYSIBM.SYSTABCONST

SYSIBM.SYSTABLES

SYSIBM.SYSSYNONYMS

SYSIBM.SYSCOLUMNS

SYSIBM.SYSPROCEDURES

SYSIBM.SYSROUTINES

SYSIBM.SYSPARMS

SYSIBM.SYSCOLAUTH

SYSIBM.SYSTABAUTH

SYSIBM.SYSKEYS

SYSIBM.SYSINDEXES

SYSIBM.SYSRELS

SYSIBM.SYSFOREIGNKEYS

SYSIBM.SYSSCHEMAAUTH

SYSIBM.SYSDBAUTH

QSYS2.SYSCST

QSYS2.SYSKEYCST

QSYS2.SYSPROCS

QSYS2.SYSPARMS

QSYS2.SYSTABLES

QSYS2.SYSSYNONYM

QSYS2.SYSCOLUMNS

QSYS2.SQLTABLEPRIVILEGES

QSYS2.SYSKEYS

QSYS2.SYSINDEXES

QSYS2.SYSREFCSTS

No Commit^{Foot 1}

Cursor Stability

Uncommitted Read

Read Stability

Repeatable Read

CHAR

LONGVARCHAR

VARCHAR

BIGINT

BINARY

DECIMAL

VARBINARY

CLOB