Databases Wizard (Sybase ASE)

From DBArtisan
Jump to: navigation, search

Go Up to Sybase ASE Object Wizards

The Database Wizard lets you create a database (a structured collection of data that can be updated or queried) without knowing the underlying commands. Databases can be simple, that is one file with many records and the same fields, or much more complicated with multiple files with different fields.

To create a new database using a wizard:

  1. Open a creation wizard for a database. For details, see Opening an Object Wizard.
  2. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
  3. Finally, use the Execute button to create the object.

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.


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) This feature is 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 using DBArtisan, 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) This feature is available as of Sybase ASE 12.5.

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.


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, and unique auto_identity index. For Sybase ASE 15.0 databases, scratch database, async log service option, and delayed commit options are available.

Databases (Sybase ASE) - Placement

In the Fragment Properties area provide or select values for the default fragment: Device Name, Size for the fragment, and a Device Type value of DATA ONLY, LOG ONLY, or DATA AND LOG. For databases with a Properties tab/panel Type selection of ARCHIVE, no LOG ONLY Device Type selection is available.

If necessary use the New button to add a new fragment and repeat the steps above to provide details for that fragment. Use the Delete button to drop a fragment.