What Oracle tables are really needed

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

Article Type: General
Product: Aleph
Product Version: 18.01

Description:
I've looked at the file_list info in /exlibris/aleph/a18_1/aleph/tab, and these give a laundry list of all of the *possible* Oracle tables for a given library. But how do I determine what I really *need* in each library?

For instance, there are no Browse or Word indexes for an ADM library, so why should the tables z01, z02, z95, z97, z98 and z980 be created?

Another really odd one is the Z13 table in the holdings library. I find that I have such a table in my Aleph 16 ABC60 library and it even has something in it, but where did those records come from? They are certainly not complete because I never ran p_manage_07 against the Holdings library, so I'm guessing that this is data from a ue background job, but is it actually used? If not, why do I have this table?

I'd like to see a more clear picture of what *really* needs to be created for what functionality so that I can create only those tables I need and not clutter up the database with unnecessary, empty tables that are not needed.

Resolution:
The only tables you absolutely *must* have in an ADM library are the z00 and z103. The other tables depend on what functions you are performing. This *could* include building Browse or Word indexes.

KB 8192-2329 describes what tables are updated immediately when a doc record is created/updated and what tables are updated by ue_01.

Three tables (z00r, z120, and z127) have explicit tab100 flags allowing you to say that the table does not exist for this library. For other tables, if the table doesn't exist, you will get an error message.

In addition, if you don't run ue_01 in a library, then the system will not attempt to update the tables which are updated only by ue_01 (z01, z02, z0101, z0102, z101, z105, z91, z95, z97, z98).

You need to consider your own case. If you don't have any Browse or Word index, as you describe, you don't need the z01, z02, z0101, z0102, z95, z97, z98 or z980. (And if you don't run ue_01 in the library, you won't get any error message. See KB 8192-3944 in regard to not running ue_01.)

In regard to the HOL z13, when an HOL record is sent to the server, if the Z13 table exists, it will update it ... regardless of whether the complete p_manage_07 was run previously. I can't think of any way in which the system uses the xxx60 z13.

Article last edited: 10/8/2013