SQL/MX 3.2.1 Management Manual (H06.26+, J06.15+)

Attr[ 0/ 1] dataType: 131 offset: 4 len: 2 align: 2
Attr[ 1/ 2] dataType: 0 offset: 6 len: 15 align: 1
Attr[ 2/ 3] dataType: 0 offset: 21 len: 20 align: 1
Attr[ 3/ 4] dataType: 131 offset: 41 len: 2 align: 2
Attr[ 4/ 5] dataType: 131 offset: 45 len: 2 align: 2
nullOff: 43 nullBitIdx: -1
Attr[ 5/ -1] dataType: 133 offset: 49 len: 4 align: 4
nullOff: 47 nullBitIdx: -1
==============================================================
For more information, see “Querying SQL/MX Metadata” (page 105) and the SQL/MX Reference
Manual.
SET STATISTICS and DISPLAY STATISTICS Commands
MXCI provides the SET STATISTICS ON command, which displays statistics after each statement
executed in the session. You can also use the DISPLAY STATISTICS command to get statistics of
the last executed DML statement.
SET STATISTICS and DISPLAY STATISTICS provide statistics for statements made against either
SQL/MP or SQL/MX objects.
To obtain statistics, use either of these commands in your MXCI session:
Type this command. . .Command
Before a statement
SET STATISTICS ON;
After a statement
DISPLAY STATISTICS;
Suppose that this is the last DML command issued:
SELECT * FROM SAMDBCAT.SALES.EMPLOYEE:
You can display statistics for this statement by using the DISPLAY STATISTICS command:
DISPLAY STATISTICS;
18:18:24.4892003/12/11Start Time
18:18:24.6772003/12/11End Time
00:00:00.188Elapsed Time
00:00:00.046Compile Time
00:00:00.142Execution Time
LockMessage
Bytes
Message
Count
Disk I/OsRecords
Used
Records
Accessed
Table Name
015128206262SAMDBCAT.
PERSNL.
EMPLOYEE
For a description of the statistics displayed, see the SET STATISTICS or DISPLAY STATISTICS
commands in the SQL/MX Reference Manual.
286 Measuring Performance