End Database Monitor (ENDDBMON)

The End Database Monitor (ENDDBMON) command ends the collection of database performance statistics for a specified job, all jobs on the system or a selected set of jobs (i.e. a generic job name).

To end a monitor, you can specify the job or the monitor ID or both. If just the JOB parameter is specified, we end the monitor that was started using the same exact JOB parameter - if there is only one monitor which matches the specified JOB. If more than one monitor is active which matches the specified JOB, then the user uniquely identifies which monitor is to be ended by use of the MONID parameter. When just the MONID parameter is specified, we compare the specified MONID to the monitor ID of the monitor for the current job and to the monitor ID of all active public monitors (monitors that are open across multiple jobs). The monitor matching the specified MONID is closed.

The monitor ID is returned in the informational message CPI436A which is generated for each occurrence of the STRDBMON command. The monitor ID can also be found in column QQC101 of the QQQ3018 database monitor record.

Restrictions:

You cannot end database monitoring for a specific job by using JOB(*ALL) on the ENDDBMON command. To end a specific job you must specify that job on the JOB parameter or specify JOB(*).
If JOB(*ALL) was specified on the Start Database Monitor (STRDBMON) command, you cannot end monitoring on a per-job basis. Specifying ENDBMON JOB(*ALL) will end the monitor that is active across all jobs. Only if a specific job was specified on the JOB parameter or JOB(*) can you end monitoring for a specific job.
This command is conditionally threadsafe. It is not threadsafe (and may fail) when the OUTFILE parameter for the STRDBMON command specified a distributed file or a Distributed Data Management (DDM) file of type *SNA.

Parameters

Keyword	Description	Choices	Notes
JOB	Job name	Single values: * Other values: Qualified job name	Optional, Positional 1
	Qualifier 1: Job name	Generic name, name, *ALL
	Qualifier 2: User	Generic name, name, *ALL
	Qualifier 3: Number	000000-999999, *ALL
MONID	Monitor ID	Character value, *ALL	Optional
COMMENT	Comment	Character value, *BLANK	Optional

Top

Job name (JOB)

Specifies the job(s) for which the database monitor is to be ended.

Single values

*: The data monitor for the job running the ENDDBMON command is to be ended.
*ALL: The data monitor open across all jobs (started with JOB(*ALL)) is to be ended.

Qualifier 1: Job name

name: Specify the name of the job whose database monitor is to be ended. If no job user name or job number qualifiers are specified, all of the jobs currently in the system are searched for the specified simple job name. If duplicates of the specified job name are found, you need to specify a job user name, job number or monitor ID that uniquely identifies the job to be changed.
generic-name: Specify the generic job name of the monitor to be ended. The monitor started with the same generic job name (e.g. JOB(QZDA*)) will be ended.

Qualifier 2: User

name: Specify the name of the user of the job whose database monitor is to be ended.
generic-name: Specify the generic job user of the monitor to be ended. The monitor started with the same generic job user (e.g. JOB(*ALL/DEVLPR*)) will be ended.

Qualifier 3: Number

000000-999999: Specify the number of the job whose database monitor is to be ended.

Monitor ID (MONID)

Specifies the unique monitor ID of the database monitor to be ended. If mulitple monitors using the same JOB parameter were started, the MONID parameter must be specified to uniquely identify which individual monitor is to be ended. A monitor ID value is generated by the system for each invocation of the STRDBMON command. Informational message CPI436A contains the system generated monitor ID value. The system generated monitor ID value is also stored in column QQC101 of the QQQ3018 database monitor record.

*ALL: When used with JOB(*ALL), all public monitors (monitors over multiple jobs) will be ended. When used with a generic job name (e.g. JOB(QZDA*)), all public monitors (monitors over multiple jobs) started with JOB(QZDA*) will be ended.
simple-name: Specify the 10-byte monitor ID of the monitor that is to be ended.

Comment (COMMENT)

User-specified description that is associated with the database monitor. The description is stored in the monitor record that has a record ID of 3018.

*BLANK: Text is not specified.
character-value: Specify up to 100 characters of text.

Examples

Example 1: End Monitoring for a Specific Job

ENDDBMON   JOB(*)

This command ends database monitoring for the current job.

Example 2: End Monitoring for All Jobs

ENDDBMON   JOB(*ALL)

This command ends the monitor open across all jobs on the system. If more than one monitor with JOB(*ALL) is active, then the MONID parameter must also be specified to uniquely identify which individual monitor to end.

Example 3: End Monitoring for an Individual Public Monitor with MONID Parameter

ENDDBMON   JOB(*ALL) MONID(061601001)

This command ends the monitor that was started with JOB(*ALL) and that has a monitor ID of 061601001. Because there were mulitple monitors started with JOB(*ALL), the monitor ID must be specified to uniquely identify which monitor started with JOB(*ALL) is to be ended.

Example 4: End Monitoring for an Individual Public Monitor with MONID Parameter

ENDDBMON   MONID(061601001)

The commands performs the same function as the previous example. It ends the monitor that was started with JOB(*ALL) or JOB(*) and that has a monitor ID of 061601001.

Example 5: End Monitoring for All JOB(*ALL) Monitors

ENDDBMON   JOB(*ALL/*ALL/*ALL) MONID(*ALL)

This command ends all monitors that are active across multiple jobs. It will not end any monitors open for a specific job or the current job.

Example 6: End Monitoring for a Generic Job

ENDDBMON   JOB(QZDA*)

This command ends the monitor that was started with JOB(QZDA*). If more than one monitor with JOB(QZDA*) is active, then the MONID parameter must also be specified to uniquely identify which individual monitor to end.

Example 7: End Monitoring for an Individual Monitor with a Generic Job

ENDDBMON   JOB(QZDA*) MONID(061601001)

This command ends the monitor that was started with JOB(QZDA*) and has a monitor ID of 061601001. Because there were mulitple monitors started with JOB(QZDA*), the monitor ID must be specified to uniquely identify which JOB(QZDA*) monitor is to be ended.

Example 8: End Monitoring for a Group of Generic Jobs

ENDDBMON   JOB(QZDA*) MONID(*ALL)

This command ends all monitors that were started with JOB(QZDA*).

Error messages

*ESCAPE Messages

CPF1321: Job &1 user &2 job number &3 not found.
CPF436D: Job &1 is not being monitored.
CPF436E: Job &1 user &2 job number &3 is not active.
CPF43A1: Job &1 specified on ENDDBMON command is not unique.