You are strongly recommended to use
the DB2 Control Center (DB2CC) utility for administration tasks. To
avoid inconsistencies, you are advised not to use the DB2 command
line interface for administration commands unless otherwise
We make these recommendations for the following reasons:
The DB2 Control Center has been extended to include some
specific R/3 functions (log file management and password
The DB2 Control Center disables some administration functions
to prevent the administrator from harming the R/3 environment.
The command line processor is not integrated into the DB2
administration infrastructure. It uses different interfaces and,
therefore, does not meet SAP R/3 database administration
The following figure gives a general overview of the
architecture of the enhancements for R/3 administration.
the DB2 Control Center Enhancements for R/3
The following text gives an example
of the operation of the DB2CC enhancements for R/3. The letters in
parentheses refer to objects in the graphic shown above.
In the DB2CC you click with the right mouse button on the
object representing your R/3 database instance db2<sid> . The DB2CC fetches the available actions from the
The available actions are returned. These include
SAP-DB2admin: Change Password. Select this action. Enter the
password for the db2<sid> user (that
is, the password on the DB2 server host) and confirm it by
Complete the Change Password dialog and confirm it by selecting
Ok. The SAPACT.DLL
(C) is called. This interfaces with the
DB2admin Work & Feedback Manager (DWFM) (D).
DWFM actually initiates the administration task using a stored
procedure called SDDB6DAS
(E). This is the DB2admin server. The
server changes the password (by calling an executable
Status information (either success or failure) is returned to
the DB2CC. All activity is logged in the ADM<SID> database
(F) and is mirrored to the R/3 <SID> (G) database on a
regular basis. In addition, tables essential for the R/3 Computing
Center Management System (CCMS) are updated.