p_cir_51: "No space left on device"; did it update any records?

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

Article Type: General
Product: Aleph
Product Version: 20

Description:
The /exlibris file system ran out of space due to util e 23 on one of our libraries. I stopped the process and cleared the drive.

During the night, the p-cir-51 job was scheduled to run. In the jobd log, I show aleph_que.c: No space left on device. In ttu50/scratch I find that the .scr file size is zero. In abc50/print, the output files also show zero size.

The question is this - can we find out if the records updated in the course of running the job. If so, where can we find it?

Resolution:
p_cir_51 updates two fields in the z36 record: Z36_LETTER_NUMBER and Z36_LETTER_DATE.

These updates are done by the b_cir_51_e program, which, as can be seen in $aleph_proc/p_cir_51, executes after the b_cir_51_a and b_cir_51_b programs. Since these earlier programs were failing I suspected that it never got to the b_cir_51_e, but did the following SQL query to confirm that:

abc50@ALEPH20> select count (*) from z36 where Z36_LETTER_DATE = '20110601';
**** Hit return to continue ****

COUNT(*)
----------
0

This query shows that no z36 records were updated with today's date as the letter date. The loan records which should have had overdue notices produced today will have them produced in tonight's run.

Article last edited: 10/8/2013