DB2 Commands Quick Reference

The command START DB2 can be issued only from a z/OS console or Authorized Program Facility (APF) passing it to the console. All other DB2 commands can be issued from the following:

• APF authorized program
• CICS terminal
• DB2I panel
• IFI application program
• IMS terminal
• TSO terminal session
• z/OS console or z/OS application program

 An application program may use the DB2 Instrumentation Facility Interface to issue DB2 commands. DB2 commands issued from an MVS console are not associated with any secondary authorization IDs.

Command	Function
-ALTER BUFFERPOOL	Alters attributes for the buffer pools
-ALTER GROUPBUFFERPOOL	Alters attributes for the group buffer pools
-ALTER UTILITY	Alters parameter values of the REORG utility
-ARCHIVE LOG	Enables a site to close a current active log and open the next available log data set
-CANCEL THREAD	Cancels processing for specific local or distributed threads
-DISPLAY ARCHIVE	Displays information about archive-log processing
-DISPLAY BUFFERPOOL	Displays information about the buffer pools
-DISPLAY DATABASE	Displays status information about DB2 databases
-DISPLAY DDF	Displays information regarding the status and configuration of the DDF
-DISPLAY FUNCTION SPECIFIC	Displays statistics about external user-defined functions
-DISPLAY GROUP	Displays information about the data sharing group to which a DB2 subsystem belongs and which mode DB2 is operating in
-DISPLAY GROUPBUFFERPOOL	Displays status information about DB2 group buffer pools
-DISPLAY LOCATION	Displays status information about distributed threads
-DISPLAY LOG	Displays log information and status of the offload task
-DISPLAYPROCEDURE	Displays status information about stored procedures
-DISPLAY RLIMIT	Displays status information about the resource limit facility (governor)
-DISPLAY THREAD	Displays information about DB2 threads
-DISPLAY TRACE	Displays information about DB2 traces
-DISPLAY UTILITY	Displays status information about a DB2 utility
-MODIFY TRACE	Changes the trace events associated with a particular active trace
-RECOVER BSDS	Reestablishes dual-bootstrap data sets
-RECOVER INDOUBT	Recovers threads left in doubt
-RECOVER POSTPONED	Completes backout processing for units of recovery left incomplete during an earlier restart
-RESET GENERICLU	Purges information stored by VTAM in the coupling facility
-RESET INDOUBT	Purges information displayed in the in-doubt thread report generated by the DISPLAY THREAD command
-SET ARCHIVE	Controls the allocation of tape units and the deallocation time of the tape units for archive-log processing
-SET LOG	Modifies the checkpoint frequency
-SET SYSPARM	Loads the subsystem parameters specified in the command
-START DATABASE	Makes the specified database available for use
-START DB2	Initializes the DB2 subsystem; can be issued only from an MVS console
-START DDF	Starts the Distributed Data Facility
-START FUNCTION SPECIFIC	Activates a stopped external function
-START PROCEDURE	Activates the definition of stopped or cached stored procedures
-START RLIMIT	Starts the resource limit facility (governor)
-START TRACE	Initiates DB2 trace activity 300
-STOP DATABASE	Makes specified databases unavailable for applications
-STOP DB2	Stops the DB2 subsystem
-STOP DDF	Stops the Distributed Data Facility
-STOP FUNCTION SPECIFIC	Stops the acceptance of SQL statements for specified functions
-STOP PROCEDURE	Stops the acceptance of SQL CALL statements for stored procedures
-STOP RLIMIT	Stops the resource limit facility (governor)
-STOP TRACE	Stops trace activity
-TERM UTILITY	Terminates execution of a utility

Created with Artisteer