Defining Segments, Files, and Areas › Segments, Files, and Areas › Segments

Segments

The definition of a segment includes these attributes:

• What type of segment it is; that is, whether the segment definition describes the physical implementation of a non-SQL defined database or an SQL defined database
• Page groups and the maximum number of records or rows that can be stored on a database page; these two parameters determine how many pages the database can contain and the db-key format that describes the location of records or rows in the database
• For SQL-defined databases:
  • Optionally, the name of the schema for which this segment is reserved
  • Optionally, the synchronization stamp level

Example

create segment prodseg
  for sql
  for schema prodschm
  stamp by area;

Note: Segment must be added to DMCL Definition.

Before CA IDMS/DB can use a segment at runtime, you must add the segment to a DMCL, which in turn must exist as a load module in a load library.