Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2007
    Posts
    55

    Unanswered: Alter tablespace <tbspace name> reduce max

    I'm on 9.7 FP2 and looking at running on ALTER TABLESPACE USERSPACE1 REDUCE MAX (it's an automatic storage tbsp) on a 900 gig database. Other than having a backup and not running backups or perhaps during business hours when this runs, are there any other potential issues with running this?

    The drive has 300 gig free and about 400 gig will be freed up with running it.

  2. #2
    Join Date
    Feb 2007
    Posts
    55
    I ran this on a dev box on one database and it seemed ok. Of course it only has one or two users on it compared to 100+ on prod.

  3. #3
    Join Date
    Jun 2017
    Posts
    9
    Provided Answers: 1
    One other thing before reducing max you might want to reorg to reclaim some space first if you can. The reorg you might want to do with the db offline if you can.

  4. #4
    Join Date
    Aug 2016
    Posts
    55
    Provided Answers: 2
    reorg (offline or online ) based on fpages and npages in syscat.tables
    alter tablespace lower high water mark

    assumed above is performed.

    You can execute alter tablespace reduce max online it fast compare to above 2

    regds
    paul

Posting Permissions

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