Z0102 and Base Cleanup
- Article Type: General
- Product: Aleph
- Product Version: 16.02
Description:
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?
Resolution:
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