|
Syntax
|
Parameter
|
Purpose
|
|
-y
|
Statistics
|
Collects procedure access and usage statistics
|
|
-yc
|
Statistics with CTRL+C
|
Substitutes CTRL+C for executing the SHOW-STATS statement
|
|
-yd
|
Segment Statistics
|
Writes segment statistics to the client monitor file (client.mon by default)
|
|
-yx
|
Statistics with Cross-reference
|
Collects procedure call statistics and write them to an output file (proc.mon by default)
|
|
-ttbasetable
|
Base table of the temp-table
|
Specifies a starting temp-table number in a range of temp-tables for which you want to track access statistics; use with -tttablerangesize.
|
|
-ttbaseindex
|
Base index of the temp-table
|
Specifies a range of temp-table indexes for which you want to collect index statistics; use with -ttindexrangesize.
|
|
-tttablerangesize
|
Table range size of temp-table
|
Specifies the number of temp-tables for which you want to collect statistics.
|
|
-ttindexrangesize
|
Index range size of temp-table
|
Specifies the number of indexes of temp-tables for which you want to collect statistics.
|