Cannot Execute Create Server

[fyi85]

I am trying to create a server on the same machine running the same
instance.
This is v8.1.5 on Windows 2003 Server.
The instance is set to FEDERATED=YES
The server will be created for database TEST
The TEST database will be referenced from database master.
There is nobody using the databases and there are no active
connections.

I log on to the database master from CLP and do
db2 create wrapper DRDA-this succeeds
db2 commit

then try and create the server by executing a batch file which contains
this line:
db2 -v create server test type DB2/UDB VERSION '8.1' wrapper "DRDA"
authid "somebody" password \"password\" (add dbname 'TEST', password
'Y')
the user had bindadd authority on database C100.

the clp comes back with
IBM][CLI Driver][DB2/NT] SQL1822N Unexpected error code "08001"
received from data source "TEST". Associated text and tokens
are "func="DriverConnect" msg=" SQL1246N Connection settings
ca". SQLSTATE=560BD

and db2diag says
DRDA Server:
0x06473C70 : 0x54534554 TEST

2006-02-23-14.39.42.646004 Instance:DB2 Node:000
PID:2244(db2syscs.exe) TID:2220 Appid:*LOCAL.DB2.019203193830
drda wrapper get_error_info Probe:2 Database:MASTER

Function name:
0x063883B8 : 4472 6976 6572 436F 6E6E 6563 74 DriverConnect

2006-02-23-14.39.42.656000 Instance:DB2 Node:000
PID:2244(db2syscs.exe) TID:2220 Appid:*LOCAL.DB2.019203193830
drda wrapper get_error_info Probe:3 Database:MASTER

ODBC native err:
0x05C99370 : 2D31 3234 36 -1246

2006-02-23-14.39.42.816000 Instance:DB2 Node:000
PID:2244(db2syscs.exe) TID:2220 Appid:*LOCAL.DB2.019203193830
drda wrapper get_error_info Probe:4 Database:MASTER

ODBC sqlstate:
0x05C99361 : 3038 3030 3100 08001.

2006-02-23-14.39.42.816001 Instance:DB2 Node:000
PID:2244(db2syscs.exe) TID:2220 Appid:*LOCAL.DB2.019203193830
drda wrapper get_error_info Probe:5 Database:MASTER

ODBC error txt:
0x05C98F60 : 5B49 424D 5D5B 434C 4920 4472 6976 6572 [IBM][CLI
Driver
0x05C98F70 : 5D20 5351 4C31 3234 364E 2020 436F 6E6E ] SQL1246N
Conn
0x05C98F80 : 6563 7469 6F6E 2073 6574 7469 6E67 7320 ection settings
0x05C98F90 : 6361 6E6E 6F74 2062 6520 6368 616E 6765 cannot be
change
0x05C98FA0 : 6420 7768 696C 6520 636F 6E6E 6563 7469 d while
connecti
0x05C98FB0 : 6F6E 7320 6578 6973 742E 0D0A ons exist...

GRRRRR! How can this message be right? Any ideas to get CREATE SERVER
to work will be much appreciated.

[Knut Stolze]

fy***@hotmail.com wrote:

I am trying to create a server on the same machine running the same
instance.
This is v8.1.5 on Windows 2003 Server.
The instance is set to FEDERATED=YES
The server will be created for database TEST
The TEST database will be referenced from database master.
There is nobody using the databases and there are no active
connections.

I log on to the database master from CLP and do
db2 create wrapper DRDA-this succeeds
db2 commit

then try and create the server by executing a batch file which contains
this line:
db2 -v create server test type DB2/UDB VERSION '8.1' wrapper "DRDA"
authid "somebody" password \"password\" (add dbname 'TEST', password
'Y')
the user had bindadd authority on database C100.

the clp comes back with
IBM][CLI Driver][DB2/NT] SQL1822N Unexpected error code "08001"
received from data source "TEST". Associated text and tokens
are "func="DriverConnect" msg=" SQL1246N Connection settings
ca". SQLSTATE=560BD

GRRRRR! How can this message be right? Any ideas to get CREATE SERVER
to work will be much appreciated.

Just guessing but are there any other connections to the foreign database?
Have you tried to shut down both instances to really force all other
connections off, then restart both and try again the CREATE SERVER?

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[fyi85]

Hi Kurt
Both db's are running under the same instance.
I have tried:
--stopping and starting the instance.
--creating the wrapper and server from control center, control center
generates the same message on create server
--changing usernames other than instance owner
--modifying db2cli.ini (I had patch 32 entry)
--rebinding the cli utilities from odbc datasource in windows
administrative tools
--trying the same commands on other server running win2k advanced
server (same result)
--funny thing is, create server works just fine on EEE instance, doesnt
seem to work on EE instance

Knut Stolze wrote:

fy***@hotmail.com wrote:

I am trying to create a server on the same machine running the same
instance.
This is v8.1.5 on Windows 2003 Server.
The instance is set to FEDERATED=YES
The server will be created for database TEST
The TEST database will be referenced from database master.
There is nobody using the databases and there are no active
connections.

I log on to the database master from CLP and do
db2 create wrapper DRDA-this succeeds
db2 commit

then try and create the server by executing a batch file which contains
this line:
db2 -v create server test type DB2/UDB VERSION '8.1' wrapper "DRDA"

Just guessing but are there any other connections to the foreign database?
Have you tried to shut down both instances to really force all other
connections off, then restart both and try again the CREATE SERVER?

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[Shashi Mannepalli]

On another Note

1. Did u catalog these databases remotely ? Meaning
From Server1 to Server2 database ?
Try that and do a connect test to that database .....use the same
password and id u are using to create the server

if this is working then your CREATE SERVER should work.

cheers...
Shashi Mannepalli