Ryszard Musielak
Member
Hello,
would anyone be able to help me? I have a system that sends me an email when a table is locked for longer. Once in a while (like once a month) I get a surge of message of this kind:
It seems like a disconnected session in proshut:
A UNIX process is associated with this:
I've had to kill this process and there was no impact, the system was working well without any issues, however I have this problem reoccurring and wanted to ask where does this come from?
There are many other such processes, from the start time they look more like system processes, as they've been running since mid November. In Promon <database> the locking screen shows this:
Thanks,
Richard
would anyone be able to help me? I have a system that sends me an email when a table is locked for longer. Once in a while (like once a month) I get a surge of message of this kind:
Code:
ERROR - _sec-authentication-domain locked by sysprogress since 10:04 29/11/17
Alert Type: 2 - Long Lasting Locks
Date: 29/11/17 Time: 13:04:57
A _sec-authentication-domain record has been locked by user 'sysprogress' since 10:04 29/11/17
Record Details:
Domain name =
The record is currently Share-Locked.
It seems like a disconnected session in proshut:
Code:
RETURN - show remaining, Q - quit:
usr pid time of login user id Type tty Limbo?
424 27072 Wed Nov 29 09:36:15 2017 sysprogress REMC no
A UNIX process is associated with this:
Code:
root 27072 1 0 Nov22 ? 01:36:24 /bcp/dlc/bin/_sqlsrv2 -D juniper.serverid=3 -D juniper.dbfile="package" -D juniper.config="package.virtualconfig" -D juniper.service="package.virtualconfig.virtual" -D juniper.propertyfile="" -D juniper.cplog="ISO8859-1" -D juniper.cpcase="Basic" -D juniper.cpcoll="Basic" -D juniper.cpinternal="ISO8859-1" -D juniper.convmap="convmap.cp" -D juniper.sqlyearoffset="1950" -D juniper.vpf=true -ss 500k -classpath "/bcp/dlc/jdk/lib/tools.jar:/bcp/dlc/java/progress.jar:/bcp/dlc/java/messages.jar:/bcp/dlc/java/prosp.jar" -SQLStack 0 -SQLStmtCache 0 -SQLCursors 0 -SQLTempStoreBuff 0 -SQLTempStoreDisk 0 -SQLTempStorePageSize 0 -Bt 0 -t 0 -T -SQLTempMgrLegacy 0 -ipver IPV4 -PendConnTime 90 -SQLQuotedRowidStd 1 -SQLAutoStats 0 -SQLAutoStatThreshold 0 -SQLLockWaitTimeout 0 -SQLTruncateTooLarge 0 -SQLWidthUpdate 0 -H 0.0.0.0
I've had to kill this process and there was no impact, the system was working well without any issues, however I have this problem reoccurring and wanted to ask where does this come from?
There are many other such processes, from the start time they look more like system processes, as they've been running since mid November. In Promon <database> the locking screen shows this:
Code:
Record Locking Table: by user number for all tenants
Usr:Ten Name Domain Chain # Rowid Table:Part Lock Flags Tran State Tran ID
422 racasu 0 REC 4898 152331714 827 SHR D None FWD 1511058882
424 sysprogress 0 REC 2402 15672 -207 SHR Begin FWD 1510540329
Thanks,
Richard