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

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