IBM Data Server Driver for JDBC and SQLJ properties for IBM Informix
Some of the IBM Data Server Driver for JDBC and SQLJ properties apply only to IBM Informix databases. Those properties correspond to IBM Informix environment variables.
boolean dbDate = DB2BaseDataSource.getDBDATE();
The IBM Informix-specific properties are:
- 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. The data type of
this property is boolean. Possible values are:
- false or 0
- Do not send a value to the IBM Informix database that instructs the database to return an SQLWarning to the application if an SQL statement does not use ANSI-standard syntax. This is the default.
- true or 1
- Send a value to the IBM Informix database that instructs the database to return an SQLWarning to the application if an SQL statement does not use ANSI-standard syntax.
You can use the DBANSIWARN IBM Data Server Driver for JDBC and SQLJ property to set the DBANSIWARN IBM Informix property, but you cannot use the DBANSIWARN IBM Data Server Driver for JDBC and SQLJ property to reset the DBANSIWARN IBM Informix property.
- DBDATE
- Specifies the end-user format of DATE values. The data type of
this property is String. Possible values are in the description of
the DBDATE environment variable in IBM Informix Guide to SQL: Reference.
The default value is "Y4MD-".
- DBPATH
- Specifies a colon-separated list of values that identify the database
servers that contain databases. The date type of this property is
String. Each value can be:
- A full path name
- A relative path name
- The server name of an IBM Informix database server
- A server name and full path name
The default ".".
- DBSPACETEMP
- Specifies a comma-separated or colon-separated list of existing
dbspaces in which temporary tables are placed. The data type of this
property is String.
If this property is not set, no value is sent to the server. The value for the DBSPACETEMP environment variable is used.
- DBTEMP
- Specifies the full path name of an existing directory in which temporary files and temporary tables are placed. The data type of this property is String. The default is "/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 data type of this property is String.
The format of DBUPSPACE is "maximum-disk-space:maximum-memory".
If this property is not set, no value is sent to the server. The value for the DBUPSPACE environment variable is used.
- DB_LOCALE
- Specifies the database locale, which the database server uses to process locale-sensitive data. The data type of this property is String. Valid values are the same as valid values for the DB_LOCALE environment variable. The default value is null.
- DELIMIDENT
- Specifies whether delimited SQL identifiers can be used in an
application. The data type of this property is boolean. Possible values
are:
- false
- The application cannot contain delimited SQL identifiers. Double quotation marks (") or single quotation marks (') delimit literal strings. This is the default.
- true
- The application can contain delimited SQL identifiers. Delimited SQL identifiers must be enclosed in double quotation marks ("). Single quotation marks (') delimit literal strings.
- IFX_DIRECTIVES
- Specifies whether the optimizer allows query optimization directives
from within a query. The data type of this property is String. Possible
values are:
- "1" or "ON"
- Optimization directives are accepted.
- "0" or "OFF"
- Optimization directives are not accepted.
If this property is not set, no value is sent to the server. The value for the IFX_DIRECTIVES environment variable is used.
- 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:
- "1" or "ON"
- External query optimization directives are accepted.
- "0" or "OFF"
- External query optimization are not accepted.
If this property is not set, no value is sent to the server. The value for the IFX_EXTDIRECTIVES environment variable is used.
- IFX_UPDDESC
- Specifies whether a DESCRIBE of an UPDATE statement is permitted.
The data type of this property is String.
Any non-null value indicates that a DESCRIBE of an UPDATE statement is permitted. The default is "1".
- IFX_XASTDCOMPLIANCE_XAEND
- Specifies whether global transactions are freed only after an
explicit rollback, or after any rollback. The data type of this property
is String. Possible values are:
- "0"
- Global transactions are freed only after an explicit rollback. This behavior conforms to the X/Open XA standard.
- "1"
- Global transactions are freed after any rollback.
If this property is not set, no value is sent to the server. The value for the IFX_XASTDCOMPLIANCE_XAEND environment variable is used.
- 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.
If this property is not set, no value is sent to the server. The value for the INFORMIXOPCACHE environment variable is used.
- INFORMIXSTACKSIZE
- Specifies the stack size, in kilobytes, that the database server
uses for the primary thread of a client session. The data type of
this property is String.
If this property is not set, no value is sent to the server. The value for the INFORMIXSTACKSIZE environment variable is used.
- 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. The data type of this property is String.
Possible values are:
- "yes"
- The database server prevents default table privileges from being granted to PUBLIC when a new table is created during the current session, in a database that is not ANSI compliant.
- "no"
- The database server does not prevent default table privileges from being granted to PUBLIC when a new table is created during the current session, in a database that is not ANSI compliant. This is the default.
- OPTCOMPIND
- Specifies the preferred method for performing a join operation
on an ordered pair of tables. The data type of this property is String.
Possible values are:
- "0"
- The optimizer chooses a nested-loop join, where possible, over a sort-merge join or a hash join.
- "1"
- When the isolation level is repeatable read, the optimizer chooses a nested-loop join, where possible, over a sort-merge join or a hash join. When the isolation level is not repeatable read, the optimizer chooses a join method based on costs.
- "2"
- The optimizer chooses a join method based on costs, regardless of the transaction isolation mode.
If this property is not set, no value is sent to the server. The value for the OPTCOMPIND environment variable is used.
- OPTOFC
- Specifies whether to enable optimize-OPEN-FETCH-CLOSE functionality.
The data type of this property is String. Possible values are:
- "0"
- Disable optimize-OPEN-FETCH-CLOSE functionality for all threads of applications.
- "1"
- Enable optimize-OPEN-FETCH-CLOSE functionality for all cursors in all threads of applications.
If this property is not set, no value is sent to the server. The value for the OPTOFCD environment variable is used.
- PDQPRIORITY
- Specifies the degree of parallelism that the database server uses.
The PDQPRIORITY value affects how the database server allocates resources,
including memory, processors, and disk reads. The data type of this
property is String. Possible values are:
- "HIGH"
- When the database server allocates resources among all users, it gives as many resources as possible to queries.
- "LOW" or "1"
- The database server fetches values from fragmented tables in parallel.
- "OFF" or "0"
- Parallel processing is disabled.
If this property is not set, no value is sent to the server. The value for the PDQPRIORITY environment variable is used.
- PSORT_DBTEMP
- Specifies the full path name of a directory in which the database
server writes temporary files that are used for a sort operation.
The data type of this property is String.
If this property is not set, no value is sent to the server. The value for the PSORT_DBTEMP environment variable is used.
- PSORT_NPROCS
- Specifies the maximum number of threads that the database server
can use to sort a query. The data type of this property is String.
The maximum value of PSORT_NPROCS is "10".
If this property is not set, no value is sent to the server. The value for the PSORT_NPROCS environment variable is used.
- STMT_CACHE
- Specifies whether the shared-statement cache is enabled. The data
type of this property is String. Possible values are:
- "0"
- The shared-statement cache is disabled.
- "1"
- A 512 KB shared-statement cache is enabled.
If this property is not set, no value is sent to the server. The value for the STMT_CACHE environment variable is used.
- dumpPool
- Specifies the types of statistics on global transport pool events
that are written, in addition to summary statistics. The global transport
pool is used for the connection concentrator and sysplex workload
balancing.
The data type of dumpPool is int. dumpPoolStatisticsOnSchedule and dumpPoolStatisticsOnScheduleFile must also be set for writing statistics before any statistics are written.
You can specify one or more of the following types of statistics with the db2.jcc.dumpPool property:DUMP_REMOVE_OBJECT
(hexadecimal: X'01', decimal: 1)DUMP_GET_OBJECT
(hexadecimal: X'02', decimal: 2)DUMP_WAIT_OBJECT
(hexadecimal: X'04', decimal: 4)DUMP_SET_AVAILABLE_OBJECT
(hexadecimal: X'08', decimal: 8)DUMP_CREATE_OBJECT
(hexadecimal: X'10', decimal: 16)DUMP_SYSPLEX_MSG
(hexadecimal: X'20', decimal: 32)DUMP_POOL_ERROR
(hexadecimal: X'80', decimal: 128)
To trace more than one type of event, add the values for the types of events that you want to trace. For example, suppose that you want to trace DUMP_GET_OBJECT and DUMP_CREATE_OBJECT events. The numeric equivalents of these values are 2 and 16, so you specify 18 for the dumpPool value.
The default is 0, which means that only summary statistics for the global transport pool are written.
This property does not have a setXXX or a getXXX method.
- dumpPoolStatisticsOnSchedule
- Specifies how often, in seconds, global transport pool statistics
are written to the file that is specified by dumpPoolStatisticsOnScheduleFile.
The global transport object pool is used for the connection concentrator
and sysplex workload balancing.
The default is -1. -1 means that global transport pool statistics are not written.
This property does not have a setXXX or a getXXX method.
- 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.
If dumpPoolStatisticsOnScheduleFile is not specified, global transport pool statistics are not written.
This property does not have a setXXX or a getXXX method.
- maxTransportObjectIdleTime
- Specifies the amount of time in seconds that an unused transport
object stays in a global transport object pool before it can be deleted
from the pool. Transport objects are used for the connection concentrator
and sysplex workload balancing.
The default value for maxTransportObjectIdleTime is 10. Setting maxTransportObjectIdleTime to a value less than 0 causes unused transport objects to be deleted from the pool immediately. Doing this is not recommended because it can cause severe performance degradation.
This property does not have a setXXX or a getXXX method.
- minTransportObjects
- Specifies the lower limit for the number of transport objects
in a global transport object pool for the connection concentrator
and sysplex workload balancing. When a JVM is created, there are no
transport objects in the pool. Transport objects are added to the
pool as they are needed. After the minTransportObjects value is reached,
the number of transport objects in the global transport object pool
never goes below the minTransportObjects value for the lifetime of
that JVM.
The default value for minTransportObjects is 0. Any value that is less than or equal to 0 means that the global transport object pool can become empty.
This property does not have a setXXX or a getXXX method.