Skip to Content
avatar image
Former Member

Tablespace Reorg - Reduced space not reflecting at OS HP-UX

Hi,

I have Followed the procedure in SAP Note: 646681(Section IV) to

perform a Tablespace Reorg. I have choosed PSAPBTABD & PSAPBTABI for

Reorg and completed Successfuly. The DB Size of 1.6TB was reduced to

1.3 which released the free space of 363GB from the Database. I Could

see the difference in Size at DB02(SAP Level), But it is not reflecting

at OS level(HP-UX) after droping the old Tablespace. Tablespace became

99%. All filesystems shows full when "bdf" executed. Please Advice.

Thanks

Prasad

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Apr 12, 2011 at 02:49 PM

    But it is not reflecting at OS level(HP-UX) after droping the old Tablespace.

    This probably means you didn't drop with including datafiles thus the files are still there. Before deleting the files double check the timestamp, all files should have more or less current modification timestamps when the db is running. The leftover files should have the timpstamp from the drop tablespace command. Only delete files you are sure they don't belong to an active tablespace.

    Cheers Michael

    Add comment
    10|10000 characters needed characters exceeded