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

    Z0102 and Base Cleanup

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

    When we recently ran p_manage_32 we found that the number of records in the resulting z0102 table was about half of what it had been before the run.
    Does ue_08 do cleanup of z0102, or should a rebuild of this periodically be added to our maintenance schedule?

    The deletion of a z01 (by p_manage_15, which is the only process that physically deletes z01s) does not result in deletion of the associated z0102s. You would need to run p_manage_32 to do this -- but it should be noted that, though they take up some space, presence of these "orphaned" z0102's does *not* cause any system problem. (Since the Z01 they are associated with is deleted, the system will never use these.)

    [Keywords p-manage-15 manage-15 manage_15 p-manage-32 manage-32 manage_32]

    Additional Information

    manage_32, z0102

    • Article last edited: 10/8/2013