[DB2 learning records] 2. DB2 tools

DB2 tools
Two categories:
Control Center (CC) is mainly used to manage DB2 servers.
Configuration Assistant (CA) is used to Set Client/Server Communications and maintain registry variables.

Six basic features should be found in any DB2 tool:
Wizards
Generate DDL
Show SQL/show command
Show related
Filter
Help

Two major Advisor:
Configuration advisor, which provides parameter suggestions when creating a database.
Design advisor can be combined with self tuning Memory Manager (stmm) to diagnose optimization.

Data is transferred to a new database object. You can use the traditional load or import utility or the db2move command.
Db2move queries the system catalog tables of a specific database, compiles a list of all user tables, and then exports these tables in PC/ixf format.

DB2 command line processor (DB2 CLP) is available in all DB2 products,
It can be used to run DB2 commands, operating system commands, or SQL statements.
DB2 command windows (DB2 CW)
DB2 CW is built in the local CLP of the operating system for all operating systems except Windows.
In Windows, enter the db2cmd command in the command prompt to start DB2 CW before running the DB2 command.

The command line option of DB2 CLP affects the behavior of input statements and commands, including the following:
> DB2 LIST Command Options
Command Line processor option settings
Backend process wait time (seconds) (db2bqtime) = 1
No. of retries to connect to backend (db2bqtry) = 60
Request queue wait time (seconds) (db2rqtime) = 5
Input Queue wait time (seconds) (db2iqtime) = 5
Command Options (db2options) =
Option description current setting
-------------------------------------------------------------
-A display sqlca off
-C Auto-commit on
-D retrieve and display XML declarations off
-E display sqlcode/sqlstate off
-F Read from input file off
-I display XML data with indentation off
-L log commands in history file off
-M display the number of rows affected off
-N remove new line character off
-O display output on
-P display interactive input prompt on
-Q preserve whitespaces & linefeeds off
-R save output to report file off
-S stop execution on command error off
-T set statement termination character off
-V echo current command off
-W display fetch/select warning messages on
-X suppress printing of column headings off
-Z save all output to output file off

-Indicates on,-or + indicates off, for example:
DB2-C command or statement... open auto-commit
DB2-C-command or statement... off auto-commit
DB2 + C command or statement... off auto-commit

The continued line character is (/)
If special characters exist, double quotation marks are required.
In DB2 CW,
DB2 "select * from staff where dept> 10"
DB2 select * from staff where dept> 10
Of course, this is not required in DB2 CLP.

Start configuration assistant in db2ca
Operate on existing databases, add new databases, bind applications, Set Client configurations and registry parameters (as shown above), and import and export configuration files

Start Control Center in db2cc. You can also select other tools, which are usually not listed.
DB2 satellite Administration Center
Use satellite Administration Center (DB2 SAC) to set and manage DB2 server groups that perform the same business functions.
These servers are called Satellites. They all run the same application and use the same DB2 configuration (database definition) to support this application.
DB2 sac can be used to allow several DB2 data servers to use one master server to synchronize and maintain their configurations and data.

DB2 HC starts the DB2 health center for health check.
DB2 journal displays historical information about tasks, database activities and operations, control center operations, messages, health status alarms, and so on.

Snapshot and event monitor, monitoring system.
DB2 governor can monitor the behavior of applications running on databases
DB2 developer workbench DB2 9 an integrated development environment (IDE) (DB2 DWB ).
Memory visualizer
The high-level memory components monitored by this tool include the memory shared by the database management program, the global memory of the database, the global memory of the application, the memory shared by the proxy/application, and the private memory of the proxy. Each high-level component is divided into low-level components, which determine how the memory is allocated and released.
Db2indbt starts in-doubt transaction monitor to help DBAs process global transactions in the in-doubt state.
Activity monitor can help monitor application performance, application concurrency, resource consumption, and SQL statement usage, and should be helpful for lock.