MGL Type and Instance Graphs
Database
Area
File
Record
DB1
A1
A2
F1
F2
F3
R1.1
R1.2
R2.1
R2.2
R2.3
R2.1
R2.2
Lock Type
Graph
Lock Instance Graph
Before setting a read lock on R2.3, first set an intention-read lock on DB1, then A2, and then F2.
Set locks root-to-leaf. Release locks leaf-to-root.
Previous slide
Next slide
Back to first slide
View graphic version