Saturday, 24 August 2013

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

No comments:

Post a comment