Commands for controlling DB2 and related facilities

You can use commands to perform many of the tasks that are required to control and maintain your DB2® subsystem.

For example, you use commands to take the following actions to control DB2 subsystem, and more:

  • Start and stop the subsystem and its facilities through commands such as the START DB2 and STOP DB2 commands.
  • Request information about the status of the subsystem and its facilities through various DISPLAY commands.
  • Modify the configuration of the subsystem through commands such as SET SYSPARM and various ALTER commands
  • Control connections to the subsystem from various attachment facilities

For a complete list of commands that you can issue to control the operation of a DB2 subsystem, see DB2 and related commands.

Types of commands for controlling DB2

You can control most aspects of the operation of a DB2 subsystem by using the DSN command of TSO and its subcommands and DB2 commands. However, certain aspects of the DB2 subsystem, such as connections for various attachement facilities, and the z/OS® internal resource lock manager (IRLM) require the use of other types of commands.

You might need to use any of the following types of commands to control DB2 operations:

  • The TSO command DSN and its subcommands
  • DB2 commands
  • CICS® attachment facility commands
  • IMS™ commands
  • Administrative task scheduler commands
  • z/OS IRLM commands
  • TSO CLISTs
For descriptions of the different command types, see Types of commands.

Where and how to enter commands

Within the z/OS environment, you can issue most types of commands from different interactive contexts, including the following consoles and terminals:
  • z/OS consoles
  • TSO terminals, by any of the following methods:
    • Issuing the DSN command from the TSO READY prompt
    • Entering commands in the DB2 Commands panel inDB2I
  • IMS terminals
  • Authorized CICS terminals
You can issue many commands from the background within batch programs, such as the following types of programs:
  • z/OS application programs
  • Authorized CICS programs
  • IMS programs
  • Start of changeAPF-authorized programs, such as a terminal monitor program (TMP)End of change
  • IFI application programs

For information of about where and how you can issue commands, see Controlling DB2 operations by using commands.