Cloudscape Properties
Page 1 of 47

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.

    • Set programmatically

      System-wide properties set programmatically have precedence over -database-wide properties and system-wide properties set in the cloudscape.properties file.

    • Set in the cloudscape.properties file
  • 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.