• Article Type: General
• Product: Aleph
• Product Version: 18.01

Description:
What is the z60 table? When do records get written there?

Resolution:
The z60 is the record-locking table. In v15-up, it is located in the VIR01 library.

A lock record is written when a GUI user calls up a record in Edit mode.

One typically sees records like this in the z60 table:

ABC50PC-ITEM-000931868
ABC50PC-USR-ID200033128
ABC01PC-DOC-000476387
ABC50PC-ADM-001498640

How long the lock lasts depends on the lock period. Lock records don't automatically disappear from the z60; they may be there but in an expired state.

In v16, util a/12 drops/creates the z60; in v17-up, clear_vir01 (run nightly) drops/creates the z60. You can do this to correct the situation immediately:

> dlib vir01
> util a/17/1 [for z60]

See Article 000038415 ("Record locked by another user") in regard to viewing/deleting z60 locks.