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.
|
