I would like to increase the infomation of the log and statistics (ETLSTATS and ETLLOG tables) with the information that is taken from the Data Services Agents.

In the server console: Workspace \ Agents there are all data services with a lot of interesting information:

1 Tscomid
2 Service
3 State
4 User
5 Group
6 Client Address
7 Scheduler Job ID
8 Query Time
9 Command
10 Procedure
11 Master File
12 Response Time
13 Server Time
14 Error Number
15 Focus I/O
16 DBMS I/O
17 DBMS Time
18 CPU Time
19 Memory Usage (KB)
20 Disk Usage (KB)
21 Process ID

Now right click on the agents and choose Statistics there are many other.

Obviously recovered Scheduler Job ID I do join tables on ETLSTATS.

The question is: Where are stored this information?

Has anyone managed to get this information in a focus data table?

It would be extremely useful for all sorts of problem solving.

thanks in advance

This message has been edited. Last edited by: <Kathryn Henning>,

Hi All,

FYI, dr.herojos has a case open with Support for this question, and it is being researched.

Regards,

Kathryn