Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    What is the z60 table?

    • 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.

    Additional Information

    Record locked by another user


    • Article last edited: 10/8/2013
    • Was this article helpful?