dascrt - Create a DB2 administration server command
The DB2 Administration Server provides support services for remote
administration and DB2 administration
tools such as the Replication Center. 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.
db2admin - DB2 administration server command
This utility is used to manage the DB2 Administration Server (DAS). If no parameters
are specified, and the DAS exists, this command returns the name of
the DAS.
db2adutl - Managing DB2 objects within TSM command
Allows users to query, extract, verify, and delete backup
images, logs, and load copy images that are saved using Tivoli® Storage Manager (TSM). Also allows
users 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.
db2batch - Benchmark tool command
Reads SQL statements and XQuery statements from either
a flat file or standard input, dynamically prepares and describes
the statements, and returns an answer set.
db2bfd - Bind file description tool command
Displays the contents of a bind file. This utility,
which can be used to examine and to verify the SQL statements within
a bind file, as well as to display the precompile options used to
create the bind file, might be helpful in problem determination related
to an application's bind file.
db2cat - System catalog analysis command
Analyzes the contents of packed descriptors.
Given a database name and other qualifying information, this command
will query the system catalogs for information and format the results.
db2cfexp - Connectivity configuration export tool command
Exports connectivity configuration
information to an export profile, which can later be imported at another DB2 database workstation instance
of similar instance type (that is, client instance to client instance).
db2cfimp - Connectivity configuration import tool command
Imports connectivity configuration information from a file
known as a configuration profile. It is a non-interactive utility
that will attempt to import all the information found in the configuration
profile.
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.
db2ckbkp - Check backup command
This utility can be used to test the integrity of a backup
image and to determine whether or not the image can be restored. It
can also be used to display the metadata stored in the backup header.
db2cklog - Check archive log file validity 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.
db2ckrst - Check incremental restore image sequence command
Queries the database history and generates a list of timestamps
for the backup images that are required for an incremental restore.
A simplified restore syntax for a manual incremental restore is also
generated.
db2cmd - Open DB2 command window command
Opens the CLP-enabled DB2 window, and initializes the DB2 command line environment. Issuing this command is equivalent
to clicking the DB2 Command Window icon.
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.
db2dclgn - Declaration generator command
Generates declarations for a specified database table,
eliminating the need to look up those declarations in the documentation.
The generated declarations can be modified as necessary. The supported
host languages are C/C++, COBOL, JAVA, and FORTRAN.
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.
db2drdat - DRDA trace command
Allows the user to capture the DRDA® data stream exchanged between
a DRDA Application Requestor
(AR) and the DB2 DRDA Application Server (AS).
db2empfa - Enable multi-page file allocation command
Enables the use of multi-page file allocation for a database.
With multi-page file allocation enabled for SMS table spaces, disk
space is allocated one extent at a time rather than one page at a
time.
db2exmig - Migrate explain tables command
Migrates explain tables. The explain tables migration tool
renames the existing explain tables, creates a new set of tables using
the EXPLAIN.DDL, and copies the contents of the
existing explain tables to the new tables. Finally, it drops the existing
explain tables.
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.
db2flsn - Find log sequence number command
The db2flsn command
returns the name of the file in a log stream that contains the log
record identified by a specified log sequence number (LSN) or log
record identifier (LRI).
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.
db2fs - First Steps command
Launches the First Steps interface, which contains links
to the functions that you need to begin learning about and using the DB2 products.
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.
db2gov - DB2 governor command
Monitors and changes the behavior of applications that
run against a database. By default, a daemon is started on every database
partition, but the front-end utility can be used to start a single
daemon at a specific database partition.
db2govlg - DB2 governor log query command
Extracts records of specified type from the governor log
files. The DB2 governor monitors
and changes the behavior of applications that run against a database.
db2gpmap - Get distribution map command
If a database is already set up and database partition
groups defined for it, db2gpmap gets the distribution
map for the database table or the database partition group from the
catalog partitioned database server.
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. This command is not supported for DB2 pureScale instances.
db2iclus - Microsoft Cluster Server command
Allows users to add, drop, migrate and unmigrate instances
and DB2 administration servers
(DAS) in a Microsoft Cluster
Server (MSCS) environment. This command is only available on Windows operating systems.
db2icrt - Create instance command
Create a DB2 instance,
including a DB2 pureScale instance.
This command can also be used to create an initial DB2member and cluster caching facility as
part of the creation of the DB2 pureScale instance.
db2ida - Stop or restart the SAS embedded process command
Stops or restarts the SAS embedded process (SAS EP) without
recycling the DB2 instance. This command is useful when you perform
maintenance operations, such as upgrading the SAS EP library or correcting
an erroneous library path.
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.
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 rollforward pending state, or used as a backup
image to restore the primary database.
db2iupdt - Update instances command
The db2iupdt command
can be used to update an instance to a higher level within a release,
update an instance other than a DB2 pureScale instance
to a DB2 pureScale instance,
or scale a DB2 pureScale instance.
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.
db2ldcfg - Configure LDAP environment command
Configures the Lightweight Directory Access
Protocol (LDAP) user distinguished name (DN) and password for the
current logon user in an LDAP environment using an IBM LDAP client.
db2level - Show DB2 service level command
Shows the current Version and Service Level of the installed DB2 product. Output from this command
goes to the console by default.
db2licm - License management tool command
Performs
basic license functions such as adding, removing, listing, or modifying
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.
db2move - Database movement tool command
This tool, when used in the EXPORT, IMPORT,
or LOAD mode, facilitates the movement of large numbers
of tables between DB2 databases
located on workstations. When used in the COPY mode,
this tool facilitates the duplication of a schema.
db2mqlsn - MQListener command
Invokes the asynchronous MQListener to monitor a set of WebSphere® MQ message queues,
passing messages that arrive on them to configured DB2 stored procedures. It can also perform associated
administrative and configuration tasks.
db2mscs - Set up Windows failover utility command
Creates the infrastructure for DB2 failover support on Windows using Microsoft Cluster Server (MSCS). This utility
can be used to enable failover in both single-partition and partitioned
database environments.
db2nchg - Change database partition server configuration command
Modifies database partition server configuration. This
includes moving the database partition server from one machine to
another; changing the TCP/IP host name of the machine; and selecting
a different logical port number or a different network name for the
database partition server.
db2ndrop - Drop database partition server from an instance command
Drops a database partition server from an instance that
has no databases. If a database partition server is dropped, its database
partition number can be reused for a new database partition server.
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.
db2perfi - Performance counters registration utility command
Adds the DB2 performance
counters to the Windows operating
system. This must be done to make DB2 and DB2 Connect™ performance information accessible to the Windows performance monitor.
db2rc - Start Replication Center command
Starts the Replication Center. The Replication Center is
a graphical interface that you can use to set up and administer all
replication programs for Q replication and SQL replication. This command
is available only on Linux and Windows operating systems.
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 installations 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.
db2rfpen - Reset rollforward pending state command
Puts a database in rollforward pending state. If you are
using high availability disaster recovery (HADR), the database is
reset to a standard database.
db2rspgn - Response file generator command
Generates response files and instance configuration profiles
for the current copy. These generated files are used to re-create
an exact setup on other machines.
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.
db2set - DB2 profile registry command
Displays,
sets, or deletes the values of DB2profile
variables. The db2set command is an external environment
registry command that supports local and remote administration through
the DB2 administration server
(DAS).
db2setup - Install DB2 database products 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 for Linux and Solaris command
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 database manager on the target member or all
members. In a DB2 pureScale environment, it may also be used to start the cluster caching facility (CF).
db2stop - Stop DB2 command
Stops the database manager on the target member or all
members. In a DB2 pureScale environment, it may also be used to stop the cluster caching facility (CF).
db2sync - Start DB2 synchronizer command
Facilitates the initial configuration of a satellite as
well as changes to the configuration. This command can also be used
to start, stop and monitor the progress of a synchronization session
and to upload a satellite's configuration information (for example,
communications parameters) to its control server.
db2systray - Start DB2 system tray command
Starts
the DB2 system tray tool. It
is a Windows operating system
notify icon which monitors the status of a DB2 database service on Windows operating systems. db2systray provides
a visual indication of when the service is started and stopped, as
well as the ability to start and stop the service.
db2tapemgr - Manage log files on tape command
Allows the storage and retrieval of DB2 log files to and from tape. The db2tapemgr command reads the logarchmeth1 value and copies these log files from disk to the specified tape
device, then it updates the recovery history file with the new location
of the copied log files.
db2tbst - Get table space state command
Accepts a hexadecimal table space state value, and returns
the state. The state value is part of the output from LIST
TABLESPACES or the MON_GET_TABLESPACE table function.
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 realtime 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).
The trace facility records information about operations and formats
this information into readable form.
db2trcoff - Trace OFF options for db2trc command
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 - Trace ON options for db2trc command
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 command
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
.
db2updv10 - Update database to Version 10.1 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 Version
10.1 Fix Pack 1 or later on Linux, UNIX or Windows.
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/V10.1.
This command applies only to the Linux
operating systems.
enable_MQFunctions - Enable WebSphere MQ functions command
Enables DB2WebSphere MQ functions for
the specified database and validates that the DB2WebSphere MQ
functions can be executed properly. The command fails if WebSphere MQ and WebSphere MQ AMI have not been installed
and configured.
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.
setup - Install DB2 database products command
Installs DB2 database
products. This command is only available on Windows operating systems. The command for UNIX operating systems is db2setup.