DB2EEE_DB Database Administration menu

List Applications

displays a list of all the applications connected to the active DB2 Database Manager (DBM) instance

Force Application

• forces all applications offline in a DB2 DBM instance, or
• forces off applications connected to a database, or
• forces off a particular DB2 agent

Show DB Configuration

displays the database configuration file at a selected node

Update DB Configuration

updates the database configuration file for a specific database on a node

Reset DB Configuration

resets the database configuration file to the default configuration options

Activate Database

activates a database and starts up all necessary database services

Deactivate Database

deactivates a database that has been activated using the Activate Database command

List Tables

displays a list of the tables defined for a database

Reorganize Check

determines whether a table is fragmented and needs to be reorganized for better performance

Reorganize Table

eliminates fragmented or sparse data in a table by reorganizing it

Run Statistics

updates and displays statistical information about the physical characteristics of a table and its associated indexes

Import Data

inserts data from an external file into a table or view

Export Data

exports data from a database to one of several external file formats

Load Data

loads data from files, tapes, or named pipes into a table

Tablespace Discovery

enables the PATROL Agent to start discovering any tablespaces for a database the next time discovery runs

Create Tablespace

creates an additional tablespace in a database

List Tablespaces

displays a list of all the tablespaces for a database

List Tablespace Containers

displays a list of all tablespace containers for a tablespace

Quiesce Tablespace

quiesces tablespaces for a table

Restart Database

restarts a database that has been terminated abnormally and left in an inconsistent state

Process Indoubt Transactions

processes all the distributed transactions that are in an incomplete and unknown state for a database

Create Bufferpool

creates a buffer pool for a database

Alter Bufferpool

changes the attributes of a database bufferpool

Drop Bufferpool

deletes (drops) a buffer pool from a database