Schema
Database objects
Tablespaces, nodegroups, and bufferpools
Authorization statements
Database statistics
Update statistics
Include COMMIT statements after every table
Gather configuration parameters
Generate
Schedule
Show Command
Cancel
Schema
Select the name of a schema for which you want to generate DDL statements from this drop-down list. DDL statements for all objects contained in the specified schema will be generated. Selecting All Schemas from the list means DDL statements will be generated for all schemas in the database. Selecting NULLID from the list means that DDL statements will be generated for schemas with the name NULLID in the database.
This check box is only available when you generate DDL statements 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. When this option is selected, the authorities and privileges from the current database will be recreated in the database that is generated.
Database statistics
Select this check box to generate SQL statements for table statistics in the database. When you select this check box, the Update statistics check box is enabled.
When you recreate a database's objects and its statistics in another database, the DB2 Optimizer will treat this database as if it is populated with data.
Update statistics
Select this check box to generate commands in the DDL script that is created which will update the statistics catalog tables in the database that is generated. 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.
Gather configuration parameters
Select this check box to gather Database Configuration Parameter Summary and Database Manager Configuration Parameter Summary configuration parameters for use by the SQL Optimizer. When these configuration parameters are gathered, the DDL script will more closely resemble the database used to create it.
| Note: | This option is only available for DB2 Universal Database Version 7 and above. |
Generate
Click 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 its related objects. You can then create a script of the saved results to regenerate the selected objects in another database.
