Command Reference

db2uiddl - Prepare Unique Index Conversion to V5 Semantics

Facilitates the management of a staged migration of unique indexes on a user's own schedule. Generates CREATE UNIQUE INDEX statements for unique indexes on user tables. For detailed information about using this tool, see one of the Quick Beginnings books.

Authorization

sysadm

Required Connection

Database. This command automatically establishes a connection to the specified database.

Command Syntax

>>-db2uiddl---d--database-name----+-------------------+--------->
                                  '--u--table-schema--'
 
>-----+-----------------+---+---------------+---+-----+--------><
      '--t--table-name--'   '--o--filename--'   '--h--'
 

Command Parameters

-d database-name

The name of the database to be queried.

-u table-schema

Specifies the schema (creator user ID) of the tables that are to be processed. The default action is to process tables created by all user IDs.

-t table-name

The name of a table that is to be processed. The default action is to process all tables.

-o filename

The name of a file to which output is to be written. The default action is to write output to standard output.

-h

Display help information. When this option is specified, all other options are ignored, and only the help information is displayed.

Usage Notes

This tool can only be used on a database that has been migrated to DB2 Version 5.

Note:

This tool was not designed to handle certain types of names. If a specific table name or table schema is a delimited identifier containing lower case characters, special characters, or blanks, it is preferable to request processing of all tables or schemas. The resulting output can be edited.