Results 1 to 2 of 2
  1. #1
    Join Date
    May 2008

    Unanswered: SQL Message: SQL2216N SQLerror "-968" occurred while reorganizing

    Hi all,
    I am a pretty new to DB2 and I need help.
    Reorg process of one of the tables failed with this error message:

    Reorg_Table: SQL Message: SQL2216N SQLerror "-968" occurred while reorganizing.

    The table that I tried to reorg is over 12GB of size and it was offline reorg with using temporary table space.
    Did it fail because of insufficient size of the temporary table space?
    And if 'Yes' then what needs to be done to fix the problem?

    Thank you in advance,


  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    The file system is full.
    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 
    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
    "It does not work" is not a valid problem statement.

Posting Permissions

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