Viewing database encryption history

You can view the history for database encryption. If you encrypt or reencrypt the database, a new entry is logged in the syschangetracker table in the Maximo database.

The syschangetracker table contains the following columns:

PROCESSNAME
MESSAGE
CHANGEBY
CHANGEDATE
WORKSPACEID
APPID
INSTANCENAME
SYSCHANGETRACKERID
ROWSTAMP

If you have issues with encryption keys, the record in the syschangetracker table helps to identify whether reencryption occurred and when it occurred. The MESSAGE column includes the first 2 bytes and last 2 bytes of the encryption key. The MESSAGE column can help you identify the encryption keys that are being used.