dascrt - Create a DB2 administration server command
The DB2® administration
server (DAS) provides support services for DB2 tools such as the Control Center and the
Configuration Assistant. If a system does not have a DAS, you can
use this command to manually generate it.
dasmigr - Migrate the DB2 administration server command
Migrates the DB2 Administration
Server (DAS) on the system from a previous version of DB2 database system (supported for migration
to the current version of DB2 database
system) to the current version of DB2 database
system at the DB2 database level
related to the path where the dasmigr is issued.
dasupdt - Update DAS command
On Linux and UNIX operating systems, updates
the DB2 Administration Server
(DAS) if the related DB2 database
system installation is updated. On Linux, UNIX, and Windows operating systems, you can also use
this utility to move the DAS from one installation location to another
if both are at the same version of DB2 database
system.
db2adutl - Managing DB2 objects within TSM command
Allows you to query, extract, verify,
and delete backup images, logs, and load copy images that are saved
using Tivoli® Storage Manager
(TSM). You can also use db2adutl to upload backup
images and archived log files currently stored on disk to TSM. As
well, you can use db2adutl to grant and revoke
access to objects on a TSM server.
db2advis - DB2 design advisor command
The DB2 Design Advisor
advises users on the creation of materialized query tables (MQTs)
and indexes, the repartitioning of tables, the conversion to multidimensional
clustering (MDC) tables, and the deletion of unused objects.
db2audit - Audit facility administrator tool command
DB2 database systems
provide an audit facility to assist in the detection of unknown or
unanticipated access to data. The DB2 audit
facility generates and permits the maintenance of an audit trail for
a series of predefined database events.
db2chglibpath - Modify the embedded runtime library search path command
Modifies the embedded runtime library search path value
within an executable or shared library file. It can be used to replace
the embedded runtime library search path value with a new user-specified
value when the existing value is no longer valid.
db2chgpath - Change embedded runtime path command
Used by the DB2 database
installer on Linux and UNIX operating systems to update
the embedded runtime path in the related DB2 database
library and executable files. The command can be reissued under the
direction of IBM® DB2 database support if there were errors related
to the command during the DB2 database
installation.
db2cklog - Check archive log files command
You use the db2cklog command to check
the validity of archive log files in order to determine whether or
not the log files can be used during rollforward recovery of a database
or table space. Either a single archive log file or a range of archive
log files can be checked.
db2cptsa - Install or update DB2 HA scripts command
Installs or updates the DB2 high
availability (HA) scripts in /usr/sbin/rsct/sapolicies/db2 on UNIX and Linux operating systems. You need these DB2 HA scripts to use IBM Tivoli System
Automation for Multiplatforms (SA MP) with
the DB2 High Availability
Feature.
db2diag - db2diag logs analysis tool command
This utility is a tool to filter and format
both single and rotating db2diag log files. The db2diag tool
reads from rotating db2diag log files if the diagsize database
manager configuration parameter is set. Otherwise, by default, it
reads from the default db2diag.log file.
db2expln - SQL and XQuery Explain command
The db2expln tool describes the access
plan selected for SQL and XQuery statements. Use the tool to obtain
a quick explanation of the chosen access plan when explain data was
not captured. For static SQL and XQuery statements, db2expln examines
the packages stored in the system catalog tables. For dynamic SQL
and XQuery statements, db2expln examines the query
cache sections.
db2extsec - Set permissions for DB2 objects command
Sets the permissions for DB2 database
objects (for example, files, directories, network shares, registry
keys and services) on updated DB2 database
system installations.
db2fmcu - DB2 fault monitor controller command
DB2 Fault Monitor
is the DB2 database facility
that automatically starts an instance after a crash. It can also auto
restart an instance on machine reboot. You can configure the DB2 fault monitor on Linux and UNIX operating
systems using the DB2 fault
monitor controller command. The command must be run as root because
it accesses the system's inittab file.
db2fodc - DB2 first occurrence data collection command
The db2fodc utility captures symptom-based
data about the DB2 instance
to help in problem determination situations. It is intended to collect
information about potential hangs, severe performance issues, and
various types of errors.
db2fopt - Specify query optimizer parameters command
The db2fopt command specifies parameters
for use by the query optimizer. This command can be used when setting
up a test system which has less physical resources than the production
system.
db2gcf - Control DB2 instance command
Starts, stops, or monitors a DB2 instance,
usually from an automated script, such as in an HA (high availability)
cluster.
db2iauto - Autostart instance command
Enables or disables the autostart of an instance after
each system restart. This command is available on Linux and UNIX operating
systems only.
db2ida - Stop or restart the SAS embedded process command
Stops or restarts the SAS embedded process (SAS EP) without
recycling the DB2 instance.
This is useful when maintenance operations, such as upgrading the
SAS EP library or correcting an erroneous library path, are to be
performed.
db2IdentifyType1 - Type-1 index identification tool command
Identifies
and generates into an output file the appropriate REORG INDEXES
ALL commands with the ALLOW WRITE ACCESS and CONVERT clauses
which you can use to convert type-1 indexes to type-2 indexes for
a specified database. This command only examines user-defined indexes
and is intended to be run on databases that have not yet been upgraded
to Version 9.7.
db2ilist - List instances command
Lists all the instances that are created using the db2icrt command
from the same DB2 copy location
that you are running the db2ilist command.
db2inidb - Initialize a mirrored database command
Initializes a mirrored database in a split mirror environment.
The mirrored database can be initialized as a clone of the primary
database, placed in roll forward pending state, or used as a backup
image to restore the primary database.
db2iupdt - Update instances command
Updates an instance to run on a DB2 copy that has a new DB2 database product or feature installed, to
run on a DB2 copy of the same
version as the DB2 copy associated
with the instance, or to upgrade the instance type to a higher level
instance type.
db2iupgrade - Upgrade instance command
Upgrades an instance to a DB2 copy
of the current release from a DB2 copy
of a previous release. The DB2 copy
from where you are running the db2iupgrade command
must support instance upgrade from the DB2 copy
that you want to upgrade.
db2licm - License management tool command
Performs basic license functions in the
absence of the Control Center. Adds, removes, lists, and modifies
licenses and policies installed on the local system.
db2look - DB2 statistics and DDL extraction tool command
Extracts the Data Definition Language (DDL)
statements that are required to reproduce the database objects of
a production database on a test database.
The db2look command generates the DDL statements
by object type. Note
that this command ignores all objects under SYSTOOLS schema except
user-defined functions and stored procedures.
db2nrupgrade - Upgrade non-root instance command
Upgrades a non-root instance from a previous version of
the DB2 database system to the
current version of the DB2 copy
from where you are running the db2nrupgrade command.
db2osconf - Utility for kernel parameter values command
Makes recommendations for kernel parameter
values based on the size of a system. The recommended values are
high enough for a given system that they can accommodate most reasonable
workloads. This command is currently available only for DB2 databases on the Solaris operating system
and for 64-bit DB2 instances
on HP-UX.
db2relocatedb - Relocate database command
This command renames a database, or relocates
a database or part of a database (for example, the container and
the log directory) as specified in the configuration file provided
by the user. This tool makes the necessary changes to the DB2 instance and database support
files.
db2rfe - Enable root features for non-root install command
Enables the supported root features, in non-root installations
of DB2 database systems, according
to the configuration file. The DB2 non-root
instance needs to be stopped before the db2rfe command
is executed.
db2schex - Active Directory schema extension command
Extends the Microsoft Active
Directory schema to include the DB2 object
classes and attribute definitions that you require to use the Lightweight
Directory Access Protocol (LDAP) directory server feature with Windows Server 2003 and later.
db2setup - Install DB2 command
Installs DB2 database
products. This command is only available on Linux and UNIX operating
systems. The command for Windows operating
systems is setup.
db2snapcore - DB2 snapcore command for Linux and Solaris
On Linux and Solaris
operating systems, this command mimics the functionality provided
by the snapcore command on AIX® operating
systems. The command extracts the shared objects list section from
the EDU trap file, combines the section together with a core file
and compresses the output into an archive which can be sent to IBM Support for analysis.
db2start - Start DB2 command
Starts the current database
manager instance
background processes on a single database partition or on all the
database partitions defined in a partitioned database environment.
db2top - DB2 monitoring tool command
The db2top command
provides a unified, single-system view of a multi-partition database
or single-partition database on the AIX, Linux, HP-UX, and Solaris operating
systems. Quickly identifies global problems, or specific database
partition problems in the system. By combining snapshot information
from each database partition, a dynamic real-time view of a running DB2 system is provided.
db2trc - Trace command db2trc controls the trace facility of
a DB2 instance or the DB2 Administration Server (DAS).
db2trcoff - Off trace options for db2trc
The db2trcoff command issues the db2trc command
with the off option. This command makes it easy
to generate the dump, flow, and format files by you having to execute
less commands than if you were to use the db2trc command.
db2trcon - On trace options for db2trc
The db2trcon command issues the db2trc command
with the on option. This command has several
options which helps with using the db2trc command.
The db2trcon command can issue the db2trc command
for a period of time and it can also issue the db2trc command
to be turned on for the top CPU consuming EDUs.
db2updserv - Show product updates
Shows the product updates and enhancements available for DB2 database products. On Windows, the output from this
command goes to a Web page, on UNIX,
it goes to a Java™ application
.
db2updv97 - Update database to Version 9.7 fix pack command
Updates the database system catalog to support the fix
pack you have installed. This command can be used only on a database
running DB2 for Linux, UNIX and Windows Version 9.7 Fix Pack
1 or later.
db2val - DB2 copy validation tool command
Verifies the basic functions of a DB2 copy by checking the state of installation
files, instance setup, and local database connections.
db2xdbmig - Migrate XSR objects command
Migrates all XML schema repository (XSR) objects that are
enabled for decomposition to the current version and service level
of the DB2 copy where you are
running the command.
doce_install - Install DB2 Information Center command
Installs the DB2 Information
Center.
If no path is specified, the DB2 Information
Center is
installed by default in /opt/ibm/db2ic/V9.7.
This command applies only to the Linux
operating systems.
installFixPack - Update installed DB2 database products command
Update the installed DB2 database
products in a given location, on all UNIX and Linux platforms, to the same level
as the image. If there are multi-copy DB2 database
products installed, the installFixPack command
updates one copy at a time according to the path specified.