Viewing database encryption history

You can view the history for database encryption. Whenever 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 provides the first 2 bytes and last 2 bytes of the encryption key, which can help you identify the encryption keys that are currently being used. The following image shows an example of the syschangetracker table:
Figure 1. The syschangetracker table
Syschangetracker table