Creating a database

Use this window to define a new database. A database is a set of DB2 structures.

Authorizations and privileges

To define a database:

  1. Open the Create database window.

  2. In the Name field, type a valid unique name for your database. This name can be no longer than 8 bytes.

  3. In the Default storage group field, specify a valid storage group name to be used with this database from the list. You can also accept the default storage group that is provided. You use a storage group to support DASD space requirements for table spaces and indexes within the database.

  4. In the Buffer pool for table spaces field, specify a valid buffer pool name to be used for table spaces created within the database. You can also accept the default buffer pool name.

  5. In the Buffer pool for indexes field, specify a valid buffer pool name to be used for the indexes created within the database. The name must identify a 4KB buffer pool. You can also accept the default buffer pool name.

  6. In the Encoding scheme field, specify the encoding scheme: ASCII, EBCDIC, or the system installed default. This is not valid if this database is to be used as a work file in a data sharing environment. If you do not want to use the default encoding scheme that was selected when you installed DB2 for OS/390, you can override your installation selection here.

  7. Optional: If you want to use the database as a work file for a data sharing member, specify Use as work file radio button, and type a data sharing member name.

  8. Click OK to create the database.

Related information: