Number of z00p records fewer than should be

• Article Type: General
• Product: Aleph
• Product Version: 20
• Relevant for Installation Type: Dedicated-Direct; Direct; Local;

After running publish-04 to initially extract records to the $usr_library, the number of Z00P records ("ALEPH Published Documents") is significantly lower than it should be. (And, of course, these records lacking z00p's do not appear in Primo.)

Note: If certain records which *do* have z00p records do not appear in Primo, see links for the two articles in Additional Information below.

Analysis:
Case #1. publish-04 failed for some reason. A common cause of failure is lack of space.... For instance, the $alephe_scratch/xxx01_p_publish_04.00nnn may have: "Exiting due to job suspension."
And the ./xxx01/scratch/p_publish_04_b_1.log, could show:
Error: write_xml_to_clob: ORA-01691: unable to extend lob segment XXX50.Z00P_SEGNAME by 512 in t

See Additional Information #B below for Complete analysis of publish-04 failure.

Case #2. If some time has elapsed from the last run of publish-04, various problems could have intervened.
To see just how many fewer z00p records there are than there should be....

The number of Z00P records for the PRIMO-FULL publishing set (or its equivalent, with a different name) will be equal to the number of records in the logical base (such as "xxx01PUB") specified in column 2 of the ./xxx01/tab/tab_publish entry for the publishing set.

To calculate this number of records for the col. 2 base for the "PRIMO-FULL" publishing set:

a. do the following SQL to get a count of non-deleted bib records {those which have a non-null 245 (title) field in the z13}:

SQL> select count(*) from xxx01.z13 where z13_rec_key in (select z13_rec_key from xxx01.z13 where z13_title is null;

b. do a GUI search or run the ret-03 Service (Retrieve Records Using CCL) for suppressed records: use the Find command from col. 9 of the tab_base.lng entry {example: wst=(suppressed or deleted or analytic or circ-created)}.

c. find the number of z00p records for this particular publishing set:

SQL> select count(*) from z00p where z00p_set = 'xxxxxxx';
<where "xxxxxx" is the publishing set from col. 1 of tab_publish>

d. subtract b and c from a to get the number of bib records which should have a z00p but do not.


If the publishing set is *not* the full database, but some smaller logical base, then that base can be checked in util h/1/10 ("Z0102 Setup") to get a count of the number of "Docs" which are in the base. Then get the count of z00p records as described in "c" above, and subtract it from the count from util h/1/10 to get the count of records in the publishing set's base which lack a z00p.


Resolution:

Case #1. publish-04 failed for some reason. Correct the problem. If the problem is lack of space, add datafiles to the tablespace the z00p resides in.

Case #2. If the count of records missing a z00p is more than, say, 500, then do this:

1. run publish-05 for each affected dataset (such as "PRIMO-FULL") to delete its z00p records

2. run publish-04 for the each affected dataset to properly create its z00p records with:
Publishing Set PRIMO-FULL
From key 000000000
To key 999999999

3. run publish-06 with
"Create Tar File For" "Range of documents"
From key 000000000
To key 999999999
Update Date Flag Y

4. On the Primo side, drop the entire existing STA01 PRIMO-FULL publishing set, run the pipe to harvest the tar file created by publish-06 and index it.