Professional Web Applications Themes

How to convert from Non-Partitioned to partitioned db - IBM DB2

Dear Group! I have created a db2 database as non-partitioned database. Now I want to make this database a partitioned db add another databse partition to the same instance on the same server(logical partition). How do I achieve this? Thanks,...

  1. #1

    Default How to convert from Non-Partitioned to partitioned db

    Dear Group!

    I have created a db2 database as non-partitioned database. Now I want
    to make this database a partitioned db add another databse partition
    to the same instance on the same server(logical partition). How do I
    achieve this?

    Thanks,
    Prince Guest

  2. #2

    Default Re: How to convert from Non-Partitioned to partitioned db

    Have a look at the command ADD DBPARTITIONNUM (called ADD NODEGROUP in
    v7 and earlier, I think). If you're on v7, you need EEE installed. If
    you're on v8, you need the Distributed Partitioning Feature (DPF) License.

    Prince Kumar wrote:
     

    Blair Guest

  3. #3

    Default Re: How to convert from Non-Partitioned to partitioned db

    Thanks Blair for your response.

    I have already tried this. But I am getting the following error.

    % db2 add DBPARTITIONNUM like DBPARTITIONNUM 0
    SQL2032N The "TABLESPACE NODE" parameter is not valid.

    I looked at the error code in the message reference, but couln't make
    much sense out of it.

    Regards,
    Prince.

    Blair Adamache <> wrote in message news:<blp2q4$6dq$torolab.ibm.com>... [/ref]
    Prince Guest

  4. #4

    Default Re: How to convert from Non-Partitioned to partitioned db

    Prince Kumar wrote: 

    Prince,

    Adding nodes is not a "simple" task. You should read through the
    Admin Guide to understand what's necessary, and read the Command
    Reference to understand the full syntax of the ADD DBPARTITIONNUM
    command.

    There is a wizard in control center to do this, but I have not used
    it before.


    Good luck,



    -----= 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

  5. #5

    Default Re: How to convert from Non-Partitioned to partitioned db

    Thanks Ian,

    I was working with DB2 a few years back and am currently working on
    Oracle. I went thru the admin guide first, before posting it. May be,
    if I read it couple of times (and some other related manuals), I may
    find the solution.

    There might have been many people in the forum who has alreay done
    this and may have a better idea. That is the reason, I tried the
    forum.

    Prince.

    Ian <com> wrote in message news:<3f807035$newsgroups.com>... 
    >
    > Prince,
    >
    > Adding nodes is not a "simple" task. You should read through the
    > Admin Guide to understand what's necessary, and read the Command
    > Reference to understand the full syntax of the ADD DBPARTITIONNUM
    > command.
    >
    > There is a wizard in control center to do this, but I have not used
    > it before.
    >
    >
    > Good luck,
    >
    >
    >
    > -----= 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! =-----[/ref]
    Prince Guest

  6. #6

    Default Re: How to convert from Non-Partitioned to partitioned db

    Thanks everyone!

    My rsh was not running and was causing most of the issues.


    com (Prince Kumar) wrote in message news:<google.com>... 
    > >
    > > Prince,
    > >
    > > Adding nodes is not a "simple" task. You should read through the
    > > Admin Guide to understand what's necessary, and read the Command
    > > Reference to understand the full syntax of the ADD DBPARTITIONNUM
    > > command.
    > >
    > > There is a wizard in control center to do this, but I have not used
    > > it before.
    > >
    > >
    > > Good luck,
    > >
    > >
    > >
    > > -----= 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! =-----[/ref][/ref]
    Prince Guest

Similar Threads

  1. Partitioned views
    By Amrit in forum IBM DB2
    Replies: 2
    Last Post: August 25th, 07:06 PM
  2. Resizing the partitioned C Drive??
    By Bob Pearce in forum Windows Setup, Administration & Security
    Replies: 1
    Last Post: July 23rd, 08:14 AM
  3. Partitioned View Question
    By Jane Kelly in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 12th, 11:40 AM
  4. Help!! Partitioned HD lost driver: how to recover files???
    By steven partridge in forum Mac Applications & Software
    Replies: 3
    Last Post: July 3rd, 10:46 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