Initializing Databases Asynchronously

Adaptive Server versions 15.7 ESD #2 and later include the async_init parameter for the alter database and create database commands, which allows you to asynchronously initialize a database while it is being used.

The database initialization is transparent to the user: the database is immediately available when it is created or altered, not when the database initialization is complete.

Any task that uses a page of the database that is not yet initialized performs an initialization of the allocation unit on which the page resides.

The asynchronous initialization is performed by a service task that is started by the create database or alter database commands. When it restarts, Adaptive Server automatically starts a new service task that completes the initialization. In a clustered environment, if an instance running the service task fails or is shut down, the coordinating instance starts a new service task to complete the initialization.