DB2 Server for VSE: System Administration

Expanding the Database Directory

When a database is initially generated, a calculation is made to determine which portion of the directory will be set aside for the page map table, and which portion will be used for the allocation bitmaps. The size of the page map table determines the maximum number of DBSPACE pages, that is, the maximum logical size of the database. The size of the allocation bitmap determines the maximum number of dbextent pages, that is, the maximum physical size of the database. As the database grows in size with use, it may run short on either logical or physical space. If it is short on logical space, the ADD DBSPACE operation may fail. If it is short on physical space, the ADD DBEXTENT operation may fail. You can expand the directory to correct these situations.

You can use ARIMEXBD to increase:

• The maximum number of dbspace pages, by expanding the page map table using EXPAND=DBSPACE. See Figure 60.
• The maximum number of dbspace pages and dbextent pages, by expanding the page map table and allocation bitmaps concurrently using EXPAND=ALL. See Figure 60.

Expand the directory as follows:

1. Use the VSAM IDCAMS DEFINE commands to define the VSAM data set for the new directory.

   For information about these commands, see the Using VSE/VSAM Commands and Macros manual.

2. Run the utility program ARIMEXBD. An example is shown in Figure 60.
3. Update the DLBL statement for the BDISK to reflect the change.

Figure 60. Sample ARIMEXBD Job

// JOB EXPAND BDISK // LIBDEF PROC,SEARCH=(PRD2.DB2710) // EXEC PROC=ARIS71PL *-- PRODUCTION LIBRARY ID PROC // EXEC PROC=ARIS71DB *-- DATABASE ID PROC // DLBL BDSKNEW,'SQL.BDSKNEW.STARTER.DB',,VSAM (1) // EXEC ARIMEXBD,SIZE=AUTO,PARM='DBPSWD=password,EXPAND=DBSPACE|ALL'(2) /* /&

Notes for Figure 60:

(1)

In the DLBL statements, the file name for the new directory data set must be BDSKNEW.

(2)

If the VSAM data sets are password-protected, enter the correct password on the DBPSWD parameter.