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 |
|---|---|
|
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 |
|
File Definition
|
Change you can make |
How to make it |
|---|---|
|
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 |
|
|
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 |
|
|
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 |
|---|---|
|
Alter the DMCL definition and generate, punch, and link the DMCL |
Database Buffer Definitions
|
Change you can make |
How to make it |
|---|---|
|
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 |
|---|---|
|
|
|
See 27.8, "Changing the Access Method of a Disk Journal". |
|
Change you can make |
How to make it |
|---|---|
|
|
|
See 27.8, "Changing the Access Method of a Disk Journal". |
Archive Journal Definition
|
Change you can make |
How to make it |
|---|---|
|
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
|
Copyright © 2014 CA.
All rights reserved.
|
|