Database or database instance properties

Properties for database or database instance objects

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.

General page
Property Description
Name Specifies a name for the object.
Label Specifies a label that is displayed in visual diagrams.
Database type
  • DB2® for Linux, UNIX, and Windows or DB2 for iSeries®: Shows the database type. You cannot edit this field.
  • DB2 for z/OS®: Specifies a 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.
Defaults page (DB2 V10.5 for Linux, UNIX, and Windows only)
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.
Documentation page
Specifies user-supplied information about the object.
Annotation page (in edit mode only)
Add, modify, or delete properties.

Feedback