Your Browser is not longer supported

Please use Google Chrome, Mozilla Firefox or Microsoft Edge to view the page correctly
Loading...

{{viewport.spaceProperty.prod}}

BPGSIZE functions

The BPGSIZE utility routine offers the following functions:

  • Conversion of a 2-Kbyte database to a database (copy name NEW) with a 4-Kbyte or8-Kbyte format.
    When BPGSIZE converts a database to pages with a larger format, it extends, among other things, the system data structures such as the SCD and page index and thus prepares the database to accept and manage database key values with a REC-REF > 254 and/or an RSQ > 224-1 (see the "Design and Definition" manual).

  • Conversion of a 4-Kbyte database to a database (copy name NEW) with a 8-Kbyte format.

  • Conversion to a database (copy name NEW) that has the same page length, but requires less storage space than the original database due to the compression of realms.
    Compression is enabled by the fact that neither the gaps in the pages of the original database nor the empty pages are transferred to the converted database by BPGSIZE during conversion.

  • Deletion of FPA extents.
    For each realm, BPGSIZE combines the base free space administration table (FPA base) and any existing FPA extents to form an FPA that consists solely of the FPA base. FPA extents may be created in the context of an automatic realm extension, an online realm extension or a realm extension by the BREORG utility routine (see the “Database Operation“ manual, Online realm extension).

  • Deletion of DBTT extents
    BPGSIZE combines each DBTT into a DBTT that consists solely of the DBTT base. Any existing DBTT extents are eliminated.

Realms for which the online extensibility has been activated with the DAL command ACT INCR retain this activation during a BPGSIZE run.