We have an issue where the connections, per user, to Netezza is currently limited to 12. Therefore if the user has 6 ghost connections that are not being cleared w/o shutting down SAS EG. This user is in effect only has 6 remaining connections available for the query builder project. Does anyone have a script that would clear these connection within the EG session w/o shutting down to clear. I know the easiest answer is to increase the number of connection to Netezza but our Netezza team is strongly against this proposal. Defer=yes does not function properly in query builder. Tested SAS EG 6.1 with the same results. Any other ideas would be deeply appreciated.
... View more