DB2 Server for VSE: System Administration

Database Generation Worksheet

This section provides two worksheets. Figure 13 covers the items that you must address in order to define the VSAM data sets for your database, and Table 5 covers the database generation control statements. Fill them out as you design your database; then refer to them when you do the actual database generation.

Figure 13. Important Factors for Installing Your Own Database

Need to define VSAM Master Catalog: NO: __ YES: __ CYL./BLOCKS: ____ VOLUME: _________ ORIGIN: ____ Need to define VSAM User Catalog: NO: __ YES: __ CYL./BLOCKS: ____ VOLUME: _________ ORIGIN: ____ Need to password protect data sets: NO: __ YES: __ Level: ______ Password: ___________   (Only one VSAM Data Space Required) Data Space 1: ORIGIN: ____ CYL./BLOCKS: ___ VOLUME: _________   Data Space 2: ORIGIN: ____ CYL./BLOCKS: ___ VOLUME: _________   Data Space 3: ORIGIN: ____ CYL./BLOCKS: ___ VOLUME: _________   Data Space n: ORIGIN: ____ CYL./BLOCKS: ___ VOLUME: _________   Directory: NAME: _____________________ CYL./BLOCKS: ___ VOLUME: __________   (Only one Log Required) Primary Log: NAME: _____________________ CYL./BLOCKS: ___ VOLUME: __________ Secondary Log: NAME: _____________________ CYL./BLOCKS: ___ VOLUME: __________ (Only one Dbextent Required) Dbextent 1: NAME: _____________________ CYL./BLOCKS: ___ VOLUME: __________ Dbextent 2: NAME: _____________________ CYL./BLOCKS: ___ VOLUME: __________ Dbextent 3: NAME: _____________________ CYL./BLOCKS: ___ VOLUME: __________ Dbextent n: NAME: _____________________ CYL./BLOCKS: ___ VOLUME: __________

Table 5. Database Generation Worksheet

Database Name Server Name ______________________________   APPLID ______________________________

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.