Create Database panel

You use the Create Database panel to create a new database.

Panel and field definitions

  Process   Options   Utilities   Help
                                                                                
 FM/Db2 (DFG2)                  Create Database

 Database:
    Name . . . . . . . . . . . .             (required)

 Buffer Pools, Storage Groups:
    Storage group name . . . . .           + (optional)
    Buffer pool for table spaces             (optional)
    Buffer pool for indexes                  (optional)

 Database Options:
    Database Usage                     Data Encoding (only for user databases)
       1. User database   (default)       1. EBCDIC   (default)
       2. Work file database              2. ASCII
       3. Temporary database              3. UNICODE

 Member Selection:
    Member name                             (only valid for work file databases)

 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F4=Expand    F7=Backward  F8=Forward
  F9=Swap     F10=Left     F11=Right    F12=Cancel
Name
Specify the name of the Db2® database you want to create.
Storage group name
Names the Db2® storage group to be used, as the default group for DASD allocation for table spaces and indexes in the database.
Buffer pool for table spaces
Specifies the default buffer pool name to be used for table spaces created within the database.
  1. 8K buffers: (BP8K0-BP8K9)
  2. 16K buffers:(BP16K0-BP16K9)
Note:

8K and 16K buffer pools are not supported for work file databases.

Buffer pool for indexes
Specifies the default buffer pool name to be used for the indexes created within the database.
Database Usage
1. User database (default)
Specifies the database is an ordinary database for general user tables and indexes.
2. Work file database
Specifies the database is a work file database for use in a data sharing environment.
Temporary database
Specifies the database is for declared temporary tables only.
Data Encoding (only for user databases)
1. EBCDIC (default)
Specifies the encoding scheme.
2. ASCII
Specifies the encoding scheme.
3.UNICODE
Specifies the encoding scheme.

Parent panels

Child panels

None.

Related tasks