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

Description:
We would like to create z00r tables for our authority libraries abc10 and abc11, for statistical purposes.

Following KB Item 5870, we see that the steps to follow are:

1 - add appropriate lines for z00r to the abc10 and abc11 file_list;
2 - run util a/17/1 to create the Oracle tables and indexes;
3 - set CREATE-Z00R to Y in abc10 and abc11 tab100;
4 - run p_manage_07 for 'Update only Z00R' in each library.

We run into a problem at step 1.

Lines for z00r and its indexes exist in /exlibris/aleph/a20_2/aleph/tab/file_list.BIB:

TAB z00r 100K,128K,4M,128M,128K,128K 0K ts0,TS1D,TS2D,TS3D,TS1D,TS1D
IND z00r_id 100K,128K,4M,4M,128K,128K 0K ts1,TS1X,TS2X,TS2X,TS1X,TS1X
IND z00r_id1 100K,128K,4M,4M,128K,128K 0K ts1,TS1X,TS2X,TS2X,TS1X,TS1X

If we add those lines to .../abc10/file_list, we get this error when we try to run util a/17/1:

*********************************
Enter value for 4: STORAGE (INITIAL 100K,128K,4M,1280K128K,128K NEXT ts0,TS1D,TS2D,TS3D,TS1D,TS1D MINEXTENTS 1 PCTINCREASE 0)
*
ERROR at line 8:
ORA-02143: invalid STORAGE option

...

aleph_admin@ALEPH20> 11:25:48 aleph_admin@ALEPH20> Enter value for 4: STORAGE (INITIAL 100K,128K,4M,4M,0K8K,128K NEXT ts1,TS1X,TS2X,TS2X,TS1X,TS1X MINEXTENTS 1 PCTINCREASE 0)
*
ERROR at line 2:
ORA-02143: invalid STORAGE option
**********************************

How can we properly configure the file_list to make util a/17/1 work?

Resolution:
You cannot copy a line from an ./aleph/tab/file_list.xxx to a $data_root file_list (such as, ./abc10/file_list). It's *not* in the proper format.

You have two choices:

1. copy the lines from ./aleph/tab/file_list.BIB to ./aleph/tab/file_list.AUT ; or

2. insert file_list entries in the proper form into the ./abc10/file_list, such as:

TAB z00r 128K 0K TS1D
IND z00r_id 128K 0K TS1X
IND z00r_id1 128K 0K TS1X

• Article last edited: 10/8/2013