Properties that are shown in uppercase
characters in the following information must be specified in uppercase.
For those properties,
getXXX and
setXXX methods
are formed by prepending the uppercase property name with
get or
set.
For example:
boolean dbDate = DB2BaseDataSource.getDBDATE();
- 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.
- maxTransportObjectWaitTime
- Specifies the maximum amount of time in seconds that an application
waits for a transport object if the maxTransportObjects value has
been reached. Transport objects are used for the connection concentrator
and Sysplex workload balancing. When an application waits for longer
than the maxTransportObjectWaitTime value, the global transport object
pool throws an SQLException.
The default value for maxTransportObjectWaitTime
is 1. Any negative value means that applications wait forever.
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.
DB2 Version 9.7 for Linux, UNIX, and Windows