DB2 Evaluation Guide for Linux and Windows
Published 25 March 2003, updated 09 December 2003
Authors: Whei-Jen Chen
DB2 Universal Database provides a rich set of graphical tools that make the DBA’s database management job easier and that improve the productivity of the developer in application development. There are different methods to invoke these GUI tools. All the GUI tools or wizards can be navigated through Control Center. These tools also can be launched from each other. It is handy to invoke the GUI tools or wizards directly from the command line.
Here we introduce those GUI tools that can be invoked directly through the operating system command line interface.
Launching DB2 UDB GUIs via commands
Control Center is where you'll find the DB2 graphical tools on the whole. From the Control Center, you can perform administrative tasks, monitor systems, and develop applications. You can launch various DB2 GUI tools directly from the Control Center.
Command Center allows you to write and execute DB2 commands and SQL statements interactively. It also lets you write scripts containing DB2 commands and/or SQL statements and run them immediately or schedule for later execution.
Task Center is a robust tool to manage the scheduling and execution of DB2 Command and OS scripts. Upon completion of a job, the Task Center can create notifications to be sent to your e-mail or pager.
Journal keeps a running history of all interactive command and script executions submitted using the DB2 GUI tools.
Health Center monitoring tool can be used to monitor the state and utilization of many parts of the database manager, the databases, and user agents.
Memory Visualizer can be used to monitor the memory allocation of a DB2 instance.
Development Center is built upon DB2’s leadership in open standards. The Development Center has features and functions that make it easier for developers to build and deploy applications for either Java or Microsoft environments. The Stored Procedure Builder in Version 7 has been included in the Development Center.
Configure Assistance is previously known as the Client Configuration Assistant. The new Configuration Assistant has been tightly integrated with the Control Center and has been enhanced with many new features.
Replication Center is a new user interface tool that you can use to set up and administer your replication environment. The Replication Center supports administration for DB2-to-DB2 replication environments and administration for replication between DB2 and non-DB2 relational databases.
Information Center provides quick access to DB2 product information and is available on all operating systems for which the DB2 administration tools are available.
The table below lists the specific commands used to invoke these tools using a command line interface. In the Windows environment, once the DB2 system is started, you can invoke the tools by entering the command in the Windows command prompt. In Linux and UNIX environments, you enter the command via an X-window once the Database manager is started.
|DB2 GUI tool||Command|
|Command Widow (command line processor)||db2cmd|
Note to Linux users: To invoke the DB2 command line processor or issue DB2 command directly from the Linux command prompt, you need to run the db2profile in the profile of the login user ID. You need to include the following line in your login profile:
Where, INSTHOME is the DB2 instance home directory.
This material has not been submitted to any formal IBM test and is published AS IS. It has not been the subject of rigorous review. IBM assumes no responsibility for its accuracy or completeness. The use of this information or the implementation of any of these techniques is a client responsibility and depends upon the client's ability to evaluate and integrate them into the client's operational environment.
Follow IBM Redbooks
Follow IBM Redbooks