SQL/MP Programming Manual for C

SQL/MP System Procedures
HP NonStop SQL/MP Programming Manual for C—429847-008
5-22
SQLSADISPLAY
Table 5-5 describes the elements of the SQLSADISPLAY display.
Example 5-2 displays the type of information found in SQLSADISPLAY. To generate
this display, a program follows these steps:
1. Generates the SQLSA and SQLCA structures.
2. Runs an SQL DML statement.
3. Calls the SQLSADISPLAY procedure.
Table 5-5. SQLSADISPLAY Procedure Display Elements
Element Description
\system.$vol.subvol.file
The fully qualified file name of the calling program
#line
The line number of the calling program
process cpu,pin
The CPU and PIN of the calling program
Table Name
The name of each table
Records Accessed
The number of records accessed in each table (includes
records examined by the disk process, file system, and
SQL/MP executor)
Records Used
The number of records actually used by the statement
Disc Reads
The number of disk reads caused by accessing this table
Message Count
The number of messages sent to execute operations on
this table
Message Bytes
The number of message bytes sent to access this table
Lock WE
A flag indicating either that lock waits occurred (W) or
that lock escalations occurred (E) for the table
Example 5-2. Example of the SQLSADISPLAY Display
SQL statistics @ \sanfran.$system.accts.prog10.#333.2 process 12,250
Records Records Disc Message Message Lock
Table Name Accessed Used Reads Count Bytes WE
\sanfran.$sqlvol.accts.tab10
123 22 3 10 3245
\sanfran.$vol001.fy96.employee
9987231 1 99999 1 100 e
\sanfran.$sqlvol.accts.tab20
1 1 0 1 100 w