Previous Topic: Modifying Physical Database DefinitionsNext Topic: Making the Changes Available Under the Central Version


Modifications You Can Make

Changes You Can Make and What To Do

The following tables summarize the changes you can make to physical database definitions and how to make the change. In most cases, all you need to do is:

However, if the entity is defined to the runtime DMCL, some changes affect how CA IDMS/DB processes a request to make the modified DMCL available dynamically. The following tables identify those changes.

When the tables indicate that you must unload and reload a segment or an area, you can use any of the following to accomplish this:

Note: For more information about REORG and UNLOAD/RELOAD, see the CA IDMS Utilities Guide. For more information about CA IDMS/DB Reorg, see the CA IDMS/DB Reorg User Guide.

Segment Definition

Change you can make

How to make it

  • The schema reserved for defining tables and indexes within areas associated with the segment
  • The segment's page group

Alter the segment's definition and generate, punch, and link all DMCLs to which the segment is defined

The maximum number of records or rows per page

  • Alter the segment definition and generate, punch, and link a DMCLin which the segment is included.
  • If the segment is empty, use this DMCL to execute a FORMAT SEGMENT utility statement.
  • If the segment is not empty, use this and a DMCL containing the original segment definition to execute the CONVERT PAGE utility statement.
  • Generate, punch, and link all remaining DMCLs in which the segment is included.

File Definition

Change you can make

How to make it

  • The external file name
  • The file's allocation information, such as the data set name and disposition

Alter the file's definition and generate, punch, and link all DMCLs in which the segment that contains the file is defined

The file's access method (VSAM or non-VSAM)

See 27.4, "Changing the Access Method of a File"

Area Definition

Change you can make

How to make it

Change the page range (but not the number of pages) assigned to an area

  • Alter the area's definition and generate, punch, and link a DMCLin which the area's segment is included.
  • If the area is empty, use this DMCL to format all files in the area
  • If the area is not empty, use this DMCL and a DMCL containing the original segment definition to execute the CONVERT PAGE utility statement.
  • Generate, punch, and link all remaining DMCLs in which the segment is included.

Increase the area's page size

See 27.5.1, "Increasing the Page Size of an Area"

Extend the area's page range

See 27.5.2, "Extending the Page Range of an Area"

Change the primary number of pages assigned to the area'spage range

If the area is not empty, unload and reload the area

Decrease the size of the area's pages

If the area is not empty, unload and reload the area

Increase or decrease the page reserve

  • Use an area override in the DMCL definitionfor special operations, such as loading a database; then remove the area override
  • To make a permanent change, alter the area definition; if the area is not empty, changing the page reserve affects only subsequent store and insert operations
  • Generate, punch and link the DMCL(s) that contain the area override or the segment that contains the defined area

Add, modify, or drop a symbolic definition 1

Alter the area's definition and generate, punch, and link all DMCLs in which the segment that contains the area is defined

Re-assign the area to new or different files

See 27.6, "Adding or Dropping Files Associated With an Area"

Update an area's timestamp

Alter the area's definition and specify the new timestamp value. This applies only to areas defined for SQL use.

1. If changing the page range of a subarea associated with a record in a non-empty area, unload and reload the area. If changing the page range of a subarea associated with an index in a non-empty area, use the MAINTAIN INDEX utility statement to rebuild the index in the new page range as described in the CA IDMS Utilities Guide.

DMCL Definition

Change you can make

How to make it

  • Reassign the buffer associated with a file
  • Associate or disassociate a database name table
  • Add or remove a segment
  • Change an area's startup or warmstart status
  • Change an area's page reserve
  • Change the external file name for a file
  • Change the disposition for a file
  • Change the use of memory caching for a file
  • Change the shared cache assigned to a file

Alter the DMCL definition and generate, punch, and link the DMCL

Database Buffer Definitions

Change you can make

How to make it

  • Change the buffer page size
  • Change the buffer page count
  • Change how the CA IDMS/DB acquires storage for the buffer
  • Add or remove buffers

Alter the buffer definition and generate, punch, and link the DMCL with which the buffer is associated

Journal Buffer Definition

Change you can make

How to make it

Change the size of the journal buffer pages

See 27.7, "Changing the Page Size of a Disk Journal".

 

Change the number of journal buffer pages

Alter the definition of the journal buffer and generate, punch, and link the DMCL with which the journal buffer is associated.

Disk Journal Definition

Change you can make

How to make it

  • Change the external file name
  • Add or remove a disk journal file
  • Change the file's allocation information, such as its data setname
  • Change the number of pages in the disk journal file
  • If altering the characteristics of or removing an existingjournal file, offload its contents
  • Alter the journal file's definition and generate, punch, and link the DMCL
  • Format the journal file
  • Change the file's access method

See 27.8, "Changing the Access Method of a Disk Journal".

Change you can make

How to make it

  • Change the external file name
  • Add or remove a disk journal file
  • Change the file's allocation information, such as its data setname
  • Change the number of pages in the disk journal file
  • If altering the characteristics of or removing an existing journal file, offload its contents
  • Alter the journal file's definition and generate, punch, and link the DMCL
  • Format the journal file
  • Change the file's access method

See 27.8, "Changing the Access Method of a Disk Journal".

Archive Journal Definition

Change you can make

How to make it

  • Change the file's block size
  • Change the file's external file name
  • Add or remove archive journal files

Alter the archive file's definition and generate, punch, and link the DMCL with which the archive file is associated

Tape Journal Definition

Change you can make

How to make it

 

Change the file's external file name

Alter the tape file's definition and generate, punch, and link the DMCL with which the tape journal file is associated

Changes You Cannot Make