Sybase IQ database decryption

[SAPSupport]

Would like to decrypt IQ database. 
What is decryption procedure?
 

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Currently, there is no option to disable IQ db encryption.
To decrypt IQ database, recreate new un-encrypted database and reload data:

1. Use -n option (of iqunload) to extract schema only from encrypted database.
   
   
2. Create the un-encrypeted database
   
   
3. Review the unloaded sql schema. Modify it if necessary
   
   
4. Implement the extracted schema in the un-encrypeted database
   
   
5. Extract data using extract options in Binary Format
   
   
6. Load data to tables (Binary Format) in the unencrypted database
   See extract/load examples provided in
     1984992 - How to backup and restore across different endian formats - SAP IQ  
   
   
7. Alternatively, ETL tools like IQ Data Services can be used to transfer data.
   
   see IQ Community : list of ETL tools supported by SAP IQ

See also

0002611853 - How to encrypt the database - SAP IQ

0002228977 - How to use a database encryption key - SAP IQ

Blog - SAP IQ and Data Encryption - what is right?

Regards,
SAP Support