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

Description:
I've run thorugh the parallel indexing document a number of times and run p_manage_01. If I look at the files directly in Oracle, there are lots of entries so it seems that the parallel indexing job ran fine. However, I cannot use the library in either the client or web-opac to run word searches. In the client I get zero results, in the opac it just hangs. Apparently I have missed something but I'm stuck. I have not tried to apply the new index yet, I wanted to make sure that I could check things in the opac first.

Resolution:
I find that the abc21 z98_id does not exist:

Enter Table Name : z98

Defined in file_list:
__________________________________________________________
IND z98_id 128M 0K TS3X
__________________________________________________________


Exist in the Database:

Enter CR to continue...


When I tried to build the z98_id using util a/17/2, I got this:


CREATE UNIQUE INDEX ABC21.Z98_ID ON ABC21.Z98 (Z98_REC_KEY ASC)
*
ERROR at line 1:
ORA-01652: unable to extend temp segment by 512 in tablespace TS3X


util o/14/1 shows this:

TABLESPACE_NAME TOTAL_FREE_SPACE MAX_EXTENT NUM_FREE_EXTENTS
------------------------------ ---------------- ---------- ----------------
TS3X 284.156092 112.061557 3


And util a/17/10/2 shows this:

IND z98_id 128M 0K TS3X

The largest available extent in the TS3X tablespace is 112M and the z98_id is looking for 128M.

You need to add another datafile to the TS3X tablespace -- and then run util a/17/2 for z98_id.