2018-11-22 01:04
2015-12-21 20:15
2015-11-16 14:34
2015-10-09 15:25
2014-02-13 20:10
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.