Database

curam.db.type

STRING

The property which specifies the database type. Suggested: DB2/ORA/ZOS.

curam.db.password

STRING

The encrypted password that corresponds to the user name specified above. The database password is never stored in plaintext in the various Curam property files.

curam.db.username

STRING

A valid database username.

curam.db.oracle.cachesize

INT32

The size of the prepared statement cache used by batch programs when run against Oracle (the prepared statement cache is based around implicit caching).

curam.db.oracle.connectioncache.enabled

BOOLEAN

Turn on connection caching for Oracle outside of an Application Server.

curam.db.oracle.connectioncache.minlimit

INT32

Set Min Limit for the Cache. This sets the minimum number of PooledConnections that the cache maintains. This guarantees that the cache will not shrink below this minimum limit.

curam.db.oracle.connectioncache.maxlimit

INT32

Set Max Limit for the Cache. This sets the maximum number of PooledConnections the cache can hold. There is no default MaxLimit assumed meaning connections in the cache could reach as many as the database allows.

curam.db.oracle.connectioncache.initiallimit

INT32

Set the Initial Limit. This sets the size of the connection cache when the cache is initially created or reinitialized. When this property is set to a value greater than 0, then that number of connections are pre-created and are ready for use.

curam.db.oracle.connectioncache.name

STRING

The name used to identify the cache uniquely.

curam.db.zos.32ktablespace

STRING

Property which specifies the name of the table space used for 32k storage on DB2 z/OS.

curam.db.zos.enableforeignkeys

BOOLEAN

Controls whether foreign keys are generated for a z/OS database when running the Data Manager. Note on usage - If Foreign Keys are used against a z/OS database, the tables are put in a CHECK_PENDING state, causing failures when the tables are accessed. The state can only be changed through direct DBA intervention on the target platform (hence it cannot be scripted into the Data Manager which can run on remote clients). In normal usage the Data Manager invokes LOB Manager after applying the foreign keys. This means the LOB manager should be re-run after the this CHECK_PENDING state has been resolved.

curam.db.disableforeignkeys

BOOLEAN

Controls whether foreign keys are generated in SQL statements. By default this property is false, which means foreign key generation is enabled. However, for z/OS foreign keys will not be generated if curam.db.zos.enableforeignkeys is set to false.

curam.db.disableInvalidLobFileError

BOOLEAN

This property controls the reporting of invalid LOB file paths in DMX files. The default value is FALSE. By default a build exception will be thrown, when set to TRUE a warning will be reported.

curam.db.zos.encoding

STRING

Property which specifies whether the database being used on z/OS requires processing for EBCDIC, ASCII, or UNICODE encoding. This should be set to EBCDIC, ASCII, or UNICODE depending on the appropriate database encoding in use. EBCDIC is the default value.

curam.db.zos.dbname

STRING

The name of the database on z/OS.

curam.database.shortnames

BOOLEAN

It is strongly recommended that this property be set to false. The functionality for this property is planned for removal in a future version of Curam. If you have utilized this property in previous versions of Curam please contact Curam Support for more information.

curam.db.oracle.servicename

STRING

The Oracle database service name. Setting this will create database connection using Oracle service name.

curam.db.name

STRING

The database name. This setting will be overridden if property "curam.db.oracle.servicename" is set for Oracle database.

curam.db.servername

STRING

The database server name.

curam.db.serverport

INT32

Suggested: 1521 (Oracle)/ 50000 (DB2). The database server TCP/IP port.

curam.db.enable.bindings.generation

BOOLEAN

Suggested: false. Causes a bindings file to be generated for the JDBC data source when a database connection is made outside of the application server, e.g. by the Batch Launcher. Has no effect if property 'curam.db.disable.bindings.generation' is set. Intended to be used to produce a starter bindings file which can then be customized.

curam.db.disable.bindings.generation

BOOLEAN

Suggested: false. Prevents re-generation of the JDBC data source bindings file and instead causes the data source to be looked up from a customized bindings file when a database connection is made outside of the application server, e.g. by the Batch Launcher.

curam.dmx.locale

STRING

Default: en. Property that specifies the locale that will be used when inserting dmx data onto the database. The locale should be specified in the format: language_country, for example en_US.

curam.db.multibyte.expansion

BOOLEAN

Enables the multi-byte expansion feature. Default value is true.

curam.db.multibyte.default.factor

FLOAT

Specifies the default expansion factor for multi byte string fields if multi byte expansion is enabled. Must be a float between the values of 1 and 4. Default value is 4.