If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > add dbpartitionnum

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-23-08, 01:57
ashok_as6 ashok_as6 is offline
Registered User
 
Join Date: Dec 2008
Posts: 6
add dbpartitionnum

Hi,

we are trying to create a partitioned database server with 4 partitions using ver 8 on win XP.

Installed the db2 software. Whats the next step?
Reply With Quote
  #2 (permalink)  
Old 12-23-08, 03:33
nick.ncs nick.ncs is offline
Registered User
 
Join Date: May 2007
Location: somewhere in dbforums
Posts: 221
The next step is go to DB2 information center and search for "create database".... there you will find the required data.

OR

Go to google and search for something like create partitioned database db2 and you'll get the required tutorials to get you through


After doing the above steps you still have issues then you are most welcome to post the same here...

However if you are too lazy to do even the above mentioned steps then i recommend you check the uninstall DB2 option available in Add/Remove programs....
__________________
IBM Certified Database Associate, DB2 9 for LUW
Reply With Quote
  #3 (permalink)  
Old 12-23-08, 03:41
ashok_as6 ashok_as6 is offline
Registered User
 
Join Date: Dec 2008
Posts: 6
Quote:
Originally Posted by nick.ncs
The next step is go to DB2 information center and search for "create database".... there you will find the required data.

OR

Go to google and search for something like create partitioned database db2 and you'll get the required tutorials to get you through


After doing the above steps you still have issues then you are most welcome to post the same here...

However if you are too lazy to do even the above mentioned steps then i recommend you check the uninstall DB2 option available in Add/Remove programs....

sir i know how to create a database

but i dont know how to create partitioned datsbase
i searched in db2ic also but they given "db2node.cfg" i could not found it.
this db2node.cfg is "db2 list node directory" result?
even i know how to ctalaog a node ,but the reason why unable to creat partion is i dont know how to add partitionnum .i have excute the comment "db2start add dbpartitionu " with hostname,node name,user,password but im getting error

could u please guide me the steps

Last edited by ashok_as6; 12-23-08 at 03:52.
Reply With Quote
  #4 (permalink)  
Old 12-23-08, 04:52
nick.ncs nick.ncs is offline
Registered User
 
Join Date: May 2007
Location: somewhere in dbforums
Posts: 221
Quote:
Originally Posted by ashok_as6
sir i know how to create a database
but i dont know how to create partitioned datsbase
Thats why i said check the create database command

Quote:
Originally Posted by ashok_as6
i searched in db2ic also but they given "db2node.cfg" i could not found it.
this db2node.cfg is "db2 list node directory" result?
No, it is not... if you had read the create database command you would have known that it simply lists the database partitions

Quote:
Originally Posted by ashok_as6
even i know how to ctalaog a node ,but the reason why unable to creat partion is i dont know how to add partitionnum .i have excute the comment "db2start add dbpartitionu " with hostname,node name,user,password but im getting error
Add dbpartitionnum is used to add a partition to an already existing partitioned db. Do you already have an existing partitioned db?

Kindly state in clear terms what you are doing and then maybe we can help.
__________________
IBM Certified Database Associate, DB2 9 for LUW
Reply With Quote
  #5 (permalink)  
Old 12-23-08, 04:56
ashok_as6 ashok_as6 is offline
Registered User
 
Join Date: Dec 2008
Posts: 6
Quote:
Originally Posted by nick.ncs
Thats why i said check the create database command



No, it is not... if you had read the create database command you would have known that it simply lists the database partitions



Add dbpartitionnum is used to add a partition to an already existing partitioned db. Do you already have an existing partitioned db?

Kindly state in clear terms what you are doing and then maybe we can help.

actualy i want to create a database .its data has to be get stored in different node
Reply With Quote
  #6 (permalink)  
Old 12-23-08, 05:28
stolze stolze is offline
Registered User
 
Join Date: Jan 2007
Location: Jena, Germany
Posts: 2,662
First you have to define the partitions that belong to your instance. Have a look at the START DATABASE MANAGER command (aka DB2START):
Quote:
$ db2 "? start"
{START DATABASE MANAGER | DB2START} [REMOTE [INSTANCE] instance-name
{ADMINNODE node-name | HOSTNAME hostname} USER username USING password]
[ADMIN MODE {USER username | GROUP groupname }] [PROFILE profile]
[DBPARTITIONNUM db-partition-number] [ADD DBPARTITIONNUM HOSTNAME hostname
PORT logical-port [COMPUTER computer-name] [USER username] [PASSWORD password]

[NETNAME netname] [LIKE DBPARTITIONNUM db-partition-number |
WITHOUT TABLESPACES]] | STANDALONE | RESTART [HOSTNAME hostname]
[PORT logical-port] [COMPUTER computer-name] [USER username] [PASSWORD password]
[NETNAME netname] ] ]
Once you have that, you can proceed with creating the database. (Of course, you can also add new partitions once the database exists, but doing it the way I described is probably easier because you do not have to reconfigure anything in the database itself because it does not yet exist when setting up the instance partitions.)
__________________
Knut Stolze
IBM DB2 Analytics Accelerator
IBM Germany Research & Development
Reply With Quote
  #7 (permalink)  
Old 12-23-08, 05:36
ashok_as6 ashok_as6 is offline
Registered User
 
Join Date: Dec 2008
Posts: 6
Quote:
Originally Posted by stolze
First you have to define the partitions that belong to your instance. Have a look at the START DATABASE MANAGER command (aka DB2START):


Once you have that, you can proceed with creating the database. (Of course, you can also add new partitions once the database exists, but doing it the way I described is probably easier because you do not have to reconfigure anything in the database itself because it does not yet exist when setting up the instance partitions.)
thanks sir i will get back to u if any error occured
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On