HP NonStop Shadowbase Command Definitions
Consumer Command Descriptions
HP NonStop Shadowbase Command Reference Manual—785421-002
189
AVG LWAIT is the average amount of time the Consumer was waiting on a
lock (before SQL returns an error).
RETRY WAIT is the total amount of time the Consumer was delaying
between I/O retries as a result of the CONS RETRYDELAY parameter
setting.
%TWAIT is the percentage of the stats duration that the CONS is waiting on
locks and delaying before retrying.
AVG TWAIT is an I/O average duration that the CONS is waiting on locks
and delaying before retrying.
USER EXIT INFO (I/O EVENTS, TRANSACTION EVENTS) – This
section shows information relating to user exit processing. This section
is only displayed when user exit activity has occurred in the
consumer.
NUM USRXEV shows the number of USRXPROCESS calls associated with
insert, update, and delete events. This is the number of times that the
customer’s user exit code was invoked because the DBS USEREXITID
value was non-zero.
USRXEV TIME shows the amount of time the CONS has spent executing in
the USRXPROCESS and underlying code to process insert, update, and
delete events. This is the total time (wall clock) that the CONS was
executing user exit code. A large value may indicate that the user exit
code is inefficient.
%USRXEV shows the percentage of time the CONS has spent executing in
the USRXPORCESS and underlying code to process insert, update, and
delete events.
NUM USRXTR shows the number of USRXPROCESS calls associated with
“end transaction” events (i.e.,i.e., the number of times the customer’s user
exit code was invoked to process transaction abort and commit events).
USRXTR TIME shows the amount of time the CONS spent executing in
USRXPROCESS and underlying code to process “end transaction” events
(i.e.,i.e., the amount of time the customer’s user exit code spent
processing abort and commit transaction events).
%USRXTR shows the percentage of time the CONS has spent executing in
USRXPROCESS and underlying code to process “end transaction”
events.
NUM USRXEX when output, is the number of USRXEXCEPTION calls
associated with SQL target I/O error conditions.
USRXEX TIME shows the amount of time the CONS has spent executing in
the USRXEXCEPTION and underlying code to handle SQL target I/O
error conditions.
%USRXEX shows the percentage of time the CONS has spent executing in
the USRXEXCEPTION and underlying code to handle SQL target I/O
error conditions.
Comentários a estes Manuais