To decrypt a fully encrypted database, use the alter database
command.
The syntax is:
alter database database_name
{decrypt [with key_name] [parallel degree_of_parallelism]
| resume decryption [parallel degree_of_parallelism]
| suspend decryption}
where:
- database_name – is the name
of the fully encrypted database you want to decrypt.
- key_name – (optional) is the
same database encryption key you used to encrypt the database. If you specify a
different key name, the command fails and SAP ASE displays an error
message.
- resume decryption – resumes the
decryption process for the database in which an earlier decryption process has
been suspended. SAP ASE ignores this command if the database_name is already completely decrypted.
- parallel degree_of_parallelism – specifies how many worker
threads to initiate for the task.
- suspend decryption – terminates
the decryption process. SAP ASE records where the process was stopped, so that
resume decrypt can restart the decryption
process at the correct place in the database.
You must have select permission on the database's
key_name to use this command.