This chapter considers only the DSN commands and the DB2 commands.
DSN, the DB2 command processor, executes as a TSO command. All subcommands except SPUFI run under DSN in either the foreground or the background. All subcommands except END also run under DB2 Interactive (DB2I). SPUFI runs only in the foreground under ISPF. The DSN commands/subcommands and their functions are listed in Table 2-2.
Table 2-2. DSN Commands/Subcommands
Command/Subcommand | Function |
|---|
ABEND | Causes the DSN session to terminate with an X'04E' |
BIND | Builds an application package or plan |
DB2 command | Executes a DB2 command |
DCLGEN (declarations generator) | Produces declarations for tables or views |
DSN | Starts a DSN session |
END | Ends a DSN session |
FREE | Deletes an application package or plan |
REBIND | Updates an application package or plan |
REBIND TRIGGER PACKAGE | Updates an application trigger package |
RUN | Executes an application program |
SPUFI | Executes the SQL processor using file input |
* | Comment |
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. The DB2 commands and their functions are listed in Table 2-3.
Table 2-3. DB2 Commands
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 |
A DSN9022I message indicates the normal end of DB2 command processing. A DSN9023I message indicates the abnormal end of DB2 command processing.
