Databases Wizard (Sybase ASE)

Databases (Sybase ASE) - Properties

When creating or editing a database, this tab/panel lets you work with the following settings:

Category	Setting and Availability	Description
Creation Properties	Database Name	Provide a name for the database.
	Type	Generate variations on the CREATE DATABASE DDL generated to create the database, as follows: DEFAULT. Generates a generic CREATE DATABASE statement. TEMP. Generates a CREATE TEMPORARY DATABASE variation. ARCHIVE. Generates a CREATE ARCHIVE DATABASE variation.
	In-memory (Available with a Type of TEMP or DEFAULT and available as of Sybase ASE 15.5.)	Generates CREATE INMEMORY DATABASE DDL, indicating that this is an in-memory database. For information setting up data caches and database devices for in-memory databases, see Data Caches Wizard (Sybase ASE) and Databases Device Wizard (Sybase ASE).
	Scratch Database (Available with a Type of ARCHIVE.)	Lets you provide a WITH SCRATCH_DATABASE parameter value, specifying the name of an existing database that stores information about the archive database.
	For Proxy Update (Available with a Type of DEFAULT and not available if For Load is selected.)	Adds a FOR PROXY_UPDATE parameter to the generated DDL, forcing resynchronization of proxy tables with the proxy database. For information on how to resynchronize an existing database, see Resynchronize.
	For Load (Available with a Type of DEFAULT and not available if For Proxy Update is selected.)	This option speeds loading by eliminating the step for pre-initializing panels. The for load option is appropriate when creating a database for recovering from media failure or moving a database from one machine to another.
	With Override (Available with a Type of TEMP or DEFAULT.)	Enable this option to specify whether logs and data are to be kept on the same logical device.
	With Default Location (Available with a Type of DEFAULT.)	Lets you add a WITH DEFAULT_LOCATION clause value, specifying a storage location for new tables. If you also select For Proxy Update, one proxy table will be automatically created for each remote table or view.
	Durability (Available with a Type of TEMP or DEFAULT. Relaxed Durability databases are available as of Sybase ASE 15.5.)	Lets you select a WITH DURABILITY= parameter value of NO RECOVERY, FULL, or AT SHUTDOWN, specifying the durability level of the database. With In-memory selected, the only valid selection is NO RECOVERY.
Options	The GENERATE DDL is followed by an sp_dboption call for each option selected in this group.
	With a Type of ARCHIVE	single user . Generates a sp_dboption call specifying the SINGLE USER option, restricting database access to one user at a time.
	With a Type of TEMP or DEFAULT	In addition to the single user option, the following sp_dboption database options are available: abort tran on log full allow nulls by default auto identity dbo use only ddl in tran identity in nonunique index no chkpt on recovery no free space acctg read only select into/bulkcopy/pllsort single user trunc log on chkpt unique auto_identity index For Sybase ASE 15.0 databases, scratch database, async log service option, and delayed commit options also are available.