Sandbox.cfg database properties

The following are sandbox.cfg Database properties and descriptions.

Property

Description

Database

These are database-related properties that can be changed after installation. Use the vendor-specific properties in this section to make changes to your installed database's properties.

Note: You cannot change the database provider for a specific smcfs instance after installation.

DB_SCHEMA_OWNER

Default schema/schema-owner for the provided login ID.

JDBC_VENDOR

JDBC driver vendor. Used when multiple vendor are available. Default is Microsoft.

DB2_DATA

If using Db2, the database name to connect with.

DB2_HOST

If using Db2, the database host to connect to.

DB2_PASS

If using Db2, the database password to connect with.

DB2_PORT

If using Db2, the database listener port.

DB2_USER

If using Db2, the database login ID to connect with.

ORA_HOST

If using Oracle, the database host to connect to.

ORACLE_NLS_LENGTH_SEMANTICS

Indicates the type of length semantic to be used for Oracle database, when using the dbverify tool.

Valid values = CHAR or BYTE

Default: BYTE

Example: BYTE

Note: If the database or the specific session in which database was created has length semantic as CHAR, this property should be set to CHAR before running the dbverify tool.

ORA_PASS

If using Oracle, the database password to connect with.

ORA_PORT

If using Oracle, the database listener port.

ORA_TS

Indicates the kind of text search index to be used for Oracle database, when using the dbverify tool.

Valid values = CTXCAT or CONTEXT

Default: CTXCAT

Example: CTXCAT

ORA_USER

If using Oracle, the database login ID to connect with.