Specifies the number of refresh cycles for which screens are displayed
SQLMON Only
SET C [YCLE] [ NumCycles OFF ]
Specifies that SQLMON displays screens for NumCycles - 1 refresh cycles before returning you to the prompt. An integer value.
Specifies that SQLMON displays screens until you press Return. The logical equivalent of a NumCycles value of infinity. The default value.
This command is useful in batch jobs. If you use SQLMON interactively, you can set NumCycles to OFF and then exit screens by pressing Return.
See "Creating Batch Reports" in the chapter "Getting Started with SQLMON."
When you issue the following command, SQLMON splays a screen once and refreshes it twice:
SQLMONITOR OVERVIEW => SET CYCLE 3
If you omit the integer after SET CYCLE, SQLMON prompts for it, as follows:
SQLMONITOR OVERVIEW => SET CYCLE NUMBER OF CYCLES <OFF=INFINITY>: 3