Setting up statistic collection
To set up statistic collection on files, use the dbdst_fstat command.
For SMS tablepsaces, you can only collect statistics on files with extensions *.DAT, *.INX, and *.LB if the -t tablespace option is used.
Table: dbdst_fstat command options shows the dbdst_fstat command options.
Table: dbdst_fstat command options
Option
|
Description |
-o start | stop
|
Starts or stops file statistics collection. |
-o stopall
|
Stops all statistics collection. |
-o list
|
Lists files for which statistics are to be collected. |
-f listfile
|
Specifies a user-defined file that contains a list of files on which to gather statistics. |
filename
|
Specifies the file on which to gather statistics. |
-t tablespace
|
Specifies the tablespace on which to gather statistics. |
To start collecting statistics on a file