Description of Properties

The following table lists the properties you can set from Cview, grouped by type:
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)