Previous Topic Next topic Print topic


Managing Locations

A location is a collection of tables, databases, and related objects organized in a specific structure. An XDB Server can have multiple locations, all managed by the same database server. Depending on the options you have installed, SQLWizard can also access locations managed by other XDB Servers, as well as DB2 and other DRDA systems. Through the use of a three-part naming convention and related security measures, you can access more than one location at a time, including remote locations.

Connecting to a location provides you direct access to that location, without having to qualify table names with a location name. You set your initial (default) location in the Options utility. You can choose a different location each time you start SQLWizard by selecting a location on the Connect dialog box. After SQLWizard is running, you can change your current location using the Set Location command from the Location menu.

SQLWizard displays the current location and current SQLID in the status bar at the lower right of the SQLWizard window. Whenever you create, alter, or access a data object, this location and SQLID is used to qualify the table names.

You will also see a SYSTEM location listed in the Catalog Browser dialog box. This location contains system administration and security information. Do not store your data objects in this location. It is reserved for system use. Keep your data in locations that you or your XDB Server Administrator create.

Note: An XDB Server location roughly corresponds to a DB2 subsystem. However, you cannot use the XDB Server location windows to manage a DB2 subsystem. These windows are intended only for use with XDB Server locations.
Previous Topic Next topic Print topic