Aleph Reindexing Project

Project to reindex Aleph Production, using revised indexing specifications. FCLA has been working with TSPC and the Authorities Subcommittee to revise the current specifications. FCLA has also been working on the best process for handling the reindexing with minimal downtime in PRODuction Aleph. Reindexing started for the first production library, FIU, 1/23/09, and ended 5/17/09 with the redo of the FIU01 indexes.

StepFAMUFAUFGCUFIUFSUNCFUCFUFUNFUSFUWF
Process begun3/6/094/24/092/23/091/23/09; fiu01 redo 5/6/092/9/095/4/094/1/094/13/092/4/09; nfu01 headings redo 2/18/093/2/094/3/09
Indexing finished on PXPROD3/19/09 5/9/093/4/092/4/09; redo 5/15/092/25/095/8/094/13/095/1/092/12/09; redo 2/26/093/19/09 4/16/09
New indexes in PROD3/22/09 5/10/093/5/092/8/09; redo 5/17/093/1/095/10/094/19/095/3/092/15/09; redo 3/1/093/22/09 4/19/09
Library signoff3/23/09 5/11/093/6/092/9/09; redo 5/18/093/3/095/12/094/20/09 5/4/092/16/09; redo 3/2/093/23/09 4/21/09
REPT updated3/24/09 5/12/093/7/09 2/11/09; redo 5/19/093/4/095/12/094/21/09 5/5/092/17/09; redo 3/4/093/24/09 4/22/09


Here's an outline of the process. I hope it addresses a lot of your questions and concerns. Let me know if you still have questions or if something's unclear.

Mary Ann, FCLA

=====================================================

REINDEXING YOUR PRODUCTION ALEPH

IMPACT ON YOUR LIBRARY
Do not run large data loads (over 15K records), large global changes (over 15K records) or other large data maintenance projects during the 2-3 weeks of reindexing. (see section B) It is ok to run regular monthly loads such as Serial Solutions and Marcive even if they're over 15K records.

PROD will be unavailable during the Sunday morning maintenance window when the rebuilt indexes are copied back to PROD. There's an outside chance the downtime will extend beyond the window. (see section C)

REPT will be unavailable, and ARROW will be unavailable or out-of-date, for 2-3 days after indexes are copied back to PROD. (see section E)


REINDEXING DETAILS
PRELIMINARY: (optional) Phone call between library and FCLA to go over the process

A. DAY 1 UNTIL SUNDAY 2-3 WEEKS LATER (2 weeks for small and mid-size libraries, 3 weeks for FSU, UF, USF)

B. DAY 1 UNTIL REPT IS SYNC'ED WITH PROD

C. LAST DAY (SUNDAY)
Installing the new indexes on PROD requires your Aleph to be down on PROD. We plan to do this within the normal 6am-10am Sunday morning maintenance window. If something unexpected occurs and downtime extends past the maintenance window, we'll be ready to implement our downtime procedures. This means Mango and Aleph OPAC will be switched to the backup copy of Aleph with patron empowerment turned off; the library may decide to go onto offline circ.

New indexes are available on PROD as soon as your Aleph comes back up.

New records added during the reindexing may be missing from the indexes on Sunday until the records from the "delta" indexing are processed.


D. MONDAY AFTER THE INDEX COPY TO PROD

E. TUESDAY OR WEDNESDAY

F. WEDNESDAY AND LATER