pw_library / usr_library file_list questions

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

Description:
I have some questions about what we do and do not need in our pw_library, which for us is PWD50. I brought certain things over from our Aleph16 implementation and have compared with the USR00 library, but there are still a couple of questions.

1) Is the Z119 table no longer needed? It was one I copied over, but does not show up in USR00 and there is no SQL to create it.

2) Does the pw_library need a Z305? Upgrade Express added one to our file_list, but I'm not sure if that was because we need it or because it thought it was an xxx50 library and thus should have a z305. p_cir_25 on NDU50 gave lots of errors about z305 in pwd50. If pwd50 does not need a z305, how would I get around those errors?

3) USR00 has a z00p. What is this and do we need this?

4) USR00 has a z700 and p_manage_111 complains about it. Do I need it? What is it? I have no Oracle description sheet for this table.

5) USR00 adds a z105 trigger. Do I need to add this and then recreate triggers. Upgrade Express did nothing to add this to the file_list.

6) USR00 has a last_publish_seq. Do I need this? Upgrade Express did nothing to add this to the file_list.

Resolution:
In general: the $aleph_root/tab/ file_list templates (file_list.BIB, file_list.USR, file_list.PW, etc.) can be useful in showing you what tables, indexes, etc., should be in the file_list of each kind of library.

To answer the specific questions:

1. KB 4883 says, "From the Oracle Tables documentation, both Z109 and Z119 are removed. They no longer exist in the ./alephm/source/copy or in the ./alephm/sql_tab."

2. The pw_library doesn't need the z305, but in version 18, the usr_library does. You should use util a/17/1 in the $usr_library to create the $usr_library z305. KB records 8192-1399 and 8192-3799 talk about this.

3. The z00p records are the "publication records", which would harvested by Primo. This is described in version
18 rep_change 456. If you don't have Primo (or another OAI-harvester), they are not necessary.

4. As mentioned in KB 8192-2839, the z700 table is used only in the Web ILL. You don't need it.

5. There is no z105 trigger, but the $aleph_root/tab/file_list.Z105 has a z105h_trigger. The z105h is optional, but, if you want to have this history of z105 activity, you should create the z105h trigger using util a/17/6/1 in the $z105_library (which, in your case, is pwd50).

6. Like the z00p table, the LAST_PUBLISH_SEQ is connected to Primo. As can be seen in the alephe_root/tab/file_list.USR, the LAST_PUBLISH_SEQ is in the $usr_library. It is created using util a/17/9/2. If you don't have Primo, it is not necessary.

(keywords: p-manage-111 manage-111 manage_111 p_manage_111 FAQ)

• Article last edited: 10/8/2013