Authority collection repository damage

Damage can occur to the authority collection repository for a user or for objects.

The damage can frequently occur during an abnormal IPL of the partition where authority collection is active for users or for objects. For performance reasons, authority collection data is not immediately written out to disk when it is collected. Forcing the data to disk would result in unacceptable performance for the authority collection due to the volume and frequency of data that is written to the repository.

Unfortunately, damage to a user's or objects authority collection repository results in the loss of the previously collected authority data. A Db2® table object can be created at any time from the active authority collection data. This creates a “snapshot” of the data. If authority collection is run for an extended period, a table object can be periodically created and updated to prevent data loss if an abnormal IPL occurs.

SELECT AUTHORIZATION_NAME, AUTHORITY_COLLECTION_ACTIVE FROM 
    QSYS2.USER_INFO WHERE
    AUTHORITY_COLLECTION_REPOSITORY_EXISTS='YES';