Creating objects

Creating objects is one of the more challenging tasks associated with maintaining a database. The methods traditionally used to create Db2 database objects are time-consuming, and they require an extensive knowledge of both Structured Query Language (SQL) and the existing Db2 catalog table structures.

Catalog Manager provides simpler, more efficient methods for handling database definition by enabling you to create objects if you do not know SQL. You can create objects by using an existing object as a model. In addition, you can generate DDL to create objects.

Before you begin

Before you begin creating objects, you should be familiar with how to search for and list objects.

If necessary, review Working-with-lists-and-searches before reading this section.

Important

You must have the appropriate Db2 authorization to create objects before you can use Catalog Manager to perform the tasks described in this section.

By default, Catalog Manager specifies your SQL ID as the owner when you create objects. To specify that your TSO ID is the owner, set the value of the SQL Ownerid switch to TSO. For more information, see Setting-Catalog-Manager-switches.

Before you create table spaces or indexes, you can use the Simple Space Estimation (SSE) feature to estimate the space requirements of these objects and predict storage capacity. For more information, see Space-requirement-estimates-based-on-user-specified-values.

This section contains the following topics:



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*