Openedge (Progress) - BI reads and writes (version 2)

-
We know that sometimes is hard to infentify who is making BI growing up.

With the select below you can see the username, IP address and another informations about the process who is making BI bigger than the normal size.


select     database() as Database,
               u."_UserIO-Name" as 'User',
               u."_UserIO-BiWrite" as 'Writes',
               u."_UserIO-BIRead" as 'Reads',
               c."_Connect-Time" as 'Connection date',
               t."_Trans-txtime" as 'Transaction date',
               t."_Trans-Duration" as 'Seconds',
               c."_Connect-IPAddress" as 'IP',
               c."_Connect-Pid" as 'PID OS',
               c."_Connect-ClientType" as 'Connection Type',
               c."_Connect-CacheInfo" as 'Cache info'
from pub."_trans" t, pub."_connect" c, PUB."_UserIO" u
where         u."_UserIO-BiWrite" > 0
               and t."_Trans-State" = 'ACTIVE'
               and t."_Trans-Usrnum" = c."_Connect-Usr"
               and c."_Connect-Usr" = u."_UserIO-Usr"
order by u."_UserIO-BiWrite" desc
               
*You can check here how to enable transaction cache.

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