The SQLSC_VERSION (SCV) table consists of one row for each version of a query in the Cache. A query has multiple versions only when an optimization or restriction has been specified.
Statistics are not saved across MUF executions, except that statistics for the original version are saved at the time the first optimized version is created.
In the SCV table that follows, “RSU” is an abbreviation for Resource Units. This is the same unit of measure used by the CBSIO plan option.
Note: In a future release, it is planned to include in the SCV table a group of columns that provide Elapsed Time Statistics.
|
Column Name |
SQL Data Type |
Nullable |
Description |
|---|---|---|---|
|
SCV_ID |
CHAR(16) |
No |
Unique ID |
|
SCV_SCE_ID |
INTEGER |
No |
References SQLSC_ENTRY |
|
SCV_STMT_ID |
INTEGER |
No |
References an optimized statement, else zero |
|
SCV_VERSION |
SMALLINT |
No |
Version 0 is original query |
|
SCV_ADDED_TS |
TIMESTAMP |
No |
When query first added to Cache |
|
SCV_MATCHES |
INTEGER |
No |
Total matches |
|
SCV_MATCH_LAST_TS |
TIMESTAMP |
No |
When last matched |
|
Elapsed Time Statistics |
|
|
|
|
SCV_ELAPSED_LIMIT_TS |
TIMESTAMP |
No |
When limit was set last |
|
SCV_ELAPSED_LIMIT |
INTEGER |
No |
maximum seconds query can execute |
|
SCV_TIMED_OUT_CNT |
INTEGER |
No |
Number times query has been timed-out |
|
SCV_ELAPSED_LAST |
INTEGER |
No |
Last elapsed time in MUF in seconds |
|
SCV_ELAPSED_MAX |
INTEGER |
No |
Maximum elapsed time in MUF in seconds |
|
SCV_ELAPSED_MAX_TS |
TIMESTAMP |
No |
When maximum elapsed time occurred |
|
SCV_ELAPSED_MIN_TS |
TIMESTAMP |
No |
When minimum elapsed time occurred |
|
SCV_ELAPSED_MIN |
INTEGER |
No |
Minimum elapsed time in MUF in seconds |
|
SCV_ELAPSED_TOTAL |
INTEGER |
No |
Total elapsed time |
|
Resource Unit (RSU) Statistics |
|
|
|
|
SCV_RSU_LIMIT |
INTEGER |
No |
CBSIO limit |
|
SCV_RSU_LIMIT_CNT |
INTEGER |
No |
Times limit reached |
|
SCV_RSU_LAST |
INTEGER |
No |
Last RSU in MUF in seconds |
|
SCV_RSU_MAX |
INTEGER |
No |
Maximum RSU in MUF in seconds |
|
SCV_RSU_MAX_TS |
TIMESTAMP |
No |
When maximum RSU occurred |
|
SCV_RSU_MIN_TS |
TIMESTAMP |
No |
When minimum RSU occurred |
|
SCV_RSU_MIN |
INTEGER |
No |
Minimum RSU in MUF in seconds |
|
SCV_RSU_TOTAL |
INTEGER |
No |
Total RSU |
|
Row Statistics |
|
|
|
|
SCV_ROWS_ACCEPTED_AVG |
INTEGER |
No |
Average rows accepted |
|
SCV_ROWS_SORT_AVG |
INETGER |
No |
Average rows sorted for GROUP/ORDER/UNION |
|
SCV_ROWS_INDEX_AVG |
INTEGER |
No |
Average total index entries scanned |
|
SCV_ROWS_DATA_AVG |
INTEGER |
No |
Average total data area rows scanned |
|
SCV_ROWS_MERGE_AVG |
INTEGER |
No |
Average total rows sorted for a merge join |
|
SCV_ROWS_SUBQRY_AVG |
INTEGER |
No |
Average total rows searched in subqueries |
|
Copyright © 2014 CA.
All rights reserved.
|
|