Results 1 to 3 of 3

Thread: reorg fails

  1. #1
    Join Date
    May 2003
    Posts
    369

    Unanswered: reorg fails

    In our DB2 UDB 7.2+FP6 database on AIX 5.2L I am trying to
    reorg a table to free up page space on a table and get

    SQL2216N SQL error "-289" occurred while reorganizing a database table.

    Is this because the table is out of paging space? Would I need to reorg with a temp table? Thanks

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Sounds like you are out of space. Try adding another container.

  3. #3
    Join Date
    May 2003
    Posts
    369

    problem solved

    yep was out of paging space. I found another tempspace to use and it ran fine.

    db2 reorgchk first to find what indexes adn tables need reog then

    db2 reorg table db2inst1.tablename use tempspace2

Posting Permissions

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