Display Record Locks (DSPRCDLCK)
| Where allowed to run: All environments (*ALL) Threadsafe: No |
Parameters Examples Error messages |
The Display Record Locks (DSPRCDLCK) command allows you to show the current record lock status of a particular database physical file member. This command displays the lock status for a particular relative record number, or the lock status of all locked records in the member.
| Top |
Parameters
| Keyword | Description | Choices | Notes |
|---|---|---|---|
| FILE | Physical file | Qualified object name | Required, Positional 1 |
| Qualifier 1: Physical file | Name | ||
| Qualifier 2: Library | Name, *LIBL, *CURLIB | ||
| MBR | Member | Name, *FIRST | Optional, Positional 2 |
| RCDNBR | Record number | 1-4294967288, *ALL | Optional, Positional 3 |
| OUTPUT | Output | Optional |
| Top |
Physical file (FILE)
Specifies the physical file that contains the member whose record locks are shown.
This is a required parameter.
Qualifier 1: Physical file
- name
- Specify the name of physical file.
Qualifier 2: Library
- *LIBL
- All libraries in the library list for the current thread are searched until the first match is found.
- *CURLIB
- The current library for the job is used to locate the file. If no library is specified as the current library, QGPL is used.
- name
- Specify the name of the library to be searched.
| Top |
Member (MBR)
Specifies the member in the file whose record locks are shown.
- *FIRST
- The first member of the specified file is used.
- name
- Specify the name of the physical file member.
| Top |
Record number (RCDNBR)
Specifies a particular relative record number or all records of a member.
- *ALL
- The lock status of all records currently locked in a physical file member is shown.
- 1-4294967288
- Specify the record number of the record whose lock status is to be displayed.
| Top |
Output (OUTPUT)
Specifies whether the output from the command is displayed at the requesting work station or printed with the job's spooled output.
- *
- The output is displayed (if requested by an interactive job) or printed with the job's spooled output (if requested by a batch job).
- The output is printed with the job's spooled output.
| Top |
Examples
DSPRCDLCK FILE(MASTER/PAYROLL) MBR(*FIRST) RCDNBR(1)
OUTPUT(*)
This command shows the lock status of relative record number 1, in the first member of the physical file named PAYROLL in the MASTER library.
| Top |
Error messages
*ESCAPE Messages
- CPF3130
- Member &2 already in use.
- CPF3210
- File &1 in library &2 not correct type.
- CPF3247
- Record number &4 does not exist in member &3.
- CPF3275
- Member &3 file &1 in &2 not found.
- CPF7D41
- Error occurred while logging order assistance request.
- CPF7D42
- Error occurred while performing database operation.
- CPF9803
- Cannot allocate object &2 in library &3.
- CPF9810
- Library &1 not found.
- CPF9812
- File &1 in library &2 not found.
- CPF9845
- Error occurred while opening file &1.
- CPF9846
- Error while processing file &1 in library &2.
- CPF9847
- Error occurred while closing file &1 in library &2.
- CPF9871
- Error occurred while processing.
| Top |