• Article Type: General
• Product: Aleph
• Product Version: 16.02

Description:
Following KB 8192-4648, we have made our SuDoc and call number indexes on our Test server display in the Browse with a Title column (by making them Direct indexes).

We find, however that, though most of the the call number entries have a title, for some of them, the title column is blank.

Resolution:
The Browse on Direct index gets the Title info from the z13_title field in the bib record z13.

util f/4 in abc01 shows that these doc records do not have z13 records:

enter start Z13 key (999999999) or q to quit
000737200

01 z13_short_doc \
02 z13_rec_key \
03 doc_number ..............000813971 <-- skips to 813971


enter start Z13 key (999999999) or q to quit
004011773

01 z13_short_doc \
02 z13_rec_key \
03 doc_number ..............006000001 <-- skips to 6000001

The following SQL shows that, while the Production server abc01 has exactly the same number of z13's as z00's (correct):

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

**** Hit return to continue ****
COUNT(*)
----------
3568787


SQL-ABC01> select count(*) from z13;

**** Hit return to continue ****
COUNT(*)
----------
3568787

The Test abc01 has 546,009 fewer z13's (3500300 - 2954291):


abc01@ALEPH0> select count(*) from z00;

**** Hit return to continue ****
COUNT(*)
----------
3500300


abc01@ALEPH0> select count(*) from z13;

**** Hit return to continue ****
COUNT(*)
----------
2954291

This indicates a need to run p_manage_07 on the Test server.