Call Level Interface Guide and Reference

Appendix N. DB2 wizards

Wizards help you complete specific administration tasks by taking you through each task one step at a time. Wizards are available through the Control Center and the Client Configuration Assistant. The following table lists the wizards and describes their purpose:
Note:The Create Database, Create Index, Configure Multisite Update, and Performance Configuration wizards are available for the partitioned database environment.

Wizard Helps You to... How to Access...
Add Database Catalog a database on a client workstation. From the Client Configuration Assistant, click Add.
Back up Database Determine, create, and schedule a backup plan. From the Control Center, right-click on the database you want to back up and select Backup -> Database using Wizard.
Configure Multisite Update Perform a multi-site update, a distributed transaction, or a two-phase commit. From the Control Center, right-click on the Database icon and select Multisite Update.
Create Database Create a database, and perform some basic configuration tasks.

From the Control Center, right-click on the Databases icon and select Create -> Database using Wizard.

Create Table Select basic data types, and create a primary key for the table. From the Control Center, right-click on the Tables icon and select Create -> Table using Wizard.
Create Table Space Create a new table space. From the Control Center, right-click on the Table spaces icon and select Create -> Table space using Wizard.
Create Index Advise which indexes to create and drop for all your queries. From the Control Center, right-click on the Index icon and select Create -> Index using Wizard.
Performance Configuration Tune the performance of a database by updating configuration parameters to match your business requirements. From the Control Center, right-click on the database you want to tune and select Configure Performance using Wizard.

For the partitioned database environment, from the Database Partitions view, right-click on the first database partition you want to tune and select Configure Performance using Wizard.

Restore Database Recover a database after a failure. It helps you understand which backup to use, and which logs to replay. From the Control Center, right-click on the database you want to restore and select Restore -> Database using Wizard.


[ Top of Page | Previous Page | Next Page ]