NetBase for MPE Reference Guide

Troubleshooting NetBase
B-7
The SHOW REMOTE command shows all users coming into this system for their file access. It also
displays the PIN number of the associated server in the SPIN column. By matching the pin number
from the DBUTIL command with the server pin (SPIN) number from the show remote command, you
can identify the user process that is accessing the database. In this example, server pin 92 is
associated to job number #S200 with a logon of USER.PROD. This user is running Query to access
the database.
The SHOW SERVER command displays essentially the same information as the SHOW REMOTE
command. However, it also provides the names and modes of the opened files.
*>SHOW SERVER 1
NODE JOBNUM SRVR UPIN JOBNAME PROGRAM NAME
SYSA #S200 1 136 USER.PROD QUERY.PUB.SYS
65 PAYROLL.DATA.PROD OPEN MODE 1
By using the SHOW REMOTE and SHOW SERVER commands, you have been able to identify the user
and program holding the lock on the database.