createschema

Description

Creates the schema for the ACDB.

Syntax

createschema [--asadb_acdb_owner_group acdb_owner] [--asedb_datafile filename] [--asedb_datasize dbsize] [--asedb_logfile logfile] [--asedb_logsize logsize] [--asedb_pagesize pagesize] [--asedb_trunc_on_checkpoint true | false] [--database_type sybase_ase | sybase_asa | oracle] [--entldb_password password] [--entldb_username user_name] [--jdbc_admin_password password] [--jdbc_admin_username user_name] [--jdbc_driver driverName] [--jdbc_url jdbcURL] [--oracle_data_tablespace dataSpace] [--oracle_index_tablespace indexSpace]

Argument	Datatype	Default value	Description
asadb_acdb_owner_group	string	ACDB_owner	The ACDB group owner that is created when you install the database. This group owns the ACDB tables and procedures.
asedb_datafile	string		Adaptive Server database data device file name.
asedb_datasize	integer	100MB	Adaptive Server database data device size, in MB. On an existing data device, this much space must exist on the device to create a new database of this size. The value of asedb_pagesize must be set correctly.
asedb_logfile	string		Adaptive Server database log device file name.
asedb_logsize	integer	25MB	Adaptive Server database log device file size, in MB. On an existing data device, this much space must exist on the device to create a new database log of this size. The value of asedb_pagesize must be set correctly.
asedb_pagesize	integer	2048	Adaptive Server database page size, which is used to determine the number of pages in existing devices. This must match the value on the Adaptive Server Enterprise database server; otherwise, devices are improperly sized. This value does not change the page size on the database server.
asedb_trunc_on_checkpoint	boolean	true	Adaptive Server database option to enable truncate on checkpoint.
database_type	choice	sybase_ase	The database type. This value is used to determine the default values for the jdbc_url and jdbc_driver arguments.Acceptable values are: sybase_ase sybase_asa oracle
entldb_password	string	dbopswd	Password of the user specified by entldb_username.
entldb_username	string	acdbdbo	User name for connecting to the security database. This user should have read and write privileges on the security database only.
jdbc_admin_password	string		Password for the user specified by jdbc_admin_username.
jdbc_admin_username	string	sa	User name for connecting to the database for administrative purposes (creating databases, tables, and so on).
jdbc_driver	Java class name	Depends on the value of database_type; for sybase_ase: com.sybase.jdbc2.jdbc.SybDriver	JDBC driver to use when connecting to the database. To load Oracle drivers automatically, add their names to the SECURETOOL_CLASSPATH environment variable.
jdbc_url	string	Depends on the value of database_type; for sybase_ase: jdbc:sybase:Tds:host: 5000/acdb	JDBC URL to use when connecting to the database.
oracle_data_tablespace	string	ACDB_DATA	The tablespace on which the ACDB tables are created.
oracle_index_tablespace	string	ACDB_IDX	The tablespace on which the ACDB indexes are created/

Argument

Datatype

Default value

Description

asadb_acdb_owner_group

string

ACDB_owner

The ACDB group owner that is created when you install the database. This group owns the ACDB tables and procedures.

asedb_datafile

string

Adaptive Server database data device file name.

asedb_datasize

integer

100MB

Adaptive Server database data device size, in MB. On an existing data device, this much space must exist on the device to create a new database of this size.

The value of asedb_pagesize must be set correctly.

asedb_logfile

string

Adaptive Server database log device file name.

asedb_logsize

integer

25MB

Adaptive Server database log device file size, in MB. On an existing data device, this much space must exist on the device to create a new database log of this size.

The value of asedb_pagesize must be set correctly.

asedb_pagesize

integer

2048

Adaptive Server database page size, which is used to determine the number of pages in existing devices.

This must match the value on the Adaptive Server Enterprise database server; otherwise, devices are improperly sized. This value does not change the page size on the database server.

asedb_trunc_on_checkpoint

boolean

true

Adaptive Server database option to enable truncate on checkpoint.

database_type

choice

sybase_ase

The database type. This value is used to determine the default values for the jdbc_url and jdbc_driver arguments.Acceptable values are:

sybase_ase
sybase_asa
oracle

entldb_password

string

dbopswd

Password of the user specified by entldb_username.

entldb_username

string

acdbdbo

User name for connecting to the security database. This user should have read and write privileges on the security database only.

jdbc_admin_password

string

Password for the user specified by jdbc_admin_username.

jdbc_admin_username

string

User name for connecting to the database for administrative purposes (creating databases, tables, and so on).

jdbc_driver

Java class name

Depends on the value of database_type; for sybase_ase:

com.sybase.jdbc2.jdbc.SybDriver

JDBC driver to use when connecting to the database.

To load Oracle drivers automatically, add their names to the SECURETOOL_CLASSPATH environment variable.

jdbc_url

string

Depends on the value of database_type; for sybase_ase:

jdbc:sybase:Tds:host: 5000/acdb

JDBC URL to use when connecting to the database.

oracle_data_tablespace

string

ACDB_DATA

The tablespace on which the ACDB tables are created.

oracle_index_tablespace

string

ACDB_IDX

The tablespace on which the ACDB indexes are created/

Returns

Return value	Indicates
0	The command ran successfully; the result is true/success.
1	The command failed.

Return value

Indicates

The command ran successfully; the result is true/success.

The command failed.

Examples

Example 1

This command line example creates the schema for the ACDB using the default values:

securetool createschema

createschema

Description

Syntax

Returns

Examples

Example 1

See also