Openedge (Progress) - List transaction cache

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:

1. Single — Only the current ABL program and line number, or a single SQL statement is reported by the ABL client.
2. Stack — The call stack up to the current ABL program and line number.
3. 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-CacheInfo" 

from pub."_connect" c

where c."_Connect-CacheInfo" is not null 

Execution count

select database() as 'Database', c."_Connect-CacheInfo" as 'Cache', count(c."_Connect-CacheInfo") as 'Count'

from pub."_connect" c

where c."_Connect-CacheInfo" is not null

group by c."_Connect-CacheInfo"

order by 3 desc

 

Active transaction with cache

select         database() as Database,

c."_Connect-Id" as 'ID',

c."_Connect-Time",

t."_Trans-txtime",

t."_Trans-Duration",

c."_Connect-Name",

c."_Connect-IPAddress" as 'IP',

c."_Connect-Pid" as 'PID SO',

c."_Connect-ClientType" ,

c."_Connect-CacheInfo"

from pub."_trans" t, pub."_connect" c

where t."_Trans-State" = 'ACTIVE'

and t."_Trans-Usrnum" = c."_Connect-Usr"

order by t."_Trans-Duration"  desc