There are three (3) ways to get into the LOCK table at a Cache site. Those are – the System Portal, the Cache Cube (in older versions of Cache) and at the programmer prompt in the %SYS namespace or UCI.
This document outlines the steps to do everything without the cube or portal. You need to be in the “%SYS” UCI so you would ZN “%SYS” to move to that UCI.
%SYS>
%SYS>D ^LOCKTAB
Node Name: xxxxx.xxx.LOCAL
LOCK table entries at 01:06PM 04/12/2013
406160 bytes usable, 638672 bytes available.
Entry Owner X# S# Flg W# Item Locked
1) 32398 1 ^[“^^/usr/local/cachesys/5018/mgr/”]%SYS(“CSP
“,”Daemon”)
2) 16954 1 ^[“^^/usr/local/cachesys/5018/mgr/”]DBACK
3) 8018 1 ^[“^^/usr/local/cachesys/5018/mgr/”]TASKMGR
4) 10107 1 ^[“^^/usr/local/cachesys/data/train2/”]%ZIS(8
994.171,”RPCB Listener”,”TRAIN”,”TRAIN”,”TRAIN:CACHE”,9171)
5) 8175 1 ^[“^^/usr/local/cachesys/data/train2/”]%ZTSCH
(“SUBLK”,”TRAIN:CACHE”,8175)
6) 10107 1 ^[“^^/usr/local/cachesys/data/train2/”]%ZTSCH
(“TASK”,4252358)
7) 11277 1 ^[“^^/usr/local/cachesys/data/train2/”]%ZTSCH
(“TASK”,4259840)
8) 13434 1 ^[“^^/usr/local/cachesys/data/train2/”]%ZTSCH
(“TASK”,4259841)
9) 11277 1 ^[“^^/usr/local/cachesys/data/train2/”]XMBPOS
T(“POST_Mover”)
Command=> <RETURN> for more… ? –> A question mark will display available commands
(below are the commands available to use at the “Command=>” prompt)
<RETURN> or “S” to show another screen of items
“D” or “1” to delete one lock
“J” to delete ALL of one JOB’s locks
“C” to delete ALL of one SYSTEM’s (Computer’s) locks
“R” to Restart display
“Q” or “^” to quit
“H” or “?” for help (this text)
“A” to delete ALL locks
In display:
X# Lock count of exclusive lock
S# Lock count of share lock
W# Number of processes are waiting for this lock
In Flg field:
* outgoing (client) lock to another system; may be pending
L Lost lock due to lock reset condition
Z Local ZALLOCATE lock in DSM-11 compatibility mode
P Lock Pending, waiting for server to grant the lock
D Delock Pending, waiting for server to release the lock
1903 Wright Place, Suite 120
Carlsbad, CA 92008
Toll-Free (877) 633-7743
Email customercare@medsphere.com