Working with user jobs in a distributed relational database

 

If you know the user profile (user name) being used by a job, you can use the Work with User Jobs (WRKUSRJOB) command to display or change job information. Enter the command without any parameters to get a list of the jobs on the system with your user profile.

You can specify any user and the job status to shorten the list of jobs by entering its name in the command like this:

WRKUSRJOB USER(KCDBA)

The Work with User Jobs display appears with names and status information of user jobs running on the system (*ACTIVE), on job queues (*JOBQ), or on an output queue (*OUTQ). The following display shows the active and ended jobs for the user named KCDBA:

Work with User Jobs                      KC105
03/29/92  16:15:33
Type options, press Enter.
2=Change   3=Hold   4=End   5=Work with   6=Release   7=Display message 8=Work with spooled files   13=Disconnect  
Opt   Job          User         Type      -----Status------   Function __    KC000        KCDBA        CMNEVK    OUTQ __    KC000        KCDBA        CMNEVK    OUTQ __    KC000        KCDBA        CMNEVK    OUTQ __    KC000        KCDBA        CMNEVK    OUTQ __    KC000        KCDBA        CMNEVK    ACTIVE __    KC0001       KCDBA        CMNEVK    ACTIVE              *  -PASSTHRU __    KC0001       KCDBA        INTER     ACTIVE              CMD-WRKUSRJOB  
 
 
 
 
Bottom Parameters or command ===>
F3=Exit      F4=Prompt   F5=Refresh   F9=Retrieve   F11=Display schedule data F12=Cancel   F21=Select assistance level

This display lists all the jobs on the system for the user, shows the status specified (*ALL in this case), and shows the type of job. It also provides you with eight options (2 through 8 and 13) to enter commands for a selected job. Option 5 presents the Work with Job display described in the preceding paragraphs.

The Work with User Jobs (WRKUSRJOB) command is useful when you want to look at the status of the DDM TCP/IP server jobs if your system is using TCP/IP. Run the following command:

   WRKUSRJOB QUSER *ACTIVE

Page down until you see the jobs starting with the characters QRWT. If the system is active, you should see one job named QRWTLSTN, and one or more named QRWTSRVR (unless prestart DRDA^® jobs are not run on the system). The QRWTSRVR jobs are prestart jobs. If you do not see the QRWTLSTN job, run the following command to start it:

   STRTCPSVR *DDM

If you see the QRWTLSTN job and not the QRWTSRVR jobs, and the use of DRDA prestart jobs has not been disabled, run the following command to start the prestart jobs:

   STRPJ subsystem QRWTSRVR

Before V5R2, the subsystem that QRWTSRVR normally ran in was QSYSWRK. After V5R1, QRWTSRVR runs in QUSRWRK.

 

Parent topic:

Monitoring relational database activity

 

Related reference

Work with User Jobs (WRKUSRJOB) command
Application does not complete in the expected time