An error is generated when I try to create a nickname.
System
======
DB2 8.1.4 federated database trying to connect to DB2 7.2.9
Local = DB2/6000 8.1.4
Remote = DB2/6000 7.2.9
Setup
=====
I can successfully create the connection
catalog tcpip node ...
catalog database ...
connect to xxx user yyy using zzz
this works fine.
Error
=====
create server <server> type DB2/6000 version 7.2.9 wrapper DRDA
authorization <auth> password "<pwd>" options(add node ‘<node>', add
dbname '<db>')
create user mapping for <user> server <server> options (remote_authid
'<user>', remote_password '<pwd>')
create nickname local_tablex for server.schema.t ablex
The error is returned on the command line of 8.2
DB21034E The command was processed as an SQL statement because it was
not a valid Command Line Processor command. During SQL processing it
returned:
SQL0551N "The ODBC authid " does not have the privilege to perform
operation "unknown " on object "unknown ". SQLSTATE=42501
A corresponding error is located in db2diag.log of 7.2.9
Data Title:SQLCA PID:18716 Node:000
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -551 sqlerrml: 32
sqlerrmc: MIS_READ EXECUTE NULLID.SYSLN202
sqlerrp : sqlraeac
sqlerrd : (1) 0xFFFF877E (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Data Title:DB2RA PID:18716 Node:000
5351 4c44 4232 5241 0000 008c 0105 0002 SQLDB2RA....... .
0009 000a 0000 0088 8000 0009 2005 b288 ............ .².
0000 0000 4000 0002 0000 0000 0000 000c ....@.......... .
4000 0004 2005 e374 0000 0002 4000 0003 @... .ãt....@...
2005 aea6 0000 0008 4000 0001 2005 ae8c
......@.. . ..
0000 0008 4000 0001 2005 ae6e 0000 0008 ....@... .n....
4000 0001 2005 ae9e 0000 0000 4000 0005 @... ......@.. .
0000 0000 0000 2be4 c000 0006 2005 b76c ......+äÀ... .•l
0000 0079 4000 0001 2004 6b08 ...y@... .k.
Im at a loss to resolve this error. I believe the bindings are
correct. Any and all suggestions are welcome.
thanks
Terry