Try OpenEdge Now
skip to main content
Database Diagnostic Data Collection
Diagnostic data output file formats : Lock table overflow files
 

Lock table overflow files

When a lock table overflow event is triggered, depending on the event level, the following output files are created in the event subdirectory.
If your output format is CSV, the lock table summary file is formatted as follows:
"Timestamp" “EventId” "DbName" "PID" "User Num" "Tenant" "Domain ID" "Curr Locks" "Lock HWM" "User Name" "TTY Device” “Program file” “Line Number”
If your output format is CSV, the lock table detail file is formatted as follows:
"Timestamp" “EventId” "DbName" “Lock Type" "Table #" "Rowid" "Partition #" "Hash Chain" "Flags" "PID" "User Num" "Tenant" "User Name" "Domain ID" "TTY Device" "Trans State" "Trans Flags" "Trans ID"
If your output format is CSV, the transaction detail file is formatted as follows:
"Timestamp" “EventId” "DbName" "User Num" "Tenant ID" "Trans #" "RL Counter" "State" "Flags" "JState" "JFlags" "XID" "Txtime" "Coord" "CoordTx" "Duration" "BIRecReads" "BIRecWrites"
If your output format is JSON, there is only one file in the event directory. The following example shows lock table entries from a JSON-formatted diagnostic file:
"locktable_summary":{
"userlock_entry":{"UserNum":0,"UPID":10732,"Tenant":-32767,"DomainID":0,"UserName":"richb",
"TTYDevice":"/dev/pts/5","CurrLocks":0,"LockHWM":1,"ProgName":"","Line":0},
"userlock_entry":{"UserNum":5,"UPID":7459,"Tenant":-32767,"DomainID":0,"UserName":"richb",
"TTYDevice":"/dev/pts/7","CurrLocks":0,"LockHWM":1,"ProgName":"","Line":0},
"userlock_entry":{"UserNum":6,"UPID":7492,"Tenant":0,"DomainID":-4,"UserName":"richb",
"TTYDevice":"/dev/pts/12","CurrLocks":3,"LockHWM":1107,"ProgName":"","Line":0},
"userlock_entry":{"UserNum":7,"UPID":7496,"Tenant":0,"DomainID":-4,"UserName":"richb",
"TTYDevice":"/dev/pts/13","CurrLocks":0,"LockHWM":1126,"ProgName":"","Line":0},
"userlock_entry":{"UserNum":8,"UPID":7480,"Tenant":0,"DomainID":-4,"UserName":"richb",
"TTYDevice":"/dev/pts/9","CurrLocks":0,"LockHWM":1142,"ProgName":"","Line":0},
"userlock_entry":{"UserNum":9,"UPID":7486,"Tenant":0,"DomainID":-4,"UserName":"richb",
"TTYDevice":"/dev/pts/10","CurrLocks":1,"LockHWM":1126,"ProgName":"","Line":0},
"userlock_entry":{"UserNum":10,"UPID":7490,"Tenant":0,"DomainID":-4,"UserName":"richb",
"TTYDevice":"/dev/pts/11","CurrLocks":0,"LockHWM":1116,"ProgName":"","Line":0}},
"locktable_detail":{
"locktable_detail":{"LockType":"REC","Table#":2,"Rowid":6581,"Partition#":0,"HashChain":398,
"LockType":7492,"LockType":6,"LockType":0,"LockType":-4,"LockType":"S L ",
"LockType":"richb","LockType":"/dev/pts/12","UserNum":"BEGIN","Tenant":"FWD","DomainID":251702},
"locktable_detail":{"LockType":"REC","Table#":2,"Rowid":6581,"Partition#":0,"HashChain":398,
"LockType":7486,"LockType":9,"LockType":0,"LockType":-4,"LockType":"S L ",
"LockType":"richb","LockType":"/dev/pts/10","UserNum":"BEGIN","Tenant":"FWD","DomainID":251704},
"locktable_detail":{"LockType":"REC","Table#":2,"Rowid":7539,"Partition#":0,"HashChain":119,
"LockType":7492,"LockType":6,"LockType":0,"LockType":-4,"LockType":"S ",
"LockType":"richb","LockType":"/dev/pts/12","UserNum":"BEGIN","Tenant":"FWD","DomainID":251702},
"locktable_detail":{"LockType":"REC","Table#":2,"Rowid":6583,"Partition#":0,"HashChain":400,
"LockType":7486,"LockType":9,"LockType":0,"LockType":-4,"LockType":"S L ",
"LockType":"richb","LockType":"/dev/pts/10","UserNum":"BEGIN","Tenant":"FWD","DomainID":251704},
"locktable_detail":{"LockType":"REC","Table#":2,"Rowid":6579,"Partition#":0,"HashChain":396,
"LockType":7492,"LockType":6,"LockType":0,"LockType":-4,"LockType":"S L ",
"LockType":"richb","LockType":"/dev/pts/12","UserNum":"BEGIN","Tenant":"FWD","DomainID":251702},
"locktable_detail":{"LockType":"REC","Table#":2,"Rowid":7539,"Partition#":0,"HashChain":119,
"LockType":7486,"LockType":9,"LockType":0,"LockType":-4,"LockType":"S ",
"LockType":"richb","LockType":"/dev/pts/10","UserNum":"BEGIN","Tenant":"FWD","DomainID":251704},
"locktable_detail":{"LockType":"REC","Table#":2,"Rowid":6579,"Partition#":0,"HashChain":396,
"LockType":7486,"LockType":9,"LockType":0,"LockType":-4,"LockType":"S L ",
"LockType":"richb","LockType":"/dev/pts/10","UserNum":"BEGIN","Tenant":"FWD","DomainID":251704},
"locktable_detail":{"LockType":"REC ","Table #":2,"Rowid":6583,"Partition#":0,"HashChain":400,
"LockType":7492,"LockType":6,"LockType":0,"LockType":-4,"LockType":"S L ",
"LockType":"richb","LockType":"/dev/pts/12","UserNum":"BEGIN","Tenant":"FWD","DomainID":251702},
"locktable_detail":{"LockType":"REC","Table#":2,"Rowid":7540,"Partition#":0,"HashChain":120,
"LockType":7492,"LockType":6,"LockType":0,"LockType":-4,"LockType":"S L ",
"LockType":"richb","LockType":"/dev/pts/12","UserNum":"BEGIN","Tenant":"FWD","DomainID":251702},
"locktable_detail":{"LockType":"REC","Table#":2,"Rowid":7538,"Partition#":0,"HashChain":118,
"LockType":7492,"LockType":6,"LockType":0,"LockType":-4,"LockType":"S L ",
"LockType":"richb","LockType":"/dev/pts/12","UserNum":"BEGIN","Tenant":"FWD","DomainID":251702}},