Skip to main content
Question

How to restore encrypted DB2 database to unencrypted DB2` Database


Forum|alt.badge.img+5

Dear Community,

I’m asking how to restore encrypted DB2 database to an unencrypted location Since it’s doable from DB2 side using command line, I mean how to configure NO ENCRYPTION for restore job from commserve side ?

 

Thanks in advance

2 replies

Forum|alt.badge.img+5

Dear Community,

 

Our case is when we try to run out-of-place restore for tablespace of an encrypted DB the jobs goes into pending state at 5% and we get the following error:

SQL2032N  The "piDbEncOpts" parameter is not valid.

 


Forum|alt.badge.img+13

Hi ​@Ahmed Elbably 

The destination needs to be configured with encrypted db, please follow the steps from docs https://documentation.commvault.com/2024e/expert/preparing_destination_db2_database_instance_for_encrypted_database_restore_01.html


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings