ca.portal.admin

Re:Re: [IDMSVENDOR-L] Access to Lock Data Used in PMRM?

Discussion created by ca.portal.admin on Mar 9, 2010
hen perhaps the real question becomes:
does Ms Kline need this information real time as it happens, or can
aily reports suffice
if the latter, then certainly the log can be interrogated and all
ecessary information can be retrieved
f the former - good luck - even if you sat all day executing lockmon
ou MIGHT see stalls building, but many deadlocks could come and go
etween two hits of the ENTER key
chris
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Access to Lock Data Used in PMRM?
"Task code OPER, followed by W DB will show you the task, program,
status, etc. Please, see below. The status indicates what kind of
lock, if any, is being held. This information may be found in the DCMT
TASK CODE and COMMANDS manual.

TASK ID ORIG IDMSPROG SUBSCHEM PRI STA V# PAGEREAD PAGEWRIT CALLIDMS
LOCK-REQ
0000000010 DBDC RHDCLGSD IDMSNWK9 253 A 56 00000000 00000000 00000003
00000001

Once you have the TASK ID, you may display the TRAN with DCMT, e.g. DCMT
D TRAN 10, in order to see the detail information. Please, see below.

D TRAN 10
Task / LTE Trans-ID Pri Orig Module SS/AM St Stat
Date:Time
10 52765902 253 LOC RHDCLGSD IDMSNWK9 RO A
2010-03-07-20.45.19.7575

DataBase DBMS Lines Reads Pages Writes Pages
Forced
Calls Rqst Rqst Read Rqst Written
Writes
3 0 0 0 0 0
0
Rows Calc Calc Cluster Cluster Frags
Rows
Current Target Oflow Target Oflow Stored
Relo
0 0 0 0 0 0
0
Journal Before Writes
Images
0 0
Locks Reqst Share Non-Shr Freed
1 1 0 0
INDEX SR8-SPLIT SR8-SPAWN SR8-STORE SR8-ERASE SR7-STORE SR7-ERASE
ORPH-ADOP
0 0 0 0 0 0
0
SEARCHES B-TREE B-TREE-LV BEST-CASE WORST-CSE
0 0 0 0

--------- Area ----------- ------ Mode ------
SYSTEM.DDLDCLOG Shared Retrieval
V41 ENTER NEXT TASK CODE: CA-IDMS release 16.0 node SYST0041
PAGE 00001 - NEXT PAGE: =20

Outcomes