SET LOCATION

Use this command to prevent all users, except for those with SYSADM privileges, from logging on to a location on the XDB Server. This command does not affect users who are already using the location.
Note:

The XDB Server does not allow you to take a location offline while it is in use. You can use the DISABLE LOGIN command to prevent new users from logging on to the server. If you need to take the location offline immediately, you can force active users off the location using the XDB Server Monitor.

Invocation

This command can be embedded in a host language or executed interactively.

Authorization

Any of the following:

  • A super user
  • A user with SYSADM privileges

Syntax

SET LOCATION location-name {OFFLINE | ONLINE}

Parameters:

location-name Identifies the location that you want to place online or offline.
Parent topic: SQL Statements