Skip to main content
ExLibris

Knowledge Assistant

BETA
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Z69 table: what is it? how populated/cleaned?

    Z69 table: what is it? how populated/cleaned?

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct; Direct; Local; Total Care


    Can you give me information about the Z69 table? What is it and how does it get populated? Should it be cleaned out on a regular basis? I don't see anything about this table in the Oracle table documentation.

    Resolution:

    The z69.pdf document describes the z69 table.  See attached Z69.doc .


    Z69 table stores web OPAC events much like z35 stores ADM library events. 

    The z69 is used to get more detailed OPAC Statistics. It is used by the ALEPH Reporting Center, but could also be built and queried by local SQL scripts.

    It is populated by the www_server as users perform queries. It's like the z35 statistics table: when you are done with the statistics for a particular time period, you can delete the Z69 records for that time period.

    This table could grow large *very* quickly. I believe the number of records would be similar to the Z34 (for those who have that set up), but since the Z69 record is 10 times as large, this table would be ten times as large.

     

    In version 22-up, util x/13/2 can be used to delete older records from this table (-- once you have produced whatever statistics you need.)

    Additional Information

    z69, OPAC, statistic, reporting center, SQL, z35,


    • Article last edited: 22-Mar-2017
    View article in the Exlibris Knowledge Center
    1. Back to top
      • z69 event type 35
      • Z73: its purpose and mechanism for cleaning
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 16.02
      2. contype:kba
      3. Dedicated-Direct
      4. Direct
      5. Local
      6. Prod:Aleph
      7. Total Care
      8. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved