From the Administration Tools menu, by selecting Configuration Menu > Run Database Designer. You must be a DBADMIN user to run Database Designer from the Administration Tools.
The following table shows what Database Designer capabilities are available in each tool:
Database Designer Capability
Management Console
Running Database Designer Programmatically
Administrative Tools
Create design
Yes
Yes
Yes
Design name length (# of characters)
16
32
16
Build design (create design and deployment scripts)
Yes
Yes
Yes
Create backup script
Yes
Set design type (comprehensive or incremental)
Yes
Yes
Yes
Set optimization objective
Yes
Yes
Yes
Add design tables
Yes
Yes
Yes
Add design queries file
Yes
Yes
Yes
Add single design query
Yes
Use query repository
Yes
Yes
Set K-safety
Yes
Yes
Yes
Analyze statistics
Yes
Yes
Yes
Require all unsegmented projections
Yes
Yes
View event history
Yes
Yes
Set correlation analysis mode (Default = 0)
Yes
1 - Using administration tools to create a design
To use the Administration Tools interface to create an optimized design for your database, you must be a DBADMIN user.
To use the Administration Tools interface to create an optimized design for your database, you must be a DBADMIN user. Follow these steps:
Log in as the dbadmin user and start Administration Tools.
From the main menu, start the database for which you want to create a design. The database must be running before you can create a design for it.
On the main menu, select Configuration Menu and click OK.
On the Configuration Menu, select Run Database Designer and click OK.
On the Select a database to design window, enter the name of the database for which you are creating a design and click OK.
On the Enter the directory for Database Designer output window, enter the full path to the directory to contain the design script, deployment script, backup script, and log files, and click OK.
The Select schema(s) to add to query search path window lists all the schemas in the database that you selected. Select the schemas that contain representative data that you want Database Designer to consider when creating the design and click OK.
The final window summarizes the choices you have made and offers you two choices:
Proceed with building the design, and deploying it if you specified to deploy it immediately. If you did not specify to deploy, you can review the design and deployment scripts and deploy them manually, as described in Deploying designs manually.
Cancel the design and go back to change some of the parameters as needed.
Creating a design can take a long time.To cancel a running design from the Administration Tools window, enter Ctrl+C.