By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,924 Members | 1,686 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,924 IT Pros & Developers. It's quick & easy.

DB2 ESE add Partition fail

P: n/a
I just downloaded DB2 Enterprise Server Edition evaluation copy.
Installed on Windows 2000 professional.

I want to test 1 physical machine with 1 logical partition.
db2start dbpartitionnum 1 add dbpartitionnum hostname myserver port 1
without tablespaces
SQL1096N The command is not valid for this node type.

db2ncrt /n:1 /u:admin,pwd
or
db2nlist

SQL2811N The command is invalid because the instance is not a
partitioned database instance.
Do I need to get some extra license for DPF?
Thanks.

Feb 27 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
sh*******@gmail.com wrote:
I just downloaded DB2 Enterprise Server Edition evaluation copy.
Installed on Windows 2000 professional.

I want to test 1 physical machine with 1 logical partition.
db2start dbpartitionnum 1 add dbpartitionnum hostname myserver port 1
without tablespaces
SQL1096N The command is not valid for this node type.

db2ncrt /n:1 /u:admin,pwd
or
db2nlist

SQL2811N The command is invalid because the instance is not a
partitioned database instance.
Do I need to get some extra license for DPF?
Thanks.

Yes ... beginning with 8.2.

Larry Edelstein
Feb 27 '06 #2

P: n/a
Raj
try to edit the db2nodes.cfg file..

Feb 27 '06 #3

P: n/a
sh*******@gmail.com wrote:
I just downloaded DB2 Enterprise Server Edition evaluation copy.
Installed on Windows 2000 professional.

I want to test 1 physical machine with 1 logical partition.
db2start dbpartitionnum 1 add dbpartitionnum hostname myserver port 1
without tablespaces
SQL1096N The command is not valid for this node type.


You already have 1 logical partition. The command you entered tries to
create a second one. And there the question is if you configured your
ports correctly.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Feb 27 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.