How to Expand the Employee Demo Database With Mixed Page Group Index Sets › Move the EMPDEMO.INS-DEMO-REGION

Move the EMPDEMO.INS-DEMO-REGION

This procedure, the final part of the process to expand the employee demo database, moves the EMPDEMO.INS-DEMO-REGION to a unique page group.

Follow these steps:

1. Modify the DMCL for physical area and segment changes.
   1. Create the INSDEMO segment.

   Note: With the MPGI feature enhancement, you can assign segment INSDEMO to a different page group than the one to which EMPDEMO is assigned.

   CREATE
   SEGMENT INSDEMO
   FOR NONSQL
   PAGE GROUP 1
   MAXIMUM RECORDS PER PAGE 255
   ;

   1. Modify the file and area assignments for INS-DEMO-REGION to associate them with the INSDEMO segment.

      ALTER SEGMENT INSDEMO;
      CREATE
      FILE INSDEMO. INSDEMO-FILE
      ASSIGN TO INSDEMO
      DISP SHR
      NONVSAM
      ;
      
      CREATE
      PHYSICAL AREA INSDEMO.INS-DEMO-REGION
      WITHIN FILE INSDEMO
      ;

   2. Remove the file and area assignments for INS-DEMO-REGION that associate them with the EMPDEMO segment.

      ALTER SEGMENT EMPDEMO;
      DROP
      PHYSICAL AREA EMPDEMO.INS-DEMO-REGION
      ;
      DROP
      FILE EMPDEMO.INSDEMO
      ;

2. Add the INSDEMO segment to DMCL

   ALTER DMCL xxxxDMCL
   INCLUDE SEGMENT INSDEMO;

3. Generate the modified DMCL.
4. Modify all affected DBNAME table entries to allow mixed page group binds, if not already done, and include the new INSDEMO segment.

   ALTER DBTABLE xxxxDBTB;
   ALTER DBNAME EMPDB
   MIXED PAGE GROUP BINDS ALLOWED;
   INCLUDE SEGMENT INSDEMO;

5. Generate the modified DBNAME table.

   The employee demo database is now organized to allow for additional database space and maximum growth.