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.
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.
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.
db2checkCOL - Check database for table accessibility in a prior fix pack command
Scans a database and determines whether any tables cannot
be accessed in a fix pack before DB2 Cancun
Release 10.5.0.4. If you want to revert to a previous fix pack after
applying DB2 Cancun
Release 10.5.0.4, run this command before you revert to the previous
fix pack.
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.
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
Filters and formats both single and rotating db2diag log
files. The db2diag command reads from rotating db2diag log
files if you set the diagsize database manager
configuration parameter. Otherwise, by default, the command 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.
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).
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.
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
Updates
an instance to a higher fix pack level within a release, converts
an instance other than a DB2 pureScale instance
to a DB2 pureScale instance,
or changes the topology of 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
The DB2MOVE command, when used in the EXPORT, IMPORT, or LOAD mode, facilitates the movement of large numbers of tables between DB2 databases located on workstations. When the DB2MOVE command is 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.
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. DB2setup is only available on Linux and UNIX operating systems. Instead of db2setup, the command for Windows operating systems is setup.
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.
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.
db2trc - Trace command
The db2trc command controls the trace facility of a DB2 instance or the DB2 Administration Server (DAS). When the db2trc command runs, 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.
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
.
db2updv105 - Update database to Version 10.5 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.5 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.5.
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.