MX Release 3.1 (H06.23+, J06.12+)

ManualsBrandsHP ManualsServerHP Integrity NonStop H-Series

Description of Returned Values:

Records Accessed

number of rows returned by disk process to EID (Executor In Disk process).

Records Used

number of rows returned by EID after selection.

Disk IOs

number of actual disk IOs performed by disk process.

Message Count

number of messages sent or received between filesystem and disk process.

Message Bytes

number of message bytes sent or received between filesystem and disk process.

Lock Escl

number of lock escalations.

Lock Wait

number of lock waits.

Disk Process Busy Time

cpu time for disk process processes for the specified table.

Examples

SQL>select * from job;

JOBCODE JOBDESC

------- ------------------

100 MANAGER

1234 ENGINEER

450 PROGRAMMER

900 SECRETARY

300 SALESREP

500 ACCOUNTANT

400 SYSTEM ANALYST

250 ASSEMBLER

420 ENGINEER

600 ADMINISTRATOR

200 PRODUCTION SUPV

--- 11 row(s) selected.

SQL> get statistics;

Start Time 2011/07/18 21:45:34.082329

End Time 2011/07/18 21:45:34.300265

Elapsed Time 00:00:00.217936

Compile Time 00:00:00.002423

Execution Time 00:00:00.218750

Table Name Records Records Disk Message Message Lock Lock Disk Process

Accessed Used I/Os Count Bytes Escl Wait Busy Time

SCH.TOI.JOB 2 2 0 4 15232 0 0 363

--- SQL operation complete.

GOTO command

The goto command allows you to jump to a designated point later in the command list. The point

in the command list is indicated by a label. All commands run after a goto command are ignored

until the specified label is set. To set a label, use the “LABEL command” (page 71). The goto

command is typically used with the IF...THEN command, for conditional execution of other

commands. For IF...THEN command usage, see “IF...THEN command” (page 69) .

GOTO command 67