OpenEdge (Progress) - Transactions and locks

-

In OpenEdge database you can use 4GL and SQL commands.

I like SQL commands because I don't know to much about 4GL :D.

Below, there is a SQL script to show blocked transactions and locks.

select         distinct database() as 'Database',
c."_Connect-Id" as 'ID',
c."_Connect-Time" as 'Date',
t."_Trans-txtime" as 'Start time',
t."_Trans-Duration" as 'Time in seconds',
c."_Connect-Name" as 'User',
c."_Connect-IPAddress" as 'IP',
c."_Connect-Pid" as 'PID SO',
t.TBL as 'Table',
l."_Lock-Flags" as 'Type'
from         pub."_trans" t, pub."_connect" c, PUB."_Lock" l, sysprogress.SYSTABLES t
where         t."_Trans-State" = 'ACTIVE'
and t."_Trans-Usrnum" = c."_Connect-Usr"
and c."_Connect-Usr" = l."_Lock-Usr"
and l."_Lock-Table" = t."ID"

order by t."_Trans-Duration"  desc

This script is very useful, enjoy it.

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