ADD CONTACT command
Adds a contact to the contact list which can
be either defined locally on the system or in a global list. Contacts
are users to whom processes such as the Scheduler and Health Monitor
send messages.
ADD CONTACTGROUP command
Adds a new contact group to the list of groups
defined on the local system. A contact group is a list of users and
groups to whom monitoring processes such as the Scheduler and Health
Monitor can send messages.
AUTOCONFIGURE command
Calculates and displays initial values for
the buffer pool size, database configuration and database manager
configuration parameters, with the option of applying these recommended
values.
BIND command
Invokes the bind utility, which prepares SQL statements
stored in the bind file generated by the precompiler, and creates
a package that is stored in the database.
CATALOG DATABASE command
Stores database location information in the system
database directory.
The database can be located either on the local workstation or on
a remote database partition server.
CATALOG DCS DATABASE command
Stores information about remote host or System i® databases
in the Database
Connection Services (DCS)
directory.
CATALOG TCPIP/TCPIP4/TCPIP6 NODE command
Adds a Transmission Control Protocol/Internet Protocol
(TCP/IP) database partition server entry to the node directory. The
TCP/IP communications protocol is used to access the remote database
partition server. The CATALOG TCPIP/TCPIP4/TCPIP6 NODE command
is run on a client.
CHANGE DATABASE COMMENT command
Changes a database comment in the system
database directory or
the local database
directory.
New comment text can be substituted for text currently associated
with a comment.
CHANGE ISOLATION LEVEL command
Changes the way that DB2® isolates
data from other processes while a database is being accessed.
COMPLETE XMLSCHEMA command
Completes the process of registering an XML schema in the
XML schema repository (XSR).
CREATE DATABASE command
Initializes a new database with an optional user-defined
collating sequence, creates the three initial table spaces, creates
the system tables, and allocates the recovery log file. When you initialize
a new database, the AUTOCONFIGURE command is issued
by default.
DECOMPOSE XML DOCUMENTS command
Decomposes XML documents stored in a database column. The
data from the XML documents is stored in columns of relational tables
based on annotations specified in an XML schema.
DESCRIBE command
The DESCRIBE command displays
metadata about the columns, indexes, and data partitions of tables
or views. This command can also display metadata about the output
of SELECT, CALL, or XQuery statements.
DROP CONTACT command
Removes a contact from the list of contacts
defined on the local system. A contact is a user to whom the Scheduler
and Health Monitor send messages. The setting of the Database Administration
Server (DAS) contact_host configuration parameter
determines whether the list is local or global.
DROP CONTACTGROUP command
Removes a contact group from the list of contacts
defined on the local system. A contact group contains a list of users
to whom the Scheduler and Health Monitor send messages. The setting
of the Database Administration Server (DAS) contact_host configuration
parameter determines whether the list is local or global.
DROP DATABASE command
Deletes the database contents and log files for the database,
uncatalogs the database, and deletes the database subdirectory.
EXPORT command
Exports data from a database to one of several
external file formats. The user specifies the data to be exported
by supplying an SQL SELECT statement, or by providing hierarchical
information for typed tables.
FORCE APPLICATION command
Forces local or remote users or applications
off the system to allow for maintenance on a server.
GET MONITOR SWITCHES command
Displays
the status of the database system monitor switches for the current
session. Monitor switches instruct the database manager to collect
database activity information. Each application using the database
system monitor interface has its own set of monitor switches. This
command displays them. To display the database manager-level switches,
use the GET DBM MONITOR SWITCHES command.
GET SNAPSHOT command
Collects status information and formats the output for
the user. The information returned represents a snapshot of
the database
manager operational
status at the time the command was issued.
HELP command
Permits the user to invoke help from the Information Center.
IMPORT command
Inserts data from an external file with a supported
file format into a table, hierarchy, view or nickname. LOAD is
a faster alternative, but the load utility does not support loading
data at the hierarchy level.
INITIALIZE TAPE command
Initializes tapes for backup and restore operations
to streaming tape devices. This command is only supported on Windows operating systems.
LIST APPLICATIONS command
Displays to standard output the application
program name, authorization ID (user name), application handle, application
ID, and database name of all active database applications. This command
can also optionally display an application's sequence number, status,
status change time, and database path.
LIST DATABASE DIRECTORY command
Lists the contents of the system
database directory.
If a path is specified, the contents of the local database
directory are
listed.
LIST DCS APPLICATIONS command
Displays to standard output information about applications
that are connected to host databases via DB2 Connect™ Enterprise Edition.
LIST INDOUBT TRANSACTIONS command
Provides a list of transactions that are indoubt. The user
can interactively commit, roll back, or forget the indoubt transactions.
LOAD QUERY command
Checks the status of a load operation during
processing and returns the table state. If a load is not processing,
then the table state alone is returned.
PRECOMPILE command
Processes an application program source file containing
embedded SQL statements. A modified source file is produced, containing
host language calls for the SQL statements and, by default, a package
is created in the database.
PRUNE HISTORY/LOGFILE command
Used to delete entries from the recovery history
file or to delete log files from the active log file path.
Deleting entries from the recovery history file might be necessary
if the file becomes excessively large and the retention period is
high.
REDISTRIBUTE DATABASE PARTITION GROUP command
Redistributes data across all partitions in
a database partition group. This command affects all objects present
in the database partition group and cannot be restricted to one object
alone.
RESET ALERT CONFIGURATION command
Resets the health indicator settings for specific
objects to the current defaults for that object type or resets the
current default health indicator settings for an object type to the
install defaults.
REWIND TAPE command
Rewinds tapes for backup and restore operations
to streaming tape devices. This command is only supported on Windows operating systems.
ROLLFORWARD DATABASE command
The ROLLFORWARD DATABASE command recovers
a database by applying transactions recorded in the database log files.
This command can be run after a database or a table space backup image
has been restored, or if any table spaces have been taken offline
by the database due to a media error.
RUNSTATS command
Updates
statistics in the system catalog about the characteristics of a table
and/or associated indexes, or statistical views. These characteristics
include number of records, number of pages, and average record length.
The optimizer uses these statistics when determining access paths
to the data.
SET TAPE POSITION command
Sets the positions of tapes for backup and
restore operations to streaming tape devices. This command is only
supported on Windows operating
systems.
SET WORKLOAD command
Specifies the workload to which the database connection
is to be assigned. This command can be issued prior to connecting
to a database or it can be used to reassign the current connection
once the connection has been established. If the connection has been
established, the workload reassignment will be performed at the beginning
of the next unit of work.
UNQUIESCE command Restores user access to
instances or databases which have been quiesced for maintenance or
other reasons.UNQUIESCE restores
user access without necessitating a shutdown and database restart.
UPDATE CONTACT command
Updates the attributes of a contact that is
defined on the local system. A contact is a user to whom the Scheduler
and Health Monitor send messages.
UPDATE CONTACTGROUP command
Updates the attributes of a contact group that
is defined on the local system. A contact group is a list of users
who should be notified by the Scheduler and the Health Monitor.
UPDATE DATABASE CONFIGURATION command
Modifies individual entries in a specific database
configuration file. A database configuration file resides on every database partition
on which the database has been created.