Remote I/O connections dont get terminated on ASE 15.7 ESD1

[former_member537663]

Remote I/O connections dont get terminated on ASE 15.7 ESD1 although the connections are closed on the source server. Is this a bug? Is there a solution other than to try to manually kill these connections.

[former_member537663]

The 'cis connect timeout' value is set to 0 and so is 'cis idle connection timeout'. However seeing about to 18 processes with status 'remote i/o' in sysprocesses that have loggedindatetime all the way from June of last year 2018. Any ideas why these are not disconnecting once the source processes are gone?

[former_member89972]

So set "cis connect timeout" to say 256 seconds (about 4 minutes) and see if these go away.

Other possibility is that your server is connecting to other remote sever(s) and keeping the connections on.

In that case you will have to set "cis connect timeout" on the other server too.

Check the values for hostname, program_name, hostprocess columns from master..sysprocesses to get further clues.

HTH

Avinash

[former_member89972]

There are two CIS time out configuartion parameters.

Remote connections are held for reuse for some time, just in case next query comes on the same connection.

If you want remote connections to close in certain time try to set "cis connect timeout" some reasonable value.

E.g. in our case I have set it to 256 seconds (about 4 minutes)

NOTE : This is with cis rpc handling set to 1.

HTH

Avinash