Monitoring and controlling DB2 and its connections

You can control and monitor various aspects of a DB2® for z/OS® environment. These operations require you to have more of an understanding of what DB2 is doing.

  • 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.
  • Controlling user-defined functions
    User-defined functions are extensions to the SQL language, which you can invoke in an SQL statement wherever you can use expressions or built-in functions.
  • Controlling DB2 utilities
    DB2 utilities are classified into two groups: online and stand-alone.
  • Controlling the IRLM
    The internal resource lock manager (IRLM) subsystem manages DB2 locks.
  • Monitoring threads
    You monitor threads by using the DB2 DISPLAY THREAD command, which displays current information about the status of threads.
  • Controlling connections
    The method that you use to control connections between DB2 and another subsystem or environment depends on the subsystem or environment that is involved.
  • Controlling traces
    Several traces are available for problem determination.
  • Setting the priority of stored procedures
    Stored procedure priority is inherited from the caller. The stored procedure always runs at the dispatching priority of whatever called it.
Parent topic: Operation and recovery
Related tasks:
Controlling DB2 operations by using commands
Monitoring and analyzing DB2 performance data
Controlling resource usage
Setting limits for system resource usage by using the resource limit facility
Monitoring threads and connections by using profiles
Updating subsystem parameter and application default values