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

    ue_01 count suddenly very high

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

    Description:
    The current count of SYS01 Z07s is over 413,000. Yesterday it was quite low (<100); more typical.

    It seems that someone submitted a major job last night. We aren't quite sure what job, though. We don't see anything likely in task manager or in /exlibris/aleph/u18_1/alephe/scratch that seems likely.

    Resolution:
    This SQL (from KB 4093) shows that almost all the z07's are coming from JKL50:

    sys01@ALEPH0> select substr (z07_history, 1,5), count(*) from z07 group by substr (z07_history, 1,5);
    **** Hit return to continue ****

    SUBSTR(Z07_HIST COUNT(*)
    --------------- ----------
    ABC50 295
    DEF50 4
    SYS60 452
    GHI50 42
    JKL50 404471
    MNO50 433
    PQR50 514

    As described in KB 8192-2743, one of the primary possibilities for large numbers of ADM-generated Z07s is p_manage_62. I see a very large p_manage_62 for JKL50 in $alephe_scratch: jkl50_p_manage_62.


    • Article last edited: 10/8/2013