MODIFY AUDITPOINT [ ALLBASE/SQL Database Administration Guide ] MPE/iX 5.5 Documentation
ALLBASE/SQL Database Administration Guide
MODIFY AUDITPOINT
Modifies the current audit point information for the DBEnvironment.
Scope
SQLAudit Only
SQLAudit Syntax
SQLAudit >> MOD[IFY] AUDIT[POINT] Audit Point File >> FileName
{? }
{@ }
{PartNumber }
Partition Number >> {DEF[INITION] } Modify Current Audit Point
{AUTH[ORIZATION]}
{STOR[AGE] }
{SECT[ION] }
Information (n/y) >> {n[o] }
{y[es]}
Parameters
FileName is the name of the audit point file containing
unloaded SCR (or transaction) information. This
file would have been created by running SQLAudit
on the master DBEnvironment. If no audit point
filename is entered, SQLAudit will delete
transaction (SCR) information for the specified
list of partitions.
PartNumber is the number for a partition for which you wish
to modify the transaction information.
NO or YES respond NO if you do not want to modify the
current audit point information in the DBE;
respond YES if you do want to modify the current
audit point information in the DBE.
Description
* This command should only be used for ALLBASE/REPLICATE
DBEnvironments, and it should only be necessary during hard
resynchronization of a given set of partitions. This command
should not be necessary for audit only DBEnvironments that are not
using ALLBASE/REPLICATE.
* This command is used to modify the current audit point information
to reflect new transaction information for the specified set of
partitions. This command can be used in two different ways. The
first way it can be used is to replace the transaction information
for the given set of partitions with new transaction information
from the audit point file entered. The second way it can be used
is to delete transaction information for a given set of
partitions. This command can be used while the DBEnvironment is
in use.
* If the user enters an audit point filename, SQLAudit will replace
the DBEnvironment transaction (SCR) information with information
from the audit point file (for the given set of partitions). This
file is assumed to have been created by running SQLAudit against
the master DBEnvironment (using the GET AUDITPOINT command). If
no transaction information is found in the audit point file for a
specified partition, the transaction information for the partition
will be deleted from the DBEnvironment. The audit point
information from the file will be used to list the current set of
partitions.
* If the user did not enter an audit point filename, SQLAudit will
delete all transaction information for the user specified list of
partitions. If no audit point filename is entered (the user just
pressed RETURN), SQLAudit will retrieve the current audit point
information from the DBEnvironment. This audit point information
will be used to list the current set of partitions.
* You must be connected to the DBEnvironment to use this command.
If you have not connected to the DBE (using the SET DBENVIRONMENT
command), SQLAudit will issue a warning and automatically issue
the SET DBENVIRONMENT command on your behalf.
Authorization
You must have DBA authorization in order to use this command.
Example
SQLAudit >> modify auditpoint
Audit Point File >> MasterPt
System Partitions are DEF[INITION], AUTH[ORIZATION], STOR[AGE] or SECT[ION].
Please enter Partition Numbers or System Partitions. Type @ for all,
? for a list of Partitions, or RETURN to quit.
Partition Number >> 1
Partition Number >> 2
Partition Number >>
Modify Current Audit Point Information (n/y) >> yes
Current audit point information has been modified.
SQLAudit >>
SQLAudit >> modify auditpoint
Audit Point File >>
Audit point information will be deleted for the specified partitions.
System Partitions are DEF[INITION], AUTH[ORIZATION], STOR[AGE] or SECT[ION].
Please enter Partition Numbers or System Partitions. Type @ for all,
? for a list of Partitions, or RETURN to quit.
Partition Number >> 3
Partition Number >>
Modify Current Audit Point Information (n/y) >> yes
Current audit point information has been modified.
SQLAudit >>
MPE/iX 5.5 Documentation