SHOW AUDITPOINT

Displays information contained in an audit point file.

Scope

SQLAudit Only

SQLAudit Syntax

SQLAudit >> SHOW AUDIT [POINT] Audit Point File >> FileName

Parameters

FileName: is the name of the file containing audit point information. This file must have been previously created by the command GET AUDITPOINT.

Description

This command is used to display the audit point information contained within the indicated file.

Authorization

No authorization is required to use this command, though you must have read access to the audit point file.

Example

   SQLAudit >>show auditpoint

   Audit Point File >>ENDPT



   Creator Name:  dbauser

   Transactions Lockpoint:  Log Sequence No (184)   Page No (837)

   DBEnvironment Lockpoint:  Log Sequence No (176)   Page No (551)

   No. of Partition Instances: 7





   Audit     Partition   Global             Newlog               Local

   Name      Number      CommitID           Timestamp              CommitID

   -------   ----------  ----------------   ----------------       ----------------

   DBEONE          SECT  0000015E00000A21   2C31F1BE00055B15       0000015E00000A21

   DBEONE          AUTH  0000000C00000085   2C31F1BE00055B15     0000000C00000085

   DBEONE          STOR  0000004700000150   2C31F1BE00055B15    0000004700000150

   DBEONE           DEF  000001620001A789   2C31F1BE00055B15    000001620001A789

   DBEONE             3  000001620001D218   2C31F1BE00055B15    000001620001D218

   DBEONE             4  000001620001D218   2C31F1BE00055B15    000001620001D218

   DBEONE             5  000001620001D218   2C31F1BE00055B15     000001620001D218



   SQLAudit >>