End Database Monitor (ENDDBMON)

Where allowed to run: All environments (*ALL)
Threadsafe: Conditional 		Parameters
Examples
Error messages

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:

Top

 

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, 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.

Top

 

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.

Top

 

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.

Top

 

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*).

Top

 

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.

Top