How are you all taking a SAVF of a library that has tables encrypted with PowerTech and restoring that SAVF onto a completely different IBMi to refresh your dev libraries?
We currently decrypt everything (requires a complete outage of our systems so Powertech can get an exclusive lock on files) and then do the SAVF, then re-encrypt everything.
This takes a lot of downtime to perform, making data refreshes to other partitions very difficult and subsequently very infrequent due to the difficulty.
It is with this difficulty that we are contemplating switching to IBMi's built in full disk encryption instead and chuck Powertech out the window since we only use it for the data at rest functionality.
So we could get full disk coverage instead of the handful of columns from a few database files that have PII data in them encrypted. Additionally, we could finally do a WHERE SSN like %123% query again without bring the CPU to 100% for 5 minutes because the Powertech field procedure is choking on the data.
Thoughts?
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
