Controlling DB2 databases and buffer pools

You can use various commands to control DB2® databases and buffer pools. The commands that you issue depend on the type of action that you want to take.

Procedure

Begin general-use programming interface information.

To control databases and buffer pools:

Issue the START DATABASE, STOP DATABASE, or DISPLAY DATABASE commands.

START DATABASE: Makes a database or individual partitions available. Also removes pages from the logical page list (LPL).
DISPLAY DATABASE: Displays status, user, and locking information for a database.
STOP DATABASE: Makes a database or individual partitions unavailable after existing users have quiesced. DB2 also closes and deallocates the data sets.

End general-use programming interface information.

Starting databases
Issue the START DATABASE (*) command to start all databases for which you have the STARTDB privilege.
Monitoring databases
You can use the DISPLAY DATABASE command to obtain information about the status of databases and the table spaces and index spaces within each database. If applicable, the output also includes information about physical I/O errors for those objects.
Obtaining information about application programs
You can obtain various kinds of information about application programs that use particular databases, table spaces, or index spaces by using the DISPLAY DATABASE command. You can identify who or what is using an object and what locks are being held on various objects.
Obtaining information about and handling pages in error
You can view information about pages that are in error.
Making objects unavailable
You can make databases, table spaces, and index spaces unavailable by using the STOP DATABASE command.
Altering buffer pools
DB2 stores buffer pool attributes in the DB2 bootstrap data set (BSDS). You can change buffer pool attributes.
Monitoring buffer pools
You can display the current status for one or more active or inactive buffer pools. You can also request a summary or detail report.

Parent topic: Monitoring and controlling DB2 and its connections

Related tasks:

Monitoring databases

Starting databases

Making objects unavailable

Related reference:

-START DATABASE (DB2)

-DISPLAY DATABASE (DB2)

-STOP DATABASE (DB2)