Focal Point
Agents staying in use with Last Cmd "SQL"

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2747035716

March 07, 2012, 05:05 AM
Wep5622
Agents staying in use with Last Cmd "SQL"
On our WF server (the bit where the DB/400 adapter is running), we are running out of available agents because they don't seem to return to an idle state after performing some SQL. I got this info from the Data Services (Agents) view in the webconsole, in case that matters.

We've looked at the TSCOM3 processes on the AS/400, but that revealed no details about what those agents are doing.

Is there any way to find out what those agents are doing?


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
March 07, 2012, 03:37 PM
Waz
The only thing that I could suggest is to turn tracing on, and see what the command is.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!