For more information about specific syntax, see the reference information that is included with each database product. Syntax definitions for some database vendors or versions might differ from the following descriptions.
Property | Description |
---|---|
Name | Specifies a name for the object. |
Label | Specifies a label that is displayed in visual diagrams. |
Database type |
|
DB2 for z/OS only: Encoding scheme | Specifies an encoding scheme. You can select EBCDIC, ASCII, UNICODE, or NONE. This setting specifies which CCSIDs are used to encode the data. |
DB2 for z/OS only: Buffer pool | Specifies the default buffer pool for table spaces that are created within the database. This field sets the buffer pool in the BUFFERPOOL clause. |
DB2 for z/OS only: Index buffer pool | Specifies the default buffer pool for the indexes that are created within the database. This field sets the buffer pool in the INDEXBP clause. |
DB2 for z/OS only: Storage group | Select the storage group as a default storage group to support DASD space requirements for table spaces and indexes within the database. This field sets the storage group in the STOGROUP clause. |
DB2 for Linux, UNIX, and Windows or iSeries only: Database version | Shows the database version. You cannot edit this field. |
Property | Description |
---|---|
Table organization | Specifies the default table organization that
is used by the database when tables are created without specifying
the table organization. This value is also used by applications when
tables that do not specify a table organization are edited, validated,
or compared. The database default organization is Row. Important: All tables that do not specify a table organization
will be categorized to the value that is specified as the default
table organization for the database. If you change the default table
organization for the database to column organization, many of the
row-organized table properties become invalid.
|