467,209 Members | 1,352 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,209 developers. It's quick & easy.

DB2 ESE add Partition fail

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
  • viewed: 2036
Share:
3 Replies
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
Raj
try to edit the db2nodes.cfg file..

Feb 27 '06 #3
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.

Similar topics

1 post views Thread by Mark Dengler | last post: by
5 posts views Thread by jamesharring@gmail.com | last post: by
5 posts views Thread by sameer_deshpande | last post: by
25 posts views Thread by John Salerno | last post: by
1 post views Thread by Laurence | last post: by
debasisdas
reply views Thread by debasisdas | last post: by
debasisdas
reply views Thread by debasisdas | last post: by
3 posts views Thread by Justin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.