Table 0-1 Database Property Descriptions
Type |
Property |
Description |
Database |
classpath
|
One or more fully-qualified jar file name(s) for use by the class loader. ('schema.jarfile'). Separate multiple file names with a colon. For example:
APP.ToursLogic:APP.GUILogic
|
defaultConnectionMode
|
Default connection mode for the database (noAccess, readOnlyAccess, or fullAccess)
|
fullAccessUsers
|
Comma-delimited list of users with read-write access. ('user1,user2')
|
noAutoBoot
|
Set to true to suppress automatic booting of this database when the bootAll property has been turned on. If bootAll is not set, or is set to false, noAutoBoot is irrelevant.
|
propertiesOnly
|
If set to true, database-wide properties for this database cannot be overridden by system-wide properties. Default is false.
|
readOnlyAccessUsers
|
Comma-delimited list of users with read-only access. ('user1,user2')
|
Authentication |
ldap.searchAuthDN
|
Specifies the Distinguished Name for an LDAP user search. ('uid=uname'). Use with searchAuthPW, described next.
|
ldap.searchAuthPW
|
Password for the user configured by searchAuthDN. ('passwd')
|
ldap.searchBase
|
The root DN from which to begin a search for the guest or user DN. ('uid=uname')
|
ldap.searchFilter
|
Specifies a DN search filter to use during user authentication. Set to the value db2j.user to search all users defined in the db2j.user.UserName property. ( (&(objectClass=person)(uid=uname)) or (db2j.user) ).
|
provider
|
Specifies an authentication provider for Cloudscape user authentication. Values include LDAP, NIS+, BUILTIN, or a complete Java class name. If setting LDAP or NIS+, you must also set the server property, described next.
|
server
|
Location of the user-authenticating external directory service defined by the provider property. For LDAP, specify hostname:portnumber. For NIS+, specify the nisServerName and the nisDomainName.
|
Language |
bulkFetchDefault
|
The number of rows Cloudscape fetches at a time when reading a table or index. The default value is 16.
|
defaultIsolationLevel
|
Default isolation level for the database. Legal values are SERIALIZABLE, REPEATABLE_READ, READ_COMMITTED, and READ_UNCOMMITTED.
|
logStatementText
|
If set to true, at the beginning of statement execution Cloudscape writes the text and parameter values to the information log. The default is false.
|
preloadClasses
|
If set to true, Cloudscape preloads compilation classes at database bootup. Boot time is slower, but query compilation time is much faster. The default is false.
|
spsCacheSize
|
Size of the database's stored prepared statement cache. The default value is 32.
|
stalePlanCheckInterval
|
Number of times a statement executes before checking to see if the statement is stale. The default value is 100. The minimum value is 5.
|
statementCacheSize
|
Number of statements to cache per database. The default value is 100.
|
triggerMaximumRecursionLevel
|
Maximum recursion level for trigger firing. The default value is 16. A value of -1 means there are no limits to recursion. A value of 0 means no trigger will ever fire.
|
Locks |
deadlockTimeout
|
The number of seconds to wait before attempting to detect a deadlock for the waiting transaction. Default is 60. If this value is higher than waitTimeout, no deadlock checking occurs.
|
deadlockTrace
|
If set to true, causes a stack trace of all threads involved in a deadlock to be written to the error log. This property has meaning only when the monitor property is set to true.
|
escalationThreshold
|
The maximum number of rows the optimizer will lock before simply locking the entire table (during compilation). At runtime, Cloudscape uses this property to determine locking escalation independent of any compilation decision. The default value is 5000. The minimum value is 100.
|
monitor
|
If set to true, all deadlock errors are logged to the error log. The default value is false.
|
waitTimeout
|
The number of seconds to wait before aborting a transaction waiting for a lock. 0 means abort the transaction upon encountering a lock wait. A negative value means to wait forever. The default value is 180.
|
Other |
user.UserName
|
A password (if provider is set to builtin), or a user DN (if provider is set to ldap and searchFilter is set to db2j.user). Substitute the user name for UserName, and passwd or userDSN for the value.
|
connection.requireAuthentication
|
If set to true, all connection requests must include a valid user name and password. The value of the provider property determines the type of user authentication. The default value is false.
|
encryptionAlgorithm
encryptionProvider
|
These are database connection URL attributes which cannot be set from here. To use these in Cview, specify them on the Connection tab before creating a database. For more information about these attributes, see the Cloudscape Reference Manual.
|
Storage |
minimumRecordSize
|
Specifies the minimum row size (in bytes) to use when creating a table. The default value is 12 bytes.
|
pageReservedSpace
|
The percentage of space reserved for table updates. The default value is 20 percent.
|
pageSize
|
The page size (in bytes) for tables or indexes used during table or index creation. This value should be a power of 2. The default value is 4096.
|
rowLocking
|
If set to false, row-level locking is disabled. The default value is true.
|
tempDirectory
|
Specifies the directory in which to write temporary files. By default, this property is set to a tmp directory beneath the database directory. The value specified for this property does not need to be enclosed in quotes. (c:\dirname)
|