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. This field cannot be edited.
  • DB2 for z/OS®: Specifies a database type. You can select REGULAR, WORKFILE, or TEMP.
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. This field cannot be edited.
Documentation page
Specifies user-supplied information about the object.
Annotation page (in edit mode only)
Add, modify, or delete properties.

Feedback