Neoview Command Interface (NCI) Guide (R2.4)

THOMAS SPINNER
--- 5 row(s) selected.
SQL>fc
SQL>select first_name, last_name
.... R empnum,
SQL>select empnum, last_name
....
SQL>from persnl.employee
....
SQL>where jobcode=450;
....
Pressing Enter lists the employee number and last names of all employees whose job code
is 450:
EMPNUM LAST_NAME
------ --------------------
180 CONRAD
215 LANCASTER
216 JONES
225 HELMSTED
232 SPINNER
--- 5 row(s) selected.
SQL>
GET STATISTICS Command
The GET STATISTICS command returns formatted statistics for the last executed SQL statement.
Syntax
GET STATISTICS
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 done by disk process.
Message Count
number of messages sent/received between filesystem and disk process.
Message Bytes
number of message bytes sent/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.
GET STATISTICS Command 99