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 Default buffer pool 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 Database sharing field, specify the type of sharing ROSHARE to be used:

    READ ONLY
    The current server has read-only access to the database through shared read-only data.
    Shared as OWNER
    The database will be shared, and the current server will be the DB2 that can update the database.
    NONE
    Not shared

  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 memeber, specify Use as work file radio button, and type a data sharing member name.

  8. Click OK to create the database.

Related information: