Professional Web Applications Themes

shrink tablespace data file size via re-direction restore? - IBM DB2

Is shrinking tablespace data file size possible via database re-direction restore? Is mergeing or spliting data file possible via database re-direction restore? Suppose ts1 contains 2 data files which are 100M in total, but actualy 40% is used. Can we set tablespace containers to 1 data file which is 50M (50>100*40%)? TIA net...

  1. #1

    Default shrink tablespace data file size via re-direction restore?

    Is shrinking tablespace data file size possible via database
    re-direction restore? Is mergeing or spliting data file possible via
    database re-direction restore?

    Suppose ts1 contains 2 data files which are 100M in total, but actualy
    40% is used. Can we set tablespace containers to 1 data file which is
    50M (50>100*40%)?

    TIA
    net
    James Guest

  2. #2

    Default Re: shrink tablespace data file size via re-direction restore?

    James <net> wrote: 

    Yes, that should be possible. The one thing that you need to keep in mind
    is that it's the high-water-mark -- not the total amount of data -- in the
    tablespace that determines how big the containers have to be. I would
    advise REORGing your data before doing the backup/restore operations to
    squeeze out wasted space.

    dave
    David Guest

  3. #3

    Default Re: shrink tablespace data file size via re-direction restore?

    James wrote:
     

    Also note that if you are running V8, you can reduce the size of your
    tablespace containers with ALTER TABLESPACE. (The same restrictions
    apply with respect to the high water mark).





    -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
    http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
    -----== Over 100,000 Newsgroups - 19 Different Servers! =-----
    Ian Guest

Similar Threads

  1. Help on Shrink IBDATA1 file
    By Roberto Rasto in forum MySQL
    Replies: 1
    Last Post: April 3rd, 09:28 PM
  2. How best to SHRINK large digital photos for email file sizes
    By Eunice Santorini in forum Photography
    Replies: 26
    Last Post: October 1st, 07:29 AM
  3. restore redirect into one tablespace
    By Peter Sands in forum IBM DB2
    Replies: 3
    Last Post: September 17th, 10:17 PM
  4. DROP TABLESPACE does not remove the .ora file
    By Gijo Varghese in forum Oracle Server
    Replies: 0
    Last Post: January 7th, 01:35 PM
  5. Created a tablespace in another database file
    By Peter van Rijn in forum Oracle Server
    Replies: 2
    Last Post: December 10th, 11:49 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139