Security Server connection user for SELECT statements?

wadie

Well Known Member
Hi,

A few months ago, we split our f98owsec for different environments. For DV&PY it now points at a library called CRPCTL.
In the server ini, under the [SECURITY] section, the datasource points there as well.

There are no problems logging in, but every now and then, a select seems to use the connection that was made to this datasource.
Of course, it doesn't find the file from the select in CRPCTL and it throws an error in the logs and the select returns no data...

We have no idea why sometimes SQLs go look in CRPCTL instead of following their OCM mappings that we created.
Is this standard behaviour? Does anyone have an idea how to solve this?
 
Is it the same machine that gives you the error or different ones? Can you tell me if you experience this right after a package build or not.

Any other information you can give me would be great.

Jimmy Berry
AS/400 DB2/400 V5R3
ERP 8.0 SP 23
 
Back
Top