What is the purpose of PQLSRV server process?

[Anon]

Dear Prognosis team,

I would like to know what is the purpose or PQLSRV process?

Based on my understanding, it seems to be related to Web Interface only (based on few sentences I found in documentation).

This process in constantly showing in the top 5 requesters on our system (online type), but I wonder why, as we are not using web interface (although it was installed originally).

Could you please clarify if this server can be disabled somehow (providing it is needed only for Web Interface), or at least advise how to eliminate unnecessary queries it produces.

Thanks a lot.

[Anon]

Hi Juraj,

Thanks for the post - good question.

IRPQLSRV is, as you suspected, almost entirely used only for satisfying requests from the Web Interface. It's the process that receives and combines queries from Web UI dashboards, sends those requests to the Prognosis server via the irnetrtr process, and then sends the data back for display.

If you aren't using the web interface though you don't need to have it running. You can turn it off by adding the following line to the Prognosis configuration, and starting the configuration with the change in place:

SET RUN ( IRPQLSRV.EXE, N )

(If you already have a line in the configuration with the parameter set to 'Y', just change it to 'N'. If you don't have such a line, just add it in as I've shown here).

That should turn it off and stop the requests.

Cheers,
Mick

[Anon]

Mick, aren't there a number of custom solutions deployed with customers around the world that also rely on IRPQLSRV?

[Anon]

Hi Duncan,

Good point. So perhaps it's more accurate to say "If you do not have any custom solutions, irpqlsrv is used only for the Web UI. If you do have a custom solution, it may rely on irpqlsrv and you should check in with your IR account contact before disabling it" :-)

Thanks for picking that up.

Cheers,
Mick