Question

An onstat output shows a thread named "srvinfx." What is the function of this thread?

Answer

The srvinfx thread manages the local execution of a remote query from another server to the local server. To see the session information and the query, use the following procedure:

Obtain the value of rstcb field for the srvinfx thread from of the onstat -g ath output.

Obtain the sessid (SID) for the line in the onstat -u output. The line in the onstat -u output for this session has a value in the address field that matches the rstcb value from onstat -g ath (see step #1 above).

Execute onstat -g ses SID.