Results 1 to 7 of 7

Thread: Reorg error

  1. #1
    Join Date
    Jun 2004
    Posts
    12

    Unanswered: Reorg error

    I am trying to reorg a table and I am getting a error

    SQL2216N SQL error "-968" occured while reorganising a database table or its indexes.

    I tried different possibilities but I am unable to solve it.

    It's giving a message in my diaglog that the "disk is full"

    Can you suggest me anything with this?

    Thanks in advance
    milee

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    You are probably running out of temporary space. Check to see if there's enough space on the device hosting temporary TS container(s).

    SQL0968C The file system is full.

    Explanation:

    One of the file systems containing the database is full. This
    file system may contain the database directory, the database log
    files, or a table space container.

    The statement cannot be processed.

    User Response:

    Free system space by erasing unwanted files. Do not erase
    database files. If additional space is required, it may be
    necessary to drop tables and indexes identified as not
    required.

    On unix-based systems, this disk full condition may be due to
    exceeding the maximum file size allowed for the current userid.
    Use the chuser command to update fsize. A reboot may be
    necessary.

    This disk full condition may be caused when containers are of
    varying sizes. If there is sufficient space in the file system,
    drop the table space and recreate it with containers of equal
    size.

    sqlcode : -968

    sqlstate : 57011

  3. #3
    Join Date
    Jun 2004
    Posts
    12
    I checked with the temp tablespace and and the containers in the tablespaces too. We have only 1 container in every tablespace according to our business rules so ther's no point of that error.
    I am able to reorg some tables in the same tablespace while some are not being reorged.(without & with using "use <tablespacename>")
    I am not able to figure out what the problem is.

  4. #4
    Join Date
    Aug 2004
    Posts
    138
    can u do df-k and let me know how much free space left in the file system for temp tabspace? and also tablesize?

    There should be double the space of the tablesize in tempspace for the reorg to be successful..so u have two options..create a new temp tablespace using new filesystem...or ask your system admin to add more space to u'r current filesystem.
    Last edited by chavadb2; 09-21-04 at 13:32.

  5. #5
    Join Date
    Jun 2004
    Posts
    12
    Thanks for your advice.But all that stuff is already done but still we have no improvement.

    Thanks in advance
    sharmilee.

  6. #6
    Join Date
    Aug 2004
    Posts
    138
    did u try reorg with cleanup only option?
    did it work on these tables?

  7. #7
    Join Date
    Jun 2004
    Posts
    12

    Question

    I think cleanup option is for indexes and I didn't have any problem with reorging indexes. My problem is with tables and not all tables. I am not able to reorg not only large tables but also tables that have only 500 or so rows in it which don't require much space to reorg. Some tables were reorged without any problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •