DB2 Server for VM: System Administration

Database Generation Worksheet

This section provides a worksheet. Table 4 covers the database generation control statements. Fill it out as you design your database; then refer to it when you define your minidisks or provide control statements to the SQLDBGEN EXEC.

Table 4. Database Generation Worksheet

Database Name Server Name ______________________________   RESID ______________________________   Database Scope ______________________________ (LOCAL or GLOBAL)

Minidisk Definitions: cylr/ cyls/ cuu devtype blkr blks volser mode pr pw   Directory MDISK ____________________________________ R _______ Log Disk 1 MDISK ____________________________________ R _______ Log Disk 2 MDISK ____________________________________ R _______ Dbextent 1 MDISK ____________________________________ R _______ Dbextent 2 MDISK ____________________________________ R _______ Dbextent 3 MDISK ____________________________________ R _______ Dbextent 4 MDISK ____________________________________ R _______

Database Capacity Parameters:   CUREXTNT _____________ (A value from 1 to 999 must be specified.)   MAXPOOLS _____________ (Default is 32. Value can be from 1 to 999.)   MAXEXTNT _____________ (Default is 64. Value can be from 1 to 999.)   MAXDBSPC _____________ (Default is 1 000. Value can be up to 32 000.)

Nonrecoverable Storage Pools:   POOL ________ NOLOG (Storage pool 1 cannot be specified.)   POOL ________ NOLOG   POOL ________ NOLOG   POOL ________ NOLOG

Database Extent (Dbextent) Placement:   Dbextent Storage Pool Number (Default is 1) -------- -------------- 1 ___   2 ___   3 ___   4 ___ Note: The number of dbextents must equal CUREXTNT, but one is required. The MAXEXTNT value determines the maximum number of database extents.

Public Dbspaces:   SIZE Storage Pool Purpose (In 4K Pages) (Default is 1) --------------------------------- ------------- -------------- Catalog Tables ____ 1   Packages ____ ___   HELP Text ____ ___   ISQL 1024 (minimum) ___   Sample Tables 512 (minimum) ___   _________________________________ ____ ___   _________________________________ ____ ___   _________________________________ ____ ___   _________________________________ ____ ___   _________________________________ ____ ___ Note: The public dbspaces for the catalog tables, packages, HELP text, ISQL, and the sample tables are required. The catalog tables must be in storage pool 1.

Private Dbspaces:   SIZE Storage Pool Purpose (In 4K Pages) (Default is 1) --------------------------------- ------------- --------------   _________________________________ ________ ________   _________________________________ ________ ________   _________________________________ ________ ________   _________________________________ ________ ________   _________________________________ ________ ________   _________________________________ ________ ________

Internal Dbspaces:   Number: _____ Size in 4K Pages: ____ Storage Pool: ____   Note: The MAXDBSPC value determines the maximum total number of public, private, and internal dbspaces possible.