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. |