AutoStop connection parameter [Astop]

Function

To prevent unloading of a database as soon as there are no more open connections to it.

Usage

Embedded databases

Default

Yes

Description

By default, any server that is started from a connection string is stopped when there are no more connections to it. Also, any database that is loaded from a connection string is unloaded as soon as there are no more connections to it. This behavior is equivalent to Autostop=Yes.

If you supply Autostop=No, then any database that you start in that connection is not unloaded when there are no more connections to it. As a consequence, the database server will not be shut down either.

The AutoStop parameter is used only if you are connecting to a database that is not currently running. It is ignored if the database is already loaded.

Example

The following Windows connection profile prevents the database from being unloaded when the connection is dropped:

[Sample Embedded Database]
DatabaseFile=c:\sybase\ASIQ-12_7\demo\asiqdemo.db
Autostop=No
UserID=DBA