Database or database instance properties

Properties for IBM® data server database or database instance objects

For more information about database syntax, see the reference information that is included with each database product. There might be differences between the IBM data server syntax and the syntax for other vendors.

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.
Related information
CREATE DATABASE statement syntax, Version 9.1 for z/OS
CREATE DATABASE command, DB2 Version 9.1 for Linux, UNIX, and Windows
CREATE DATABASE statement syntax, IBM Informix Dynamic Server v10.0

Feedback