How to Check Status of Utility Jobs in DB2

The DB2® command DISPLAY UTILITY displays the status of utility jobs, including utility jobs in a data sharing group.

The output from the command consists of informational messages only. One set of messages is returned for each job identified by the command. For utility jobs in a data sharing group, the output shows the member name of the system on which each utility job is running.

The status from the display represents the current status, except in a data sharing group when the utility is running on a member other than the one from which the command is issued. In that case, the status is current as of the last checkpoint.

-DISPLAY UTILITY() ==> To know status of all utility jobs
-DB1G DISPLAY UTILITY () ==> To know status of all utility jobs in Data sharing group
-DB1G DISPLAY UTILITY (*) MEMBER (DB1G) => To know status of all utility jobs in a particular member of Data sharing group

Related posts

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.