Specifying an event

Triggering events can be specified in server startup parameters, and can be modified at runtime with PROMON or by editing the _dbParams VST.

To specify the triggering event at startup, use the -diagEvent parameter. The -diagEvent accepts a character string of comma-separated keywords and a data collection level that identify the triggering event(s) to capture data for and the amount of data.

The accepted keywords for -diagEvent, are:

You specify the level of data collection by adding :n to the event. Valid values for n range from -15 to 15.

The following example demonstrates specifying the locktable and syserror triggering events:

If you do not specify an event, it is set with the value specified by -diagEvtLevel. By default, -diagEvtLevel is 0, meaning that data collection for that event is off.