db2dart
The db2dart command can be used to verify the architectural correctness of databases and the objects within them. It can also be used to display the contents of database control files in order to extract data from tables that might otherwise be inaccessible.

db2diag
The db2diag tool serves to filter and format the volume of information available in the db2diag.log.

db2level
The db2level command will help you determine the version and service level (build level and fix pack number) of your DB2 instance.

db2look
1, Using db2look to mimic the tables in a database
To extract the DDL for the tables in the database, use the -e option.
db2look -d sample -e > sample.ddl

2, Mimicking statistics for tables
The option for creating the statistic statements is -m.
db2look -d sample -m > stats.dml

3,Extracting configuration parameters and environment variables
As with the statistics, db2look can be used to generate the necessary configuration update and set statements. This is done using the -f option
db2look -d sample -f>config.txt

db2ls (Linux and UNIX)
The db2ls command can be used to list:
4.1 where DB2 products are installed on your system and list the DB2 product level
4.2 all or specific DB2 products and features in a particular installation path

db2pd
Scenario 1: Catching a lock timeout using the db2pdcfg -catch option
db2pdcfg -catch locktimeout count=1

Scenario 2: Mapping an application to a dynamic SQL statement
db2pd -app -dyn

Scenario 3: Monitoring memory usage.
db2pd -memblock

Scenario 4: Determine which application is using up your table space.
db2pd -tcbstats
db2pd -tablespaces

Scenario 5: Monitoring recovery.
db2pd -recovery

Scenario 6: Determining the amount of resources a transaction is using
db2pd -transactions

Scenario 7: Monitoring log usage.
db2pd -logs

Scenario 8: Viewing the sysplex list
db2pd -sysplex

Scenario 9: Generating stack traces
db2pd -stack all


db2support
The db2support utility is designed to automatically collect all DB2 and system diagnostic information available.

db2trc
The db2trc command controls the trace facility provided with DB2. The trace facility records information about operations and formats this information into a readable form.

Diagnostic tools (Linux and UNIX)

Troubleshooting commands (AIX)
errpt   The errpt command reports system errors such as hardware errors and network failures.
lsps   The lsps -a command monitors and displays how paging space is being used.
lsattr  This command displays various operating system parameters.
xmperf   This command starts a graphical monitor that collects and displays system-related performance data
spmon  To view the status of all nodes, use one of the following commands from the control workstation
                spmon -d for ASCII output
                spmon -g for a graphical user interface

Troubleshooting commands (Linux and UNIX)
df
truss   This command is useful for tracing system calls in one or more processes.
pstack  Displays stack traceback information

Performance Monitoring Tools
vmstat
iostat
netstat