Results 1 to 10 of 10
  1. #1
    Join Date
    Sep 2003
    Posts
    85

    Unanswered: Drop Table Reclaim Space

    During DROP TABLE activity which will remove catalog info relating to the table, DBA thought that also the pages in the tablespace would be reclaimed at the timr of the DROP.
    Corret or incorrect?
    DBA seems to be getting tablespace full condition despite having dropped the table. We're at UDB 8.1.3 64-bit.
    TIA,
    Ruby

  2. #2
    Join Date
    Mar 2003
    Posts
    343
    Are you using dms tablespaces?

  3. #3
    Join Date
    Sep 2003
    Posts
    85
    DMS tablespaces are used.

  4. #4
    Join Date
    Mar 2003
    Posts
    343
    Do you have multiple tables in the tablespace?

  5. #5
    Join Date
    Sep 2003
    Posts
    85
    Yes, multiple tables in the tablespace.

  6. #6
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Reorg

    Hi,

    Try asking the dba to use reorg command that will definitely reclaim as much as space as possible.

    Regards

    nitin.
    HTH

    Nitin

    Ask the experienced rather than the learned

  7. #7
    Join Date
    Dec 2002
    Posts
    58

    Re: Reorg

    Originally posted by nitingm
    Hi,

    Try asking the dba to use reorg command that will definitely reclaim as much as space as possible.

    Regards

    nitin.
    Hi ,

    Perhaps a very stupid question, but if a table is dropped, how can you do a reorg on it ? Can you do a reorg on a tablespace ?

    I hope someone can answer this because I am struggling with the same problems ...

  8. #8
    Join Date
    Sep 2003
    Posts
    85
    Reorg the dropped table?

  9. #9
    Join Date
    Dec 2002
    Posts
    58
    Originally posted by rubystep
    Reorg the dropped table?
    This results in the following message :
    SQL2211N The specified table does not exist.

  10. #10
    Join Date
    Mar 2003
    Posts
    343
    No, reorg all other tables in the tablespace.

Posting Permissions

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