Running DDDAUDIT

The Database Audit Report (DDDAUDIT) finds inconsistencies between PeopleTools record and index definitions and the database objects. This audit consists of queries that check tables, views, indexed views, materialized query tables, materialized views, indexes, and triggers.

DDDAUDIT.SQR is located in PS_HOME\sqr.

When you run DDDAUDIT.SQR, its results are written to a file called DDDAUDIT.LIS in the \TEMP folder. After running DDDAUDIT, you can view the .LIS file using any text editor.

The following tables list the names of each query that DDDAUDIT performs on the PeopleSoft system. The tables elaborate on the query type, if any row is returned on running the query then what does it suggest, and how to resolve the inconsistencies.

Note:

The query names in this table are arranged alphabetically, and are not necessarily in the order in which they appear in DDDAUDIT.LIS: