Operator Messages Manual

Chapter 102 SQLAUDIT Messages

The messages in this chapter are sent by the NonStop SQL/MP audit fix-up process. The subsystem ID displayed by these messages includes SQLAUDIT as the subsystem name.




	NOTE: Negative-numbered messages are common to most subsystems. If you receive a negative-numbered message that is not described in this chapter, see Chapter 15.

1

Audit fix-up process initialized Time to perform initialization: interval secs

interval

is the interval since the last status message for a given audit fix-up process servicing the request.

Cause The audit fix-up process has been initialized.

Effect The audit fix-up process is ready to accept fix-up requests.

Recovery Informational message only; no corrective action is needed.

2

** Audit fix-up process status ** Time since last status : interval secs Distance to audit EOF : aud-distance-to-eof kbytes Records read : aud^recs^read recs Records queued for redo : aud^recs^redo recs Read rate : aud^read^rate bytes/sec Redo queueing rate : {+|-} aud^redo^rate bytes/sec Progress rate : {+|-} aud^prog^rate bytes/sec

`interval`	is the interval since the last message for the request was processed.
`aud-distance-to-eof`	is a computed amount of audit information, logically merged from one or more audit files, determined to be necessary for the fix-up operation.
`aud`^`recs`^`read`	is a running total of the number of audit records read during the audit fix-up operation.
`aud`^`recs`^`redo`	is a running total of the number of audit records redone during the audit fix-up operation.
`aud`^`read`^`rate`	is the rate in bytes per second that audit information was generated in the audit trails since the last status report.
`aud`^`redo`^`rate`	is the rate in bytes per second that audit information was redone during the last reporting period.
`aud`^`prog`^`rate`	is the rate in bytes per second that an operation is approaching the logical (merged) audit end-of-file (EOF) during the last reporting period. This number can be negative and is always negative during the load phase of an operation. A negative number means that the audit trail is being created faster than the fix-up process can use it. The number might not be available for the first few status reports, in which case it is represented as a question mark (?).

Cause The progress of the audit fix-up operation is indicated at five-minute intervals.

Effect None. You can use this information to predict when the operation will finish.

Recovery Informational message only; no corrective action is needed.

3

Audit fix-up process aud-num started

aud-num

is the ordinal position of an audit fix-up request. Several audit fix-up requests can be made through the execution of an operation that uses WITH SHARED ACCESS. There are always at least two requests.

Cause An audit fix-up application request was made.

Effect The audit fix-up process has been started.

Recovery Informational message only; no corrective action is needed.

4

Audit fix-up process aud-num completed Duration: interval secs

`aud-num`	is the ordinal position of an audit fix-up request.
`interval`	is the interval since the last message for the request was processed.

Cause An audit fix-up application request is finished.

Effect The audit fix-up process has received a request and responded to it.

Recovery Informational message only; no corrective action is needed.

5

Audit fix-up process terminated

Cause The audit fix-up function is finished.

Effect The audit fix-up process stops.

Recovery Informational message only; no corrective action is needed.

101

** ABEND ** Audit fix-up process: process-name Program : program-name [ ** TRAP tt ** ] [ ** AudServ Internal Error ** ] [ Exception Class : exception-class-code ] [ Audit Fix-up Error : audit-fix-up-error-code ] [ S : %ssssss P : %pppppp E : %eeeeee L : %llllll ]

`process-name`	is the name of the audit fix-up process.
`program-name`	is the program file name of the audit fix-up process.
`tt`	is the NonStop Kernel trap number in decimal.
`exception-class-code`	is additional information about the error condition.
`audit-fix-up-error-code`	is an error code generated by NonStop SQL/MP. For information about the error, use the ERROR command from the SQL Conversational Interface (SQLCI).
`ssssss`	is the contents of the stack (S) register in octal.
`pppppp`	is the contents of the program (P) register in octal.
`eeeeee`	is the contents of the environment (E) register in octal.
`llllll`	is the contents of the local (L) register in octal.

Cause A trap or fatal error occurred in the NonStop SQL audit fix-up process.

Effect The audit fix-up process terminates and the associated operation terminates abnormally.

Recovery Depending on the cause of the failure, the operation might complete successfully if resubmitted. If an audit fix-up error code is present, check the code for more information and correct the problem if possible. Otherwise, contact the Global NonStop Solution Center (GNSC) and provide all relevant information as follows:

Descriptions of the problem and accompanying symptoms
Details from the message or messages generated, including the trap number, exception class code, and audit fix-up error (if supplied in the message).
Supporting documentation such as Event Management Service (EMS) logs, SAVEABEND files, and a processor dump, if applicable

If your local operating procedures require contacting the Global Mission Critical Solution Center (GMCSC), supply your system number and the numbers and versions of all related products as well.