Creating a Location

When SQLWizard creates a location, the system creates a directory structure for the new location, as well as all of the system catalog tables required by the location. Information about the new location is added to the catalog tables in the SYSTEM location. You create a location using the Create command from the Location menu. See Create/Alter/Drop Location Dialog Box for an explanation of each option on this dialog box.

To create a location:

  1. Click the Create command from the Location menu.
    Note:


    Catalog Browser button
    From the Catalog Browser dialog box, click the Location tab; then click the Create button.

    SQLWizard displays the Create Location dialog box.

  2. Provide a name for the new location in the Location Name field. The name can be up to 16 characters long. This name must be unique among all locations you can access on the current XDB Server. To be sure you do not attempt to use the name of an existing location, click the down-arrow button to view the existing names on the drop-down list.
  3. Provide a drive and directory in the Location Path field. SQLWizard creates the location in this directory. Use a different directory for each XDB Server location you create. Do not use an XDB Server location directory for storing anything else.
  4. If you want to change the name of the file to which the Forward Log is written, type a new name in the Forward Log Name field (in XDB Server version 4.x and earlier, only).
  5. If you want to change the directory to which the Forward Log is written, type a new path name in the Forward LogPath field (in XDB Server version 5 and later; the Backward Log is placed in this directory too).

    If possible, assign the log file to a physical device different from that of your database. This will ensure that you can recover if the disk containing your database fails.

    Note:

    You must specify a directory that will be used exclusively for this location's log files. Be certain not to specify a directory that is already assigned to another location.

    The directory path is limited to 255 bytes. This restriction is due to limits imposed by the XDB SYSTEM location.

  6. If you want to disable forward logging, clear the Forward Log On checkbox (XDB Server version 4.x and earlier, only; this checkbox will be grayed if you're running version 5 or later).

    Since the forward logging facility used by XDB Servers version 4.x and earlier increases your overhead, you may choose not to use it for performance reasons. Be aware, however, that disabling this option will significantly limit your ability to recover data in the event of a failure.

  7. Select a Sort Sequence for the location, or use the default specified. Click the down-arrow button to view the existing options on the drop-down list. The sort sequence is used for XDB Server indexes, as well as for user-program sorts.
  8. Click OK to create the location.