HP Integrity NonStop H-Series Uživatelská příručka stáhnout pdf (Strana 197)

HP NonStop Shadowbase Command Definitions

Consumer Command Descriptions

HP NonStop Shadowbase Command Reference Manual—785421-002

188

quite busy or is inefficient (e.g., too many index levels in the table or

index).

%I/O shows the percentage of time the CONS has spent executing SQL

statements against the target tables (for inserts, updates, and deletes)

during this statistics interval.

AVG I/O shows the average SQL I/O time computed by dividing the TARG

I/O counter into the I/O TIME. If high, this could indicate that the file

system is quite busy or is inefficient (e.g., too many index levels in the

table or index).

SQL LOCK ERROR INFO – This section shows lock error information

about SQL target table I/O activity.

NUM ERRORS is the number of target I/O lock errors that have occurred.

LOCK WAIT is the total amount of time the Consumer was waiting on locks

(before SQL returns an error).

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.

ENSCRIBE I/O INFO – This section shows information about Enscribe I/O

activity.

TARG I/O shows the number of Enscribe I/O operations executed against

the target files (for inserts, updates, and deletes).

I/O TIME shows the amount of time the CONS has spent executing

Enscribe I/O against the target files (for inserts, updates, and deletes). If

high, this could indicate that the file system is quite busy or is inefficient

(e.g., too many levels in the file or alternate key).

%I/O shows the percentage of time the CONS has spent executing

Enscribe I/O against the target files (for inserts, updates, and deletes)

during this statistics interval.

AVG I/O shows the average Enscribe I/O time computed by dividing the

TARG I/O counter into the I/O TIME. If high, this could indicate that the

file system is quite busy or is inefficient (e.g., too many levels in the file or

alternate key).

ENSCRIBE LOCK ERROR INFO – This section shows lock error

information about Enscribe target file I/O activity.

NUM ERRORS is the number of target I/O lock errors that have occurred.

LOCK WAIT is the total amount of time the Consumer was waiting on locks

(before SQL returns an error).

1 2 ... 192 193 194 195 196 197 198 199 200 201 202 ... 345 346

Komentáře k této Příručce

Žádné komentáře

HP Integrity NonStop H-Series Uživatelská příručka Strana 197

Komentáře k této Příručce

Související produkty a manuály pro Software HP Integrity NonStop H-Series