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.
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. This field cannot be edited. |