HP 3000 Manuals

ALLBASE/SQL Database Administration Guide

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 >>

MPE/iX 5.5 Documentation