Generate DDL -- Fields and controls

" " Schema
" " Database objects
" " Tablespaces, nodegroups, and bufferpools
" " Authorization statements
" " Database statistics
" " Update statistics
" " Include COMMIT statements after every table
" " Generate
" " Schedule
" " Show SQL
" " Cancel



" " Schema

Select this check box to specify the name of a schema. All objects contained in that schema will be generated. To specify a different schema name, click on the down arrow to display a list of existing schemas and select one. Selecting <All Schemas> from the list means DDL will be generated for all schemas in the database. Selecting NULLID from the list means DDL will be generated for schemas with the name NULLID in the database.

This check box is only available when you Generate DDL for a database object.

" " Database objects

Select this check box to generate DDL statements for database objects such as databases, tables, indexes, views, triggers, aliases and schemas.

" " Tablespaces, nodegroups, and bufferpools

Select this check box to generate DDL statements for node groups, buffer pools, and table spaces.

" " Authorization statements

Select this check box to generate SQL authorization (GRANT) statements.

" " Database statistics

Select this check box to generate SQL statements for table statistics in the database. When you select this box, the Update statistics box is enabled.

When you recreate a database's objects and it's statistics in another database, the DB2 Optimizer will treat this database as if it's populated with data.

" " Update statistics

Select this check box to generate an update statistics command. This command updates values such as number of rows, row length and pages in the database. This check box is only available when you select the Database statistics check box.

" " Include COMMIT statements after every table

Select this check box to generate COMMIT statements after every table.

" " Generate

Click on this push button to generate DDL statements for all objects in the database or only the objects of a particular database schema or table and it's related objects. You can then create a script of the saved results to regenerate the selected objects in another database.