To deactivate a connection, use either of these procedures:
exec sgw_deactcon "con_number"
or
exec sgw_deactcon "con_number", force
where:
“con_number” is the number of the connection you intend to deactivate. This is the connection number value displayed in the sgw_status connection procedure. Enclose numeric parameter values in quotation marks.
force is optional. If you use the force option, the connection you specify ends, even if it is currently executing. However, on some TRS platforms, even a forced deactivate allows the current request to complete before deactivating the connection.
If you do not use the force option, TRS allows any transactions in progress to complete before it deactivates the connection. While these transactions finish processing, the connection is considered to be “draining.”
To deactivate connection number “1,” use this procedure:
exec sgw_deactcon "1", force
go
The force option causes connection number “1” to deactivate even if it is currently executing.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
