We are setting up the federation in order to browse data from ADABAS using DB2 federation. We have a Classic Data Architect connection set up and a remote server in DB2 federation configured usign JDBC. The problem is that when we try to create a nickname using this command:
CREATE NICKNAME "JADABAS"."[TABLENAME]" FOR "CACDSJ"."ANAG"."[TABLENAME]";
we are getting this error:
The current transaction was rolled back because of error "-430".. SQLCODE=-1476, SQLSTATE=40506, DRIVER=3.68.61
The DB2-server is a windows.
any ideas?
here the logs: Google drive log link
DB2LEVEL output:
DB21085I This instance or install (instance name, where applicable: "DB2") uses "64" bits and DB2 code release "SQL10059" with level identifier "060A010E". Informational tokens are "DB2 v10.5.900.618", "s170908", "IP24033", and Fix Pack "9". Product is installed at "C:\IBM\WSII\V10.5" with DB2 Copy Name "DB2COPY1".
There where privileges problems, correcting them now it is working fine.