Professional Web Applications Themes

changing tablespace containers - IBM DB2

Hi, One of our development databases have a few tablespaces that are SMS, that points to ( /home/dbas/..), I want to change these so they point to another filesystem where our DMS tablespaces reside. Can I add another SMS to one of these tablesspaces that points to anohter filesystem, then delete the other SMS that points to (/home/db2as..). OR do I have to do a restore (redirect) to accomplish this. aix 5.2 db2 v 8 thanks Pete...

  1. #1

    Default changing tablespace containers

    Hi,
    One of our development databases have a few tablespaces that are SMS,
    that points to ( /home/dbas/..), I want to change these so they point
    to another filesystem where our DMS tablespaces reside. Can I add
    another SMS to one of these tablesspaces that points to anohter
    filesystem, then delete the other SMS that points to (/home/db2as..).
    OR do I have to do a restore (redirect) to accomplish this.

    aix 5.2
    db2 v 8

    thanks
    Pete
    Peter Sands Guest

  2. #2

    Default Re: changing tablespace containers


    See if db2relocatedb command helps

    Cheers

    Sathyaram

    Originally posted by Peter Sands
    > Hi,
    > One of our development databases have a few tablespaces that are SMS,
    > that points to ( /home/dbas/..), I want to change these so they point
    > to another filesystem where our DMS tablespaces reside. Can I add
    > another SMS to one of these tablesspaces that points to anohter
    > filesystem, then delete the other SMS that points to (/home/db2as..).
    > OR do I have to do a restore (redirect) to accomplish this.
    >
    > aix 5.2
    > db2 v 8
    >
    > thanks
    Pete

    --
    DB2 discussion also at [url]http://www.dbforums.com/f8[/url]


    Posted via [url]http://dbforums.com[/url]
    sathyaram_s Guest

  3. #3

    Default Re: changing tablespace containers



    Peter Sands wrote:
    > Hi,
    > One of our development databases have a few tablespaces that are SMS,
    > that points to ( /home/dbas/..), I want to change these so they point
    > to another filesystem where our DMS tablespaces reside. Can I add
    > another SMS to one of these tablesspaces that points to anohter
    > filesystem, then delete the other SMS that points to (/home/db2as..).
    > OR do I have to do a restore (redirect) to accomplish this.
    >
    > aix 5.2
    > db2 v 8
    >
    > thanks
    > Pete
    If you don't care the data in those SMS tablespaces - it is easy for you
    to rebuild those tables in the other tablespaces, such as you can re-load
    the data ...
    Then you can use the first approach.
    Create new tablespaces which point to the new place; Drop the SMS
    tablespace; Rename the new SMS tablespace as the original one

    If you don't want to reload data, then you can do a redirect restore.

    HTH
    FRX

    Fan Ruo Xin Guest

Similar Threads

  1. The Pan|Zoom component for Containers
    By gabi_poa in forum Macromedia Flex General Discussion
    Replies: 6
    Last Post: July 23rd, 07:46 PM
  2. Help About Navigator Containers(Flex 1.5)
    By isml in forum Macromedia Flex General Discussion
    Replies: 2
    Last Post: March 29th, 01:38 AM
  3. borders and containers
    By dougk in forum Macromedia Flex General Discussion
    Replies: 1
    Last Post: August 12th, 06:39 PM
  4. Web companion and images in containers...
    By Tech in forum FileMaker
    Replies: 2
    Last Post: August 22nd, 11:24 AM
  5. Replies: 11
    Last Post: January 9th, 07:46 PM

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