If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: DB2 Federated Server: Unable to access remote tables

We are having problems in accessing tables from another DB2 database. While creating a nickname for a table on a remote database we get the following error. Any help will be appreciated.

"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 "TSTODSD1" on node "DB2INST1" could not be accessed
with the specified authorization id and password."

4.
We tried to create a nickname using the following statement, but it failed.

db2 "create nickname tb_customer for tstods.ods.tb_customer"

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 "TSTODSD1" on node "DB2INST1" could not be accessed
with the specified authorization id and password.

We recreated the server by issuing the "CREATE SERVER .. " command with different options like fold_id 'U', fold_pw 'U' but still we had the same problems when creating the nickname.

Re: DB2 Federated Server: Unable to access remote tables

You need to create the USER MAPPING with the USER and PASSWORD from where you will access the SOURCE database.
It fix the problem.
any questions, let me know....mcelidba@aol.com

Originally posted by nbhandarkar
We are having problems in accessing tables from another DB2 database. While creating a nickname for a table on a remote database we get the following error. Any help will be appreciated.

"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 "TSTODSD1" on node "DB2INST1" could not be accessed
with the specified authorization id and password."

4.
We tried to create a nickname using the following statement, but it failed.

db2 "create nickname tb_customer for tstods.ods.tb_customer"

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 "TSTODSD1" on node "DB2INST1" could not be accessed
with the specified authorization id and password.

We recreated the server by issuing the "CREATE SERVER .. " command with different options like fold_id 'U', fold_pw 'U' but still we had the same problems when creating the nickname.