Database properties (DB2 UDB for z/OS)

Use the Properties view to modify the properties of a DB2® UDB for z/OS® database.

For more information about DB2 UDB for z/OS syntax, see the reference information that is included with the product. There may be differences between DB2 syntax and the syntax for other vendors.

General page
Property Description
Name Type a name.
Label Type a label. This label is displayed in visual diagrams.
Database type Select a database type. You can select REGULAR, WORKFILE, or TEMP.
Encoding scheme Select an encoding scheme. You can select EBCDIC, ASCII, UNICODE, or NONE.
Buffer pool Specify the default buffer pool name to be used for table spaces created within the database. This field sets the buffer pool name in the BUFFERPOOL clause.
Index buffer pool Specify the default buffer pool name to be used for the indexes created within the database. This field sets the buffer pool name in the INDEXBP clause.
Storage group Select the storage group to be used, as required, as a default storage group to support DASD space requirements for table spaces and indexes within the database. This field sets the storage group name in the STOGROUP clause. Click Show Properties Show Properties icon to open the Properties view for the selected object.
Documentation page
Type information about the object.
Annotation page
Add or delete properties and edit their values.

Feedback