removedb

Description

Removes the ACDB.

Syntax

removedb 
[--asadb_acdb_owner_group acdb_owner]
[--asedb_datadevice datadevice]
[--asedb_logdevice logdevice]
[--database_local true | false]
[--database_type sybase_ase | sybase_asa | oracle]
[--entldb_username username]
[--jdbc_admin_password password]
[--jdbc_admin_username user_name]
[--jdbc_driver driverName] 
[--jdbc_url jdbcURL] 
[--populate_only true | false]
[--sybase_asa_servicename service_name]

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

database_local

boolean

If true, removes the devices after dropping the database; otherwise, you must do this manually.

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_username

string

acdbdbo

The user name for connecting to the ACDB. This user should have read and write privileges on the ACDB only.

jdbc_admin_password

string

The password for the user specified by jdbc_admin_username.

jdbc_admin_username

string

sa

The 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

The JDBC driver to use when connecting to the database.

jdbc_url

string

Depends on the value of database_type; for sybase_ase:

jdbc:sybase:Tds:host: 5000/acdb

The JDBC URL to use when connecting to the database.

populate_only

boolean

false

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

sybase_asa_servicename

string

acdb

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

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 removes the ACDB using the default values:

securetool removedb

See also

createdb createschema populatedb querydb upgradedb