Create/Alter/Drop Location Dialog Box

Restriction: This topic applies to Windows environments only.

Use the Create/Alter/Drop Location dialog box to define, change, or delete XDB Server locations. You access the Create/Alter/Drop Location dialog box using the Create, Alter, and Drop commands on the Location menu. Regardless of whether you are creating, altering, or dropping a location, this dialog box is essentiallythe same.

The following describes all fields on the Create/Alter/Drop Location dialog box.

Location	A location is a collection of databases, tables, indexes, and related objects organized in a specific structure. An XDB Server can have multiple locations, all managed by the same database server. Name Specifies the name of the location. A location name may be up to 16 characters long, and must be unique among all of the locations that reside on a given XDB Server. Creator Specifies the AuthID of the person who created the location. The default is to use your current SQLID, but you can change this if you are authorized to use a different SQLID. Path Specifies the directory where your location files are stored. When creating a location, if you name a directory that does not exist, SQLWizard creates it for you.
Forward Log	If using XDB Server version 4.`x` and earlier, you must specify the name of the file used for forward logging. In XDB Server version 5 and later, this file is automatically created by the system, however you can specify the directory to which it is stored. Name Specifies the name of the file that will be used as the Forward Log. SQLWizard uses up to eight characters of the location name as a default forward log file name. You can change it if desired. Path Specifies the directory in which the Forward Log will be stored (under XDB Server version 5 and later; the Backward Log is placed in this directory too). SQLWizard uses the location path as the default, but if possible, it is best to use a different physical drive for the Forward Log. Keeping the Forward Log on a different drive will enable you to restore your database in the event of a disk failure on the drive containing your location and database files.
Sort Sequence	SQLWizard allows you to specify the sort sequence to be used for ordering and comparing data on a per location basis. Select one of these sort sequences from the drop-down list: Case Insensitive ASCII ASCII EBCDIC Sensitive User Defined Classic EBCDIC `Language` EBCDIC
Remarks	Type any comments about the location in this field. Comments can be up to 30 characters.
SQL	Click this to examine the SQL statements represented by the entries you have made.