Greetings,
Environment: SAS 9.4M2 with EG 7.1, Win 2012 Server, Win 7 64 client.
Problem: Users EG sessions timing out when doing explicit sql to remote servers.
FIX: I'm supposed to set the KeepAlive Parameter
ISSUE: I don't know where to add the parameter.
BackGround: We have finally received our new physical server (96 cores, 256G ram, 6 TB storage) which is at a remote data center. We are migrating the users from the local virtual server to the new physical server. These users are banging large sql queries explicitly so the backend database server is processing the query. With the new network rules the users are timing out after an hour of inactivity while the sql query is processing. The EG screen reports that the session is still active until the user tries to do something and then is informed that the server is disconnected.
Additional QuestionS: IS there a setting that can be done at the client workstation.
After KEEPALIVE is set, what parameter do I search for via EG Proc Options.
Any and ALL help would be appreciated,
Thanks,
Jerry Coppa - SAS Admin at DHS PA GOV
... View more