Decrypt an Encrypted Database

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.