DB2 and related commands
The references topics for commands contain syntax diagrams, semantic descriptions, rules,
and usage examples of commands. They are organized alphabetically by command name.
ABEND (DSN)
The DSN subcommand ABEND causes the DSN session to terminate with abend completion code
X'04E' and reason code of X'00C50101'. It is intended to be used at the direction of IBM® Software Support, if a problem is suspected (such as incorrect
output) with another DSN subcommand, and the problem does not cause an abend and a dump to be
generated.
-ACCESS DATABASE (DB2)
The DB2 command ACCESS DATABASE forces a physical open of a table
space, index space, or partition, or removes the GBP-dependent status for a table space, index
space, or partition. The MODE keyword specifies the action taken.
-ALTER BUFFERPOOL (DB2)
The DB2 command
ALTER BUFFERPOOL alters attributes for active or inactive buffer pools.
Altered values are used until altered again.
-ALTER GROUPBUFFERPOOL (DB2)
The DB2 command
ALTER GROUPBUFFERPOOL alters attributes of group buffer pools.
-ALTER UTILITY (DB2)
The DB2 command
ALTER UTILITY changes the values of certain parameters of an execution
of the REORG utility that uses SHRLEVEL REFERENCE or CHANGE and the
REBUILD utility that uses SHRLEVEL CHANGE.
-ARCHIVE LOG (DB2)
The DB2 command
ARCHIVE LOG enables a site to close a current active log and open
the next available log data set.
BIND PACKAGE (DSN)
The DSN subcommand BIND PACKAGE builds an
application package. DB2 records
the description of the package in the catalog tables and saves the
prepared package in the directory.
BIND PLAN (DSN)
The DSN subcommand BIND PLAN builds an application
plan. All DB2 programs require
an application plan to allocate DB2 resources
and support SQL requests made at run time.
BIND QUERY (DSN)
The DSN subcommand BIND QUERY reads the statement text, default schema, and a set of
bind options from every row of DSN_USERQUERY_TABLE, and information from correlated EXPLAIN table
rows. When LOOKUP(NO) is in effect, DB2 inserts the pertinent data into certain catalog tables.
BIND and REBIND options for packages and plans
There are several options you can use for
binding or rebinding plans and packages. Some of the options are common
for both bind and rebind and for both plans and packages.
Specification of DB2 for z/OS bind options from IBM Data Server clients and drivers
When you bind packages on DB2 for z/OS data
servers from IBM Data Server
clients and drivers, you need to specify bind options that are supported
by DB2 for z/OS but
not by DB2 for Linux, UNIX, and Windows as
generic bind options.
-CANCEL THREAD (DB2)
The DB2 command CANCEL
THREAD cancels processing for specific local or distributed
threads.
/CHANGE (IMS)
The IMS™ command
/CHANGE resets an indoubt unit of recovery as identified by the OASN
keyword of the /DISPLAY command. That command deletes the item from
the standpoint of IMS, but it
does not communicate to DB2 .
DCLGEN (DECLARATIONS GENERATOR) (DSN)
The declarations generator (DCLGEN) produces
an SQL DECLARE TABLE statement and a COBOL, PL/I, or C data declaration
for a table or a view named in the catalog.
/DISPLAY (IMS)
The IMS command
/DISPLAY displays the status of the connection between IMS and an external subsystem (as well as all
application programs communicating with the external subsystem), or
the outstanding recovery units that are associated with the subsystem.
-DISPLAY ACCEL (DB2)
The DISPLAY ACCEL command displays information
about accelerator servers.
-DISPLAY ARCHIVE (DB2)
The DB2 command
DISPLAY ARCHIVE displays input archive log information.
-DISPLAY BUFFERPOOL (DB2)
The DB2 command DISPLAY BUFFERPOOL displays the
current status for one or more active or inactive buffer pools.
-DISPLAY DATABASE (DB2)
The DB2 command DISPLAY DATABASE displays status
information about DB2 databases.
-DISPLAY DDF (DB2)
The DISPLAY DDF command displays information
regarding the status and configuration of DDF, as well as statistical
information regarding connections or threads controlled by DDF.
-DISPLAY FUNCTION SPECIFIC (DB2)
The DB2 command
DISPLAY FUNCTION SPECIFIC displays statistics about external user-defined
functions that DB2 applications
access.
-DISPLAY GROUP (DB2)
The DB2 command DISPLAY GROUP
displays information about the data sharing group to which a DB2 subsystem belongs.
-DISPLAY GROUPBUFFERPOOL (DB2)
The DB2 command
DISPLAY GROUPBUFFERPOOL displays information about the status of DB2 group buffer pools. It can also
display related statistics.
-DISPLAY LOCATION (DB2)
The DB2 command
DISPLAY LOCATION displays various information about the specified
remote locations.
-DISPLAY LOG (DB2)
The DB2 command
DISPLAY LOG displays log information about, and the status of, the
offload task.
-DISPLAY PROCEDURE (DB2)
The DB2 command
DISPLAY PROCEDURE displays statistics about stored procedures that
are accessed by DB2 applications.
-DISPLAY PROFILE (DB2)
The DISPLAY PROFILE command allows you to determine
if profiling is active or inactive
-DISPLAY RLIMIT (DB2)
The DB2 command
DISPLAY RLIMIT displays the current status of the resource limit facility
(governor).
-DISPLAY THREAD (DB2)
The DB2 command
DISPLAY THREAD displays current status information about DB2 threads.
-DISPLAY TRACE (DB2)
The DB2 command
DISPLAY TRACE displays a list of active traces.
-DISPLAY UTILITY (DB2)
The DB2 command
DISPLAY UTILITY displays the status of utility jobs, including utility
jobs in a data sharing group.
DSNH (TSO CLIST)
The DSNH command procedure (a TSO CLIST) is
a powerful yet easy method of preparing an application program for
execution.
END (DSN)
The DSN subcommand END is used to end the
DSN session and return to TSO.
FREE PACKAGE (DSN)
The DSN subcommand FREE PACKAGE can be used
to delete a specific version of a package, all versions of a package,
or whole collections of packages.
FREE PLAN (DSN)
The DSN subcommand FREE PLAN deletes application
plans from DB2 .
FREE QUERY (DSN)
The DSN subcommand FREE QUERY removes from
certain catalog tables for one or more queries. If any of the specified
queries are in the dynamic statement cache, FREE QUERY purges them
from the dynamic statement cache.
MODIFY admtproc,APPL=SHUTDOWN
The MODIFY admtproc ,
APPL=SHUTDOWN command stops the administrative task scheduler from
accepting requests and starting new task executions. It also shuts
down the administrative task scheduler.
MODIFY admtproc,APPL=TRACE
The MODIFY admtproc ,
APPL=TRACE command starts or stops traces in the administrative task
scheduler.
-MODIFY DDF (DB2)
The MODIFY DDF command modifies information regarding the status and configuration of
DDF, as well as statistical information regarding connections or threads controlled by
DDF.
MODIFY irlmproc,ABEND (z/OS IRLM)
The MODIFY irlmproc ,
ABEND command terminates IRLM abnormally. IRLM processes this command
even if a DB2 subsystem is identified
to it.
MODIFY irlmproc,DIAG (z/OS IRLM)
The MODIFY irlmproc ,
DIAG command initiates diagnostic dumps for IRLM subsystems.)
MODIFY irlmproc,PURGE (z/OS IRLM)
The MODIFY irlmproc,PURGE command releases
IRLM locks retained due to a DB2 ,
IRLM, or system failure.
MODIFY irlmproc,SET (z/OS IRLM)
The MODIFY irlmproc,SET command dynamically
sets various IRLM operational parameters
MODIFY irlmproc,STATUS (z/OS IRLM)
The MODIFY irlmproc,STATUS command displays
information for one or more subsystems connected to the IRLM that
is specified using irlmproc .
-MODIFY TRACE (DB2)
The DB2 command
MODIFY TRACE changes the IFCIDs (trace events) associated with a particular
active trace.
REBIND PACKAGE (DSN)
The DSN subcommand REBIND PACKAGE rebinds
an application package when you make changes that affect the package,
but have not changed the SQL statements in the program.
REBIND PLAN (DSN)
The DSN subcommand REBIND PLAN rebinds an application plan when you make
changes to the attributes of the plan, such as the package list.
REBIND TRIGGER PACKAGE (DSN)
The DSN subcommand REBIND
TRIGGER PACKAGE rebinds a package that was created when DB2 executed a CREATE TRIGGER statement.
-RECOVER BSDS (DB2)
The DB2 command
RECOVER BSDS reestablishes dual bootstrap data sets (BSDS) after one
has been disabled by a data set error.
-RECOVER INDOUBT (DB2)
The DB2 command
RECOVER INDOUBT recovers threads that are left in an indoubt state
because DB2 or a transaction
manager could not automatically resolve the indoubt status with the
commit coordinator.
-RECOVER POSTPONED (DB2)
The DB2 command RECOVER
POSTPONED completes back-out processing for units of recovery that are left incomplete during an
earlier restart (POSTPONED ABORT units of recovery). Use this command when automatic resolution is
not selected.
-REFRESH DB2,EARLY (DB2)
The DB2 command -REFRESH DB2 ,EARLY reloads the ERLY code modules that were loaded at IPL time, and rebuilds the ERLY control block.
-RESET GENERICLU (DB2)
The RESET GENERICLU command allows you to
purge information stored by VTAM® in
the coupling facility for one or more partners of a particular DB2 subsystem.
-RESET INDOUBT (DB2)
The DB2 command
RESET INDOUBT purges the information that is displayed in the indoubt
thread report that is generated by the DISPLAY THREAD command.
RUN (DSN)
The DSN subcommand RUN executes an application
program, which can contain SQL statements.
-SET ARCHIVE (DB2)
The DB2 command
SET ARCHIVE sets the maximum number of tape units for the archive
log. It also sets the maximum deallocation time of tape units for
the archive log.
-SET LOG (DB2)
The DB2 command SET LOG modifies the checkpoint
frequency that is specified during installation. This command also overrides the value that was
specified in a previous invocation of the SET LOG command.
-SET SYSPARM (DB2)
You can use the SET SYSPARM
command to change subsystem parameters that can be updated online, while DB2 is started.
SPUFI (DSN)
The DSN subcommand SPUFI executes the SQL
processor using file input.
/SSR (IMS)
The IMS /SSR
command allows the IMS operator
to enter an external subsystem command.
-START ACCEL (DB2)
The DB2 command
START ACCEL notifies the DB2 subsystem
that it should use the specified accelerator servers.
START admtproc
The START admtproc command
starts the scheduler that is specified in the admtproc parameter .
/START (IMS)
The IMS /START
command (with the SUBSYS parameter) makes the connection between IMS and the specified external subsystem
available. Establishing the connection allows application programs
to access resources managed by the external subsystem.
-START DATABASE (DB2)
The START DATABASE command
makes the specified database available for use.
-START DB2 (DB2)
The DB2 command START DB2 initializes the DB2 subsystem. When the operation is complete, the
DB2 subsystem is active and available to
TSO applications and to other subsystems (for example, IMS and
CICS®).
-START DDF (DB2)
The DB2 command
START DDF starts the distributed data facility (DDF) if it is not
already started.
-START FUNCTION SPECIFIC (DB2)
The DB2 command
START FUNCTION SPECIFIC starts an external function that is stopped.
Built-in functions or user-defined functions that are sourced on another
function cannot be started with this command.
START irlmproc (z/OS IRLM)
The START irlmproc command
starts an IRLM component with a procedure that is defined by the installation.
Symbolic parameters in the procedure can be overridden on the START irlmproc command.
-START PROCEDURE (DB2)
The DB2 command
START PROCEDURE activates the definition of a stored procedure that
is stopped or refreshes one that is stored in the cache. You can qualify
stored procedure names with a schema name.
-START PROFILE (DB2)
The DB2 command START PROFILE loads or reloads the
profile table into a data structure in memory.
-START RLIMIT (DB2)
The DB2 command START RLIMIT starts the resource
limit facility (governor) and specifies a resource limit specification table for the facility to
use.
-START TRACE (DB2)
The DB2 command
START TRACE starts DB2 traces.
-STOP ACCEL (DB2)
The DB2 command
STOP ACCEL causes the DB2 subsystem
to stop using the specified accelerator servers.
STOP admtproc (z/OS )
The STOP admtproc command
stops the administrative task scheduler that is specified in the admtproc parameter.
/STOP (IMS)
The IMS /STOP
command (with the SUBSYS parameter) prevents application programs
from accessing external subsystem resources.
-STOP DATABASE (DB2)
The DB2 command
STOP DATABASE makes the specified objects unavailable for
applications and closes their data sets.
-STOP DB2 (DB2)
The DB2 command STOP DB2 stops the DB2 subsystem.
-STOP DDF (DB2)
The DB2 command
STOP DDF stops the distributed data facility (DDF) if it has already
been started; use this command to terminate the DDF interface to VTAM or TCP/IP.
-STOP FUNCTION SPECIFIC (DB2)
The DB2 command
STOP FUNCTION SPECIFIC prevents DB2 from
accepting SQL statements with invocations of the specified functions.
STOP irlmproc (z/OS IRLM)
The STOP irlmproc command
shuts IRLM down normally. The command is rejected if any active DB2 subsystems are currently identified
to IRLM.
-STOP PROCEDURE (DB2)
The DB2 command
STOP PROCEDURE prevents DB2 from
accepting SQL CALL statements for one or more stored procedures.
-STOP PROFILE (DB2)
The DB2 command STOP PROFILE is used to stop or disable the profile function.
-STOP RLIMIT (DB2)
The DB2 command STOP RLIMIT stops the resource
limit facility.
-STOP TRACE (DB2)
The DB2 command
STOP TRACE stops tracing.
-TERM UTILITY (DB2)
The DB2 command
TERM UTILITY terminates execution of a DB2 utility
job step and releases all resources associated with the step.
/TRACE (IMS)
The IMS /TRACE
command directs and controls the IMS capabilities
for tracing internal IMS events.
It also starts, stops, and defines the activity to be monitored by
the IMS Monitor.
TRACE CT (z/OS IRLM)
The z/OS command
TRACE CT starts, stops, or modifies a diagnostic trace for the internal
resource lock manager (IRLM) of DB2 .
Related information