add dbpartitionnum

[Stefan S.]

Hello,
we have a Win2000 environment with DB2V8 FP3 ESE. We try to creaate an
Instance on 2 physical nodes.

db2start dbpartitionnum 1 add dbpartitionnum hostname bm-nb16 port 0
computer bm-nb16 user domainUid password passpword

We get following Error: SQL6073N add node operation failed SQLCODE
-1092

On the second host we found, after the command, an entry in
etc/services.
The second computer is doing something ?!

DomainUid is part of the db2-Admin Group. The user is also part of
each local Admin Group.

Any Idea????

Thanks in advance
Stefan

[Knut Stolze]

Stefan S. <st**************@cimt-ag.de> wrote:

Hello,
we have a Win2000 environment with DB2V8 FP3 ESE. We try to creaate an
Instance on 2 physical nodes.

db2start dbpartitionnum 1 add dbpartitionnum hostname bm-nb16 port 0
computer bm-nb16 user domainUid password passpword

We get following Error: SQL6073N add node operation failed SQLCODE
-1092

On the second host we found, after the command, an entry in
etc/services.
The second computer is doing something ?!

DomainUid is part of the db2-Admin Group. The user is also part of
each local Admin Group.

Any Idea????

You might want to put quotes around the user name and password strings
because:

$ db2 "? sql1092"

SQL1092N "<authorization-ID>" does not have the authority to
perform the requested command.

Explanation:

The user attempted to execute a command or operation without
having the proper authority for that command or operation.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena

[Garfield Lewis]

If this is still a problem can you send me a trace from the machine that
partition 1 is to being created?

--
Garfield A. Lewis
DB2 UDB Development,
IBM Canada Laboratory
"Knut Stolze" <st****@de.ibm.com> wrote in message
news:bu**********@fsuj29.rz.uni-jena.de...

Stefan S. <st**************@cimt-ag.de> wrote:

Hello,
we have a Win2000 environment with DB2V8 FP3 ESE. We try to creaate an
Instance on 2 physical nodes.

db2start dbpartitionnum 1 add dbpartitionnum hostname bm-nb16 port 0
computer bm-nb16 user domainUid password passpword

We get following Error: SQL6073N add node operation failed SQLCODE
-1092

On the second host we found, after the command, an entry in
etc/services.
The second computer is doing something ?!

DomainUid is part of the db2-Admin Group. The user is also part of
each local Admin Group.

Any Idea????

You might want to put quotes around the user name and password strings
because:

$ db2 "? sql1092"

SQL1092N "<authorization-ID>" does not have the authority to
perform the requested command.

Explanation:

The user attempted to execute a command or operation without
having the proper authority for that command or operation.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena