Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Posts
    14

    Unhappy Unanswered: Delete/Reload of data and tablespaces

    Hi,

    Not a DBA and new to DB2

    Doing a test..

    Deleted 1 million rows from a table, Re-LOADed the same 1 million records in the same table.

    Space used by the table (data and index), did not change, BUT the "Free Space" on the Tablespace is DECREASING.

    Question...

    Does the tablespace gets reused in the future.

    If so, why is it not show as 'Free Space'.

    If not, what can be done to reclaim the space back.

    Thanks in advance.
    M2001

  2. #2
    Join Date
    Nov 2002
    Location
    Rio de Janeiro - Brazil
    Posts
    78

    Re: Delete/Reload of data and tablespaces

    Try reorganizing the table after you reload the records back into the table. And I also suggest you update the table statistics.

    Take a look at the Command Reference for the syntax on the commands REORG TABLE and RUNSTATS.

    HTH,
    Fernando

    Originally posted by M2001
    Hi,

    Not a DBA and new to DB2

    Doing a test..

    Deleted 1 million rows from a table, Re-LOADed the same 1 million records in the same table.

    Space used by the table (data and index), did not change, BUT the "Free Space" on the Tablespace is DECREASING.

    Question...

    Does the tablespace gets reused in the future.

    If so, why is it not show as 'Free Space'.

    If not, what can be done to reclaim the space back.

    Thanks in advance.

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Delete/Reload of data and tablespaces

    My thought is to REORG the table before the 're-LOAD' ...

    Am I missing something obvious ?

    Cheers

    Sathyaram


    Originally posted by F.OHANA
    Try reorganizing the table after you reload the records back into the table. And I also suggest you update the table statistics.

    Take a look at the Command Reference for the syntax on the commands REORG TABLE and RUNSTATS.

    HTH,
    Fernando

  4. #4
    Join Date
    Jan 2003
    Posts
    14

    Thumbs up Re: Delete/Reload of data and tablespaces

    REORGed the table and was able to free the used Tablespace.. Thanks.
    M2001

Posting Permissions

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