The async_init parameter for the alter database and create database commands lets you asynchronously initialize a database while it is being used. That is, the database is immediately available when it is created or altered, not when the database initialization is complete. The initialization is transparent to the user.
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 command. 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.
