Skip to main content
ExLibris

  • Subscribe by RSS
    • Aleph
    Ex Libris Knowledge Center

    www_server error: unable to extend index XXX01.Z35_ID by 512 in tablespace TS

    1. Last updated
      18:18, 1 Mar 2016
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 20, 21, 22, 23

    Problem Symptoms:
    In the $LOGDIR/www_server_4991.log file we are getting these oracle errors:

    Oracle error: io_z35_write
    ORA-01654: unable to extend index xxx01.Z35_ID by 512 in tablespace TS

    Oracle error: io_z69_write
    ORA-01654: unable to extend index xxx01.Z69_ID1 by 512 in tablespace TS

    Cause:
    Tablespace TSx is out of space.

    Resolution:
    {See Article 3985 ("Execution error: file '/exlibris/aleph/a18_1/aleph/exe/ue_21_a.gnt' in run_e_21") in regard to identifying the tablespace the index resides in.)

    util o/14/1 showed that tablespace TSX had less than 1 meg of space.

    Using util o/13/1 and util o/13/3, a datafile was added to tablespace TSX.  (This should be done by the database administrator.  In a TWO_TASK (or Three-task) environment, util o/13/1 and util o/13/3 don't work and  the datafile must be added by the database administrator.)

    As described in Article 000013963 ("z35 vs. z69: z35_event_type's and what z69 includes"), the z35 table is unnecessary in the bib library. It was occupying 1.4 gig. Therefore, we did util a/17/1 in XXX01 to empty it. (Note: the z35 in XXX50 should *not* be dropped in this fashion.)

    Category: System Management (500)

    Subject: Oracle (500)

    • Article last edited: 01-Mar-2016