Hi All,
Im having problems setting up the federated database. The commands Im
using are as follows:
CATALOG TCPIP NODE 'FSYS1' REMOTE <ip> SERVER <port>
CREATE SERVER svr_docket TYPE DB2/LINUX VERSION 7.1.0 WRAPPER DRDA
AUTHORIZATION usr1 PASSWORD "usr1pwd" OPTIONS (NODE 'feddb1', DBNAME
'docket' )
CREATE USER MAPPING FOR USER SERVER svr_docket OPTIONS
(REMOTE_AUTHID 'usr1', REMOTE_PASSWORD ' usr1pwd ')
CREATE NICKNAME docket_test FOR svr_docket.test_table
The error message is generated by the last command, CREATE NICKNAME,
is
db2 => Create nickname docket_test for svr_docket.test_table
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL1101N Remote database "docket" on node "feddb1" could not be
accessed with
the specified authorization id and password.
I believe the username and password in the 'CREATE SERVER' are
correct, If I user the incorrect apsswords the command fails. So Im
assuming its the username and password in the CREATE USER MAPPING
command thats causing the issue. The username and password in the two
commands is identical, and they both exist on the same database
instance.
Does anyone have any suggestions to the cause of this problem?
thanks
terry