Openedge (Progress) - List blocked users

-
You can use this select to list your blocked users and the user who is blocking the others.


select
 l."_Lock-Usr" as 'ID',
l."_Lock-Name" as 'User',
c."_Connect-IPAddress" as 'IP',
l."_Lock-Flags" as 'Type 1',
l."_Lock-Type" as 'Type 2',
tb.TBL as 'Table',
l."_Lock-RecId" as 'Register',
database() as 'Database',
c."_Connect-Pid" as 'PID OS',
t."_Trans-Duration" as 'Time in seconds',
'Blocker' as 'Status'
from PUB."_Lock" l
cross join sysprogress.SYSTABLES tb
cross join pub."_connect" c
left join pub."_trans" t on
t."_Trans-Usrnum" = c."_Connect-Usr"
join PUB."_Lock" l1 on
l1."_Lock-Usr" is not null
and l1."_Lock-Table" = l."_Lock-Table"
and l1."_Lock-RecId" = l."_Lock-RecId"
and l1."_Lock-Flags" like '%Q%'
where
c."_Connect-Usr" = l."_Lock-Usr"
and l."_Lock-Usr" is not null
and l."_Lock-Table" = tb."ID"
and l."_Lock-Flags" not like '%Q%'

union

select        
l."_Lock-Usr" as 'ID',
l."_Lock-Name" as 'User',
c."_Connect-IPAddress" as 'IP',
l."_Lock-Flags" as 'Type 1',
l."_Lock-Type" as 'Type 2',
tb.TBL as 'Table',
l."_Lock-RecId" as 'Register',
database() as 'Database',
c."_Connect-Pid" as 'PID SOOS
t."_Trans-Duration" as 'Time in seconds',
'Blocked' as 'Status'
from PUB."_Lock" l
cross join sysprogress.SYSTABLES tb
cross join pub."_connect" c
left join pub."_trans" t on
t."_Trans-Usrnum" = c."_Connect-Usr"
where       
l."_Lock-Flags" like '%Q%'
and c."_Connect-Usr" = l."_Lock-Usr"
and l."_Lock-Usr" is not null
and l."_Lock-Table" = tb."ID"

Comments

Post a Comment

Popular posts from this blog

Impacket-master - psexec for linux

-
I have an application that need to execute remote commands on Windows and linux. This app run in a CentOS server. It is easy to execute a remote on linux, but on Windows I had to search a good solution and I had find Impacket-master. To use this solution you have to follow this steps: Install python in your linux; Download this libraries; argparse-master - https://pypi.python.org/pypi/argparse   pyasn1 - https://pypi.python.org/pypi/pyasn1   pycrypto-2.6.1 - https://pypi.python.org/pypi/pycrypto Install Libraries; Unpack files: tar -vzxf pyasn1-0.1.9.tar.gz Install: python setup.py install  After this, install Ipacket-Master: python setup.py install You can find psexec.py in examples folder: impacket-master/examples These is a command line with an example: python psexec.py domain/user:password@server 'cmd /c "dir /s c:\"'
Read more

Openedge (Progress) - List transaction cache

-
Image
In Openedge database you can see last programm or SQL execution from each connection. To enable this feature first you have to connect to a database with promon. Example: $DLC/bin/promon database After this use the sequence below:   R &D 1 18 2   1, 2 or 3 At this point you can choose between th options: Single — Only the current ABL program and line number, or a single SQL statement is reported by the ABL client. Stack — The call stack up to the current ABL program and line number. One Time Request — The ABL or SQL client report tracing information once. Once reported, database-request statement caching is turned off.   After this you can use the SQLs below the get database informations: List all connections with cache information: select database() as 'Banco', c."_Connect-type" , c."_Connect-PID" as 'PID', c."_connect-ipaddress" as 'IP', c."_Connect-...
Read more