Every transaction is finished within a few hundred milliseconds.
There is nothing scheduled what every 5 minutes calls the appserver, it seems to be an internal pasoe process causing DBI growth
Agent startup parameters: -T /temp -t -Bt 20000 -tmpbsize 8
When the MSAgent is stopped logs with logentrytype temp-tables:3 or -tttablerangesize / -ttindexrangesize with ttStats enabled shows the AS-ADMIN process deleting Temp-Tables and the DBI file is eventually removed:
AS-Admin TEMP-TABLE Deleted TEMP-TABLE _AgentStatHist (ID:1 DYNAMIC) stopAgent OpenEdge.ApplicationServer.AgentManager
AS-Admin TEMP-TABLE Deleted TEMP-TABLE _AgentThread (ID:2 DYNAMIC) stopAgent OpenEdge.ApplicationServer.AgentManager
AS-Admin TEMP-TABLE Deleted TEMP-TABLE _AgentSession (ID:3 DYNAMIC) stopAgent OpenEdge.ApplicationServer.AgentManager
AS-Admin TEMP-TABLE Deleted TEMP-TABLE _AgentConnection (ID:4 DYNAMIC) stopAgent OpenEdge.ApplicationServer.AgentManager
AS-Admin TEMP-TABLE Deleted TEMP-TABLE _AgentRequest (ID:5 DYNAMIC) stopAgent OpenEdge.ApplicationServer.AgentManager
With -t enabled on a Unix like platform, the DBI files are visible. Without enabling 4GLTrace, the DBI files owner process can be determined by the file name. (Note: this format is a convention OpenEdge uses for now, as of version 12.8, which may be changed in the future.) The file name should be like:
DBIthreadid_sessionNumXXXXXX
example: DBI28880_3a36476
Where:
- threadid is some number
- sessionNumber is the ABL Session number (e.g., 4 for AS-4, 7 for AS-7). The AS-Admin temp-table db file name can be identified because it's sessionNumber will always be 3. And, XXXXXX gets replaced by the OS with something random when the file name is created (trying to guarantee a unique name).