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. Does util g/2 last-doc-number tell you how many doc records are in the library?

    Does util g/2 last-doc-number tell you how many doc records are in the library?

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    • Article Type: Q&A
    • Product: Aleph
    • Product Version: 20

    Question

    We have imported our Oracle records into v20 with Upgrade Express and want to confirm that all of the records were loaded.

    The abc01 util/g last-doc-number count is not matching with the count in the oracle_imp_aleph_libs.log.26183.

    The former shows 317596 while the latter has 317594.

    Answer

    util g/2 "last-doc-number" is the highest number which has been assigned to a record in this table. Since it is possible for numbers to have been skipped, it is *not* necessarily a correct indication of the number of records in the table.

    There are two ways to get the number of records in a table:

    1. util a/17/11/2 ("Check Space Utilization of a Table/Index") or

    2. SQL: select count(*) from z00;

    In this case, the SQL shows the same number of z00 records on v18 as v20: 317,594.

    Category: Installation & Upgrades (500)

    Subject: Upgrade Express (500)


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Does Util D save the pc_display_eng directory?
      • Does util w/5 operate on all libraries -- or just the one you are dlib-ed to?
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. contype:kba
      3. Installation & Upgrades (500)
      4. Prod:Aleph
      5. Type:Q&A
      6. Upgrade Express (500)
    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