DBA basics

This topic includes the following sections:


DBA enables you to view and customize elements of the system catalog. This topic explains how to start DBA and how to use DBA command-line options, menus, windows, and lists. For information on opening a system catalog in DBA, see Opening a system catalog in DBA.

Starting DBA


To run DBA on a UNIX system, you must have configured your session for the Synergy/DE runtime by sourcing setsde. For information, see UNIX requirements.

To start DBA, do one of the following:

dbr SODBC_DBA:xfdba.dbr [option] [...]
XFDBA [option] [...]

Command line options

You can use the following command line options when starting DBA. All are optional.

-c username/password/connect_filename

Specifies the username, password, and connect file. If you use this option, DBA opens the system catalog specified in the connect file. For information and examples, see Opening a system catalog from the command line.

-g conversion_setup_file

Generates a conversion setup file. Conversion_setup_file specifies the path and filename of the generated file. This setting overrides the SODBC_CNVFIL environment variable setting. For client/server configurations, the conversion setup file must be on the server. Valid only with -c.


Initializes existing user and group files to default values. For information and examples, see Initializing users and groups. Valid only with -c.

-v verification_log

Creates a log that lists each table and compares stored counts with actual record counts. Verification_log specifies the path and filename of the generated log file. If you don’t specify a path, the log is saved to the current working directory. Valid only with -c.

Using menus

You can select a menu entry in DBA when the menu bar is active. To activate the menu bar on Windows, simply click the menu bar or press alt. To activate the menu bar on UNIX or OpenVMS, press ctrl+p.

In addition to using the arrow keys to move across menu headings and among menu entries (and enter to select a highlighted entry), you can use the following:

Using input windows

On Windows, shift+tab moves the cursor to the previous field in the current input window; tab moves to the next field.

On UNIX and OpenVMS, use the up arrow key or select Input > Previous Field or List > Previous Field to return to the previous field in the current input window. Use the down arrow key or select Input > Next Field or List > Next Field to move the cursor to the next field.

If a field is optional and does not have a default value, you can leave the field blank by pressing enter. If an optional field has a default value, you can clear the field by pressing the spacebar or the backspace key. Then press enter to move to the next field.

To save your changes and exit the current input window or list, select General > Exit or use the Exit shortcut (F4). You are returned to the previous window or menu.

To exit an input window without saving any changes, select General > Abandon.

Using lists

To edit a list entry, highlight the entry and press enter. If it can be edited, an input window opens. To exit a list, press F4.

In the Table List, you can search for an entry by selecting List > Find. An input window is displayed. Enter the name or partial name of the entry you wish to find. DBA highlights the first matching entry in the list.

In the Table List, columns or a portion of a column may extend beyond the edge of the window. To view hidden areas of the Table List, select List > Toggle View.

Abandoning changes

To restore the data in a field to its original state on UNIX or OpenVMS (the state it was in before you typed anything), select Input > Reset Field.

To abandon changes to all fields, select General > Abandon. Data you entered in the current input window is discarded, the original data for that window is restored, and the window is closed. On Windows, the close button also abandons changes for the current input window.

Exiting DBA

To exit DBA, do one of the following: