8.3 Tools and wizards

 < Day Day Up > 



8.3 Tools and wizards

DB2 UDB ships with many tools and wizards that help the database administrators to maintain and administrate the database. These wizards and tools are also used to generate the scripts for database administration. Examples of such wizards are Backup Wizard, Create Database Wizard, Create Tablespace Wizard, Design Advisor, Load Wizard, etc. These wizards and tools can be accessed from DB2 Control Center. Figure 8-1 shows how Backup Wizard is used to generate the backup script. The generated script can be exported to output file using Export Scripts option.

click to expand
Figure 8-1: Backup Wizard

The scripts or job generated by the wizards can be scheduled to run and maintained in the Task Center. Figure 8-2 shows the Task Center. Task Center is also used to notify administrators on the status of a completed job. For more information on these wizards and tools, refer Guide to GUI Tools for Administration and Development, SC09-4851-00.

click to expand
Figure 8-2: Task Center



 < Day Day Up > 



Oracle to DB2 UDB Conversion Guide2003
Oracle to DB2 UDB Conversion Guide2003
ISBN: N/A
EAN: N/A
Year: 2004
Pages: 132

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net