[top]
[prev]
[next]

Documentation Top
Global Index
Reference Manual
TOC Index
Grammar Index
Developer’s Guide
TOC Index
Tuning Cloudscape
TOC Index
|
5 Cloudscape Properties
Scope of Cloudscape Properties
A property in Cloudscape belongs to one or more of these scopes (for more information about scopes, precedence, and persistence, see Properties Overview):
- system-wide
System-wide properties apply to an entire system, including all its databases and tables if applicable.
- database-wide
A database-wide property is stored in a database and is valid for that specific database only.
To be included in a publication in a synchronization system, a property must be a database-wide property. You can publish any database-wide property. Full-access users can also set database properties at targets.
NOTE: Database-wide properties are stored in the database and are simpler for deployment. System-wide parameters are probably easier for development.
- conglomerate-specific
Conglomerate-specific properties are set at table or index creation time and define storage attributes for the specific table or index only; the rest of the database uses the value of the property that is set at a database-wide or system-wide level. For more information, see Conglomerate-Specific Properties.
Cloudscape Properties
This chapter includes all the core Cloudscape properties. For synchronization-related properties, see the Cloudscape Synchronization Guide. For Cloudconnector properties (which are set in a different file), see the Cloudscape Server and Administration Guide. For optimizer override properties, see Chapter 6, "Optimizer Overrides".
NOTE: When setting properties that have boolean values, be sure to trim extra spaces around the word true. Extra spaces around the word true cause the property to be set to false.
Table 5-1 summarizes the general Cloudscape properties. In that table, S stands for system-wide, D stands for database-wide, and C stands for conglomerate-specific. X means yes.
Table 5-1 Cloudscape Properties
Property |
Scope |
Publishable |
Dynamic |
cloudscape.authentication.ldap.searchAuthDN
|
S, D |
X |
|
cloudscape.authentication.ldap.searchAuthPW
|
S, D |
X |
|
cloudscape.authentication.ldap.searchBase
|
S, D |
X |
|
cloudscape.authentication.ldap.searchFilter
|
S, D |
X |
|
cloudscape.authentication.provider
|
S, D |
X |
|
cloudscape.authentication.server
|
S, D |
X |
|
cloudscape.connection.requireAuthentication
|
S, D |
X |
|
cloudscape.database.classpath
|
S, D |
X |
X * |
cloudscape.database.defaultConnectionMode
|
S, D |
X |
X * |
cloudscape.database.forceDatabaseLock
|
S |
|
|
cloudscape.database.fullAccessUsers
|
S, D |
X |
X * |
cloudscape.database.noAutoBoot
|
D |
|
|
cloudscape.database.propertiesOnly
|
D |
X |
X |
cloudscape.database.readOnlyAccessUsers
|
S, D |
X |
X * |
cloudscape.infolog.append
|
S |
|
|
cloudscape.jdbc.metadataStoredPreparedStatements
|
S |
|
X |
cloudscape.language.bulkFetchDefault
|
S, D |
X |
X |
cloudscape.language.defaultIsolationLevel
|
S, D |
X |
|
cloudscape.language.logStatementText
|
S, D |
X |
|
cloudscape.language.preloadClasses
|
S, D |
X |
X |
cloudscape.language.spsCacheSize
|
S, D |
X |
|
cloudscape.language.stalePlanCheckInterval
|
S, D |
X |
|
cloudscape.language.statementCacheSize
|
S, D |
X |
|
cloudscape.language.triggerMaximumRecursionLevel
|
D |
X |
X |
cloudscape.locks.deadlockTimeout
|
S, D |
X |
X |
cloudscape.locks.deadlockTrace
|
S, D |
X |
X |
cloudscape.locks.escalationThreshold
|
S, D |
X |
X |
cloudscape.locks.monitor
|
S, D |
X |
X |
cloudscape.locks.waitTimeout
|
S,D |
X |
X |
cloudscape.service
|
S |
|
X |
cloudscape.storage.fileCacheSize
|
S |
|
|
cloudscape.storage.initialPages
|
C |
|
|
cloudscape.storage.minimumRecordSize
|
S, D, C |
X |
X |
cloudscape.storage.pageCacheSize
|
S |
|
|
cloudscape.storage.pageReservedSpace
|
S, D, C |
X |
X |
cloudscape.storage.pageSize
|
S, D, C |
X |
X |
cloudscape.storage.rowLocking
|
S, D |
X |
|
cloudscape.storage.sortBufferMax
|
S |
|
|
cloudscape.storage.tempDirectory
|
S, D |
|
X |
cloudscape.stream.error.field
|
S |
|
|
cloudscape.stream.error.file
|
S |
|
|
cloudscape.stream.error.logSeverityLevel
|
S |
|
|
cloudscape.stream.error.method
|
S |
|
|
cloudscape.system.bootAll
|
S |
|
|
cloudscape.system.home
|
S |
|
|
cloudscape.user.UserName
|
S, D |
X |
X |
*
See the man page for this property for information about when changes to it are dynamic.
There are additional properties associated with the Cloudscape tools (ij and Cloudview). For more information about tool-specific properties, see the Cloudscape Tools and Utilities Guide.
|