Starts a server task that prints out all perfmon counters at specified intervals to a file.
▪ filename: The name of the output file. The performance data is output in comma-separated value format; the first row contains the counter names, and each subsequent row contains the performance data per each sampling time.
The default file name is pmondiff.out.
▪ interval: The interval in milliseconds at which performance data is collected.
The default interval is 1000 milliseconds.
The following command starts a task that outputs performance data to myd.csv file on 500 milliseconds interval:
ADMIN COMMAND 'pmon diff start myd.csv 500'
You can use PMON filters to allow the use of wildcard characters. The following special characters can be used in the search pattern:
▪ % matches any value of zero or more characters.
▪ _ matches any value of a single character.
▪ $ matches the end of the string. End of string match ($) and wildcard characters % and _ are not allowed in the same search pattern. Any pattern with % or _ has an implicit $ at the end. For example, "%bonsai" is the same as "%bonsai$".
▪ The pattern must match the beginning of the string.
▪ A pattern without any wildcard characters has an implicit % at the end. For example, "bonsai" is the same as "bonsai%".
Examples
Match PMONs that contain keyword "bonsai".
solcon -e"pmon %bonsai%" "tcp 1964" dba dba
Match PMONs that end with "bonsai".
solcon -e"pmon %bonsai" "tcp 1964" dba dba
Match PMONs that end with "bonsa" and any additional single character