Dump Devices Wizard (Sybase ASE)

Go Up to Sybase ASE Object Wizards

Your system writes its memory image to a dump device so you can retrieve data if your system crashes. All load and dump operations require that you name a device before the operation will complete. When you create a new dump device, ASE adds a row to the sysdevices table in the master database. Sybase recommends that you back up the master database before you create a new device and again after you have created the device. Be sure you have enough disk space on the physical drive to perform these operations.

To create a new dump device using a wizard:

1. Open an object creation wizard for a dump device. 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:
   • Properties panel - for details, see Dump Devices (Sybase ASE) - Properties.
   • DDL View panel - for details, see Previewing the DDL Generated to Create the New Object.
3. Finally, use the Execute button to create the object.

Dump Devices (Sybase ASE) - Properties

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

Setting	Description
Name	This is the device’s logical name.
Physical Name	The device or file name that is recognized by the operating system. (For example, a:sqltable.dat).
Device Type	Select TAPE or DISK.