Effect of utilities on encrypted data

In Db2, you can encrypt data through built-in functions. You can copy and recover this encrypted data. You can also move encrypted data between systems. Data remains encrypted throughout these processes.

Running any of the following utilities on encrypted data might produce unexpected results:

• CHECK DATA
• LOAD
• REBUILD INDEX
• REORG TABLESPACE
• REPAIR
• RUNSTATS
• UNLOAD
• DSN1PRNT