Command Reference

Completing Tasks with SmartGuides

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

SmartGuide 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, click with the right mouse button on the database you want to back up and select Backup->Database using SmartGuide.
Configure Multisite Update SmartGuide Perform a multi-site update, a distributed transaction, or a two-phase commit. From the Control Center, click with the right mouse button on the Database icon and select Multisite Update.
Create Database Create a database, and perform some basic configuration tasks.
From the Control Center, click with the right mouse button on the Databases icon and select Create->Database using SmartGuide.
Create Table Select basic data types, and create a primary key for the table. From the Control Center, click with the right mouse button on the Tables icon and select Create->Table using SmartGuide.
Create Table Space Create a new table space. From the Control Center, click with the right mouse button on the Table spaces icon and select Create->Table space using SmartGuide.
Index Advise which indexes to create and drop for all your queries. From the Control Center, click with the right mouse button on the Index icon and select Create->Index using SmartGuide.
Performance Configuration Tune the performance of a database by updating configuration parameters to match your business requirements. From the Control Center, click with the right mouse button on the database you want to tune and select Configure using SmartGuide.
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, click with the right mouse button on the database you want to restore and select Restore->Database using SmartGuide.

SmartGuide	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, click with the right mouse button on the database you want to back up and select Backup->Database using SmartGuide.
Configure Multisite Update SmartGuide	Perform a multi-site update, a distributed transaction, or a two-phase commit.	From the Control Center, click with the right mouse button on the Database icon and select Multisite Update.
Create Database	Create a database, and perform some basic configuration tasks.	From the Control Center, click with the right mouse button on the Databases icon and select Create->Database using SmartGuide.
Create Table	Select basic data types, and create a primary key for the table.	From the Control Center, click with the right mouse button on the Tables icon and select Create->Table using SmartGuide.
Create Table Space	Create a new table space.	From the Control Center, click with the right mouse button on the Table spaces icon and select Create->Table space using SmartGuide.
Index	Advise which indexes to create and drop for all your queries.	From the Control Center, click with the right mouse button on the Index icon and select Create->Index using SmartGuide.
Performance Configuration	Tune the performance of a database by updating configuration parameters to match your business requirements.	From the Control Center, click with the right mouse button on the database you want to tune and select Configure using SmartGuide.
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, click with the right mouse button on the database you want to restore and select Restore->Database using SmartGuide.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]