DB2 Universal Database Version 6 offers new tools and tool support to help you administer your DB2 systems and create new applications, including:
To simplify the task of re-installing or duplicating an existing DB2 system, DB2 Universal Database Version 6 provides the Response File Generator utility. The Response File Generator captures the values of the DB2 registry; database manager and administration configuration parameters; and the products and components installed on an existing system. It then creates a response file that you can use to duplicate the DB2 install on another system.
To invoke the Response File Generator, use the db2rspgn command. For more information on the Response File Generator, refer to the Installation and Configuration Supplement .
The Performance Monitor helps you administer DB2 Universal Database and DB2 Universal Database for OS/390 servers by monitoring the performance of DB2 objects such as instances, databases, tables, table spaces, and connections. The Performance Monitor alerts you if performance falls outside your defined thresholds. You can also use the Performance Monitor to observe the performance of your system at a point in time or capture performance data over a period of time.
Use the information from the Performance Monitor to:
For more information on the Performance Monitor, refer to the Administration Guide, Design and Implementation .
DB2 Universal Database Version 6 introduces the Index Advisor utility, which helps you improve the performance of your database by suggesting and creating an optimal set of indexes. Use the Index Advisor to help you:
You can invoke the Index Advisor using either:
For more information on the Index Advisor, refer to the Administration Guide, Performance .
As an addition to the Control Center, the License Center provides a convenient means for you to perform licensing tasks. Using the License Center, you can:
DB2 Universal Database Version 6 also includes a command line version of the tool, db2licm, that enables you to perform basic license management actions including adding, removing and modifying a license.
For more information on the License Center, refer to the Quick Beginnings book for your platform. For more information on the db2licm command, refer to the Command Reference .
You can display the SQL statements used to define database objects with the Generate SQL Control Center command. You can display the SQL used to define all of the objects of a single database, including tables, indexes, views, triggers, and aliases. You can also display the SQL used to define any one of these database objects.
To display the SQL that defines a single database object, perform the following steps:
With DB2 Universal Database Version 6, you can easily convert Control Center actions into scripts using the Show SQL... and the Show Command... commands. To display the SQL statements or DB2 commands the Control Center uses to carry out a given database operation, perform the following steps:
You can then convert the displayed SQL statements and DB2 commands into a regular DB2 script.
Stored Procedure Builder (SPB) is a graphical application that supports the rapid development of DB2 stored procedures. Using SPB, you can perform the following tasks:
SPB provides a single development environment that supports the entire DB2 family ranging from the workstation to System/390. You can launch SPB as a separate application from the DB2 Universal Database program group, or you can launch SPB from any of the following development applications:
For more information on SPB, refer to the Stored Procedure Builder online help.
The Declaration Generator (db2dclgn) creates embedded SQL host variable declarations for a given table in a database. The Declaration Generator supports the C/C++, Java, COBOL, or FORTRAN languages. For more information on the Declaration Generator , refer to the Command Reference .