Counting how many bib records were loaded in x period of time

Description

How can we tell how many bib records were loaded in x period of time?

Resolution

When a bib record is added/updated in the GUI or via batch load it generates a z07 indexing request.  You can tell how many updates have occurred by the number of z07 records which have been generated.

Z07 records are processed by the ue_01 indexing daemon.   When a z07 is processed, it's deleted (and generates a z07a word-indexing request).  The number of z07s created in x period of time is the total of the z07's which have been processed by ue_01 and the number still in the queue.

The following grep shows the number of z07's processed by ue_01:

> grep -c HANDLING run_e_01.nnnn

And the following SQL, the number of z07's still in the queue:

> s+ xxx01
SQL> select count(*) from z07;

• Article last edited: 10-Oct-2017