Utility commands perform administrative functions on the XDB Server.
Enables you to change passwords.
Makes a backup copy of an entire XDB Server location to a specified directory path.
BULK ON turns the Bulk Upload feature on for all subsequent transactions. Bulk uploading allows data to be transferred to the client in bulk, instead of one row at a time (used with XDB Link). BULK OFF turns the Bulk Upload feature off.
Flushes the entire logging system cache buffer to disk and flushes database cache buffer.
Recycles unused disk space by packing tables, rebuilding indexes and reorganizing directory files.
Creates additional XDB user accounts.
Prevents additional users from logging on to the server.
Permits users to log on to the server again after a DISABLE LOGIN command has been issued.
Acquires access path selection information about an "explainable" SQL statement, and inserts the information into a special table (automatically created by the XDB Server) named PLAN_TABLE. Users have the option of creating their own plan_table structure.
Terminates a specific query.
Directs the XDB Server to re-read the information contained in the SYSIBM.SYSLOCATIONS catalog table. REFRESH LOCATIONS is typically issued after information in this table has been manually updated by the user.
Refreshes the data in a materialized query table.
Applies all DML changes recorded in a forward log file to a location backup copy. The ROLLFORWARD command restores the information in a location to the condition existing before the last location backup.
Sets the autocommit feature on or off. Setting autocommit to "on" causes a commit to be automatically generated after any DML command.
Changes the value of the CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION special register.
Assigns a value to the CURRENT PACKAGE PATH special register.
Assigns a value to the CURRENT PACKAGESET special register.
Changes the value of the CURRENT REFRESH AGE special register.
Assigns a value to the CURRENT RULES special register.
Changes the AuthID value stored in the CURRENT SQLID special register.
Defines the isolation level used to determine appropriate lock acquiring and lock releasing procedures for an executing transaction.
Lets the system administrator prevent or permit access to a specific location.
Logs a user onto a new location, creating an implied connection between the user's current session and the specified location. The value of the CURRENT LOCATION special register is temporarily updated to reflect the new active location. The user's default location is not changed.
Allows database administrators (with SYSADM authority or higher) to suspend logging system operation during an administrative session, and change the path where location log files are stored.
Assigns a value to the CURRENT SCHEMA special register.
Changes the size of the sort space while the XDB Server is running.
Stops an XDB Server from a remote client.
Allows users to have access to the contents of the named database.
Restricts all access to the named database.
Deletes records from a table much like the DELETE command, but proceeds much faster since the deleted data is not logged.