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. Total number of bib records in database

    Total number of bib records in database

    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

    Description:
    How can we find the total number of bib records in our database?

    Resolution:
    util h/1/10 shows you the number of records in each bib library and in each logical base. You can choose a base which excludes deleted or suppressed records, as desired.

    The util g/2 last-doc-number is not a good count. When the system adds a record, the last-doc-number is used to get the next number and is incremented. If this counter has never been adjusted manually and if you haven't physically deleted bib records, there shouldn't be any "holes" in the numbering and the count should reflect the number of bib records.

    If there *are* holes, then you can use this sql to get a count:

    SQL-xxx01> select count(*) from z00;

    Note that the above counts include *all* bib records, including ones which have been deleted (having just a "DEL Y" field).} If you want to exclude deleted records from the count, then you can do this SQL:

    SQL-xxx01> select count(*) from z13 where Z13_TITLE is not null;

    (Note: this will exclude records which have "DEL Y" and also those with "STA $a DELETED".)

    To limit the count to bib records created in the past year:

    SQL-xxx01> select count(*) from z13 where Z13_TITLE is not null and Z13_OPEN_DATE between 20050901 and 20060831;

    To exclude Suppressed records from the count, you can go to the GUI and do this CCL search: "wst = suppressed". Then subtract that number from the preceding count. You could also get a count using p_ret_01, excluding "DEL Y" and "STA $a Deleted" and/or "STA $a Suppressed" records.

    Additional Information

    number, bibliographic records


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Total bib deletion: which records are deleted?
      • Total-bib-deleted records have 040 field "RUG", "BAS" field, etc.
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. contype:kba
      3. Prod:Aleph
      4. 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