Guest_imported
New member
- Jan 1, 1970
- 0
I am trying to partition my database (DB2 EE 7.2 running on Win2000). Meanwhile, I have only one node (0). I want to add another node under the same instance with
db2start addnode ....
However, it always fails with an error:
SQL1096N: The command is not valid for this node type.
Another command that is supposed to create multiple logical partitions on WinNT (db2ncrt) does not exist at all!?
I also checked that db2nodes.cfg file does not exist in SQLLIB directory. I can create it myself, but it does not have any affect on DB2 instance (db2stop + db2start does not help)
What can be wrong? May be I need DB2 Enterprise Extended Edition (EEE) for that (I installed regular EE)? or it works only for mutliprocessor machines?
Thanks,
Michael
db2start addnode ....
However, it always fails with an error:
SQL1096N: The command is not valid for this node type.
Another command that is supposed to create multiple logical partitions on WinNT (db2ncrt) does not exist at all!?
I also checked that db2nodes.cfg file does not exist in SQLLIB directory. I can create it myself, but it does not have any affect on DB2 instance (db2stop + db2start does not help)
What can be wrong? May be I need DB2 Enterprise Extended Edition (EEE) for that (I installed regular EE)? or it works only for mutliprocessor machines?
Thanks,
Michael