createdb

Description

Creates the ACDB.

Syntax

createdb --rootorg_dn org_DN --rootorg_name org_name
[--asadb_acdb_owner_group acdb_owner]
[--asedb_datadevice datadevice]
[--asedb_datafile filename] 
[--asedb_datasize dbsize]
[--asedb_logdevice logdevice]
[--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] 
[--guest_password password] 
[--jdbc_admin_password password] 
[--jdbc_admin_username user_name] 
[--jdbc_driver driverName] 
[--jdbc_url jdbcURL] 
[--oracle_data_tablespace dataSpace]
[--oracle_index_tablespace indexSpace]
[--populate_only true | false] 
[--portaladmin_password password] 
[--pso_password password]
[--psoemail email] 
[--psoname psoName] 
[--psophone phone] 
[--psouid psoUID] 
[--random_seed seed]
[--rootorg_address address] 
[--rootorg_contact contact] 
[--rootorg_desc description] 
[--sybase_asa_servicename service_name]
[--webplugin_password password] 

Argument

Datatype

Default value

Description

* rootorg_dn

string

Root organization DN. This is usually derived from the domain of the server. For example, a server in the domain MyCompany.com might have a root organization DN of dc=MyCompany,dc=com.

* rootorg_name

string

Root organization name.

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_datadevice

string

acdbData

The Adaptive Server Enterprise device on which the database data segment is created. This device will be created if it does not exist.

asedb_datafile

string

Adaptive Server database data device file name.

asedb_datasize

integer

100MB

Adaptive Server database data device file size in MB.

asedb_logdevice

string

acdbLog

The Adaptive Server Enterprise device on which the database log segment is created. This device will be created if it does not exist.

asedb_logfile

string

Adaptive Server database log device file name.

asedb_logsize

integer

25MB

Adaptive Server database log device file size in MB.

asedb_pagesize

integer

2048

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

NoteThis 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.

guest_password

string

guest

Password for the guest user.

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 the name of the JAR file containing the Oracle drivers (typically, classes12.zip) 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/

populate_only

boolean

false

If using a JDBC database with an existing schema, set to true. In this case, only the initial data is inserted or removed.

portaladmin_password

string

sybase

Password for the Portal Administrator.

pso_password

string

123qwe

Password for the user specified by psouid.

psoemail

string

Security Officer’s e-mail address.

psoname

string

Portal Security Officer

Name of the Security Officer.

psophone

string

Security Officer’s phone number.

psouid

string

pso

Security Officer’s user ID.

random_seed

integer

An integer to use as the random seed.

rootorg_address

string

Root organization’s address.

rootorg_contact

string

Root organization contact name.

rootorg_desc

string

Root organization description.

sybase_asa_servicename

string

acdb

The SERVICENAME connection property to use when connecting to a Sybase ASA database.

webplugin_password

string

sybase

Web server plug-in user password.

Returns

Return value

Indicates

0

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

1

The command failed.

Examples

Example 1

This command line example creates an ACDB for the root organization Sybase.com:

securetool createdb --rootorg_name Sybase.com --rootorg_dn dc=sybase,dc=com

See also

createschema populatedb querydb removedb upgradedb