TurboIMAGE/XL Database Management System Reference Manual (30391-90012)

Chapter 8 455
Using the Database Utilities
>>SHOW
SUBSYSTEMS indicates whether subsystems, including user programs, can access the
TurboIMAGE/XL database and, if access is allowed, whether it is read
only or both read and write. Subsystem access is enforced by the
subsystem.
USERS displays a list of the processes that have the database open with the
program file name and other information. (Refer to examples below.)
OFFLINE requests that the information be listed on the line printer. The formal
designator for the list file is DBUTLIST. (Passwords and maintenance word
will not be printed.)
The >>SHOW
database name USERS command can be executed at any time. The remaining
>>SHOW commands can be executed at any time except when another process has the
database opened in an exclusive access mode (mode 3 or 7).
Example (Show Users)
:RUN DBUTIL.PUB.SYS
.
.
.
>>SHOW ORDERS USERS
1 2 3 4 5
PIN PATH EXECUTING PROGRAM JOBNUM MODE
21 1 INVENTRY.IMAGE.DATAMGT #S116 1
22 1 BROWSE.IMAGE.DATAMGT #S118 5
28 1 BROWSE.IMAGE.DATAMGT #S112 5
29 1 INVENTRY.IMAGE.DATAMGT #S115 1
31 1 ORDENTRY.IMAGE.DATAMGT #S117 1
Example Discussion
The columns of information are described as follows:
1 The Process Identification Number (PIN). This is a number assigned to a
process by the operating system when the process is created. The table
above indicates that the process has opened the ORDERS database.
2 The access path number. The access paths for each process are numbered
consecutively beginning with 1. Refer to the discussion of access paths in
chapter 4.
3 The name of the program file, its group and account.
4 The number of the job or session in which the process is running.
5 The access mode in which the database is open.
DBUTIL does not call DBOPEN so it is not listed as an executing program.