Prior to removing any Storage Area, ensure that all tables, indices, and lobs for the area have been moved to other areas if they need to be preserved (with tablemove for example) or completely deleted from the database schema after truncating the area. Refer to Article
When removing an
Encrypted Storage Area, additionally encryption area policies must be removed before the Area Extents are removed from the database structure.
To Remove Encryption Area Policies:1. Remove the encryption policy entry from the encryption policy area, the area must be decrypted by changing the cipher to cipher 0 and then using epolicy manage update of the empty area to fully disable the encryption policy for the area.
$ proutil <dbname> -C truncate area "<AreaNameHere>"
$ proutil <dbname> -C epolicy manage area cipher "<AreaNameHere>" -Cipher 0 -Passphrase
$ proutil <dbname> -C epolicy manage area update "<AreaNameHere>" -Passphrase
$ proutil sports2000 -C epolicy view area "<AreaNameHere>"
Epolicy / 1 : No encryption policies found for AREA (15220)
2. Remove the decrypted Storage Area:
$ proutil <dbname> -C truncate bi
$ prostrct remove <dbname> d "<AreaNameHere>"
