Reads in options from the specified environment variable or configuration file.
To protect passwords or other information in the configuration file, you can use the File Hiding utility to obfuscate the
contents of the configuration file.
Specifies the encryption key for strongly encrypted databases directly in the command. If you have a strongly encrypted database,
you must provide the encryption key to use the database or transaction log in any way. For strongly encrypted databases, you
must specify either -ek or -ep, but not both. The command will fail if you do not specify the correct key for a strongly encrypted
Specifies that you want to be prompted for the encryption key. This option causes a window to appear, in which you enter the
encryption key. It provides an extra measure of security by never allowing the encryption key to be seen in clear text. For
strongly encrypted databases, you must specify either -ek or -ep, but not both. The command will fail if you do not specify
the correct key for a strongly encrypted database.
Writes output messages to the named file.
Runs in quiet mode—messages are not displayed. If you specify this option, you must also specify -y, otherwise the operation
Deletes each file without being prompted for confirmation. If you specify -q, you must also specify -y, otherwise the operation
With the Erase utility, you can erase a database file and its associated transaction log, or you can erase a transaction log
file or transaction log mirror file. All database files and transaction log files are marked read-only to prevent accidental
damage to the database and accidental deletion of the database files.
The database-file may be a database file or transaction log file. The full file name must be specified, including extension. If a database
file is specified, the associated transaction log file (and mirror, if one is maintained) is also erased.
The Erase utility does not erase dbspaces. To erase a dbspace, use the DROP DBSPACE statement.
Deleting a database file that references other dbspaces does not automatically delete the dbspace files. To delete the dbspace
files on your own, change the files from read-only to writable, and then delete the files individually. Alternatively, you
can use the DROP DATABASE statement or the Erase Database Wizard to erase a database and its associated dbspace files.
If you erase a database file, the associated transaction log and transaction log mirror are also deleted. If you erase a transaction
log for a database that also maintains a transaction log mirror, the mirror is not deleted.
The database being erased must not be running when this utility is used.