System Record Types

SR1

1

Participates as owner in the system-owned CALC set; members are all user record types with a storage mode of CALC; occurs once for each page in a standard database area as bytes 5 through 16 in the header

SR2

2

Replaces records relocated by the RESTRUCTURE, and the migration utility (RHDCMIG1 and RHDCMIG2), and SQL processing following the addition of a column to a table; eight bytes in length

SR3

3

Identifies a user record as having been relocated; the actual user-designated record identification can be found in the relocated record's corresponding SR2 record

SR4

4

Identifies fragments of variable-length records; the actual user-designated record identification can be found in the line index of the root portion of the record

SR5

5

Holds the area-level synchronization stamp for SQL-defined segments and acts as an owner for the table-level synchronization stamp records (SR9s)

SR6

6

Appears in the subschema tables for excluded owner or member record definitions in set relationships; never occurs in the database

SR7

7

Participates as owner in an index; stores CALC under the indexed set's name; occurs once for each indexed set in the database that does not have a user-defined owner record (for details, see Chapter 20, Two-phase Commit Processing")

SR8

8

Contains index entries that point to lower level SR8 records or to an indexed set's member database record occurrences; chained by next, prior, and owner pointers to the owner record occurrence of an indexed set (for details, see Chapter 20, "Two-phase Commit Processing")

SR9

9

Holds the table identifier and synchronization stamp for each table in the area