Creating federated server definition for AS/400
I'm trying to create a federated server definition for AS/400 from DB2 Control Center and I face some errors.
I've successfully created the DRDA wrapper, but on the server definition, I don't know what to enter to the DBNAME parameter. I've tested some AS/400 libraries and package libraries with no results. It said that it can't find and database with the given names.
My question is what is the equivalent DBNAME for a library to connect to?
P.S.: The command is:
CREATE SERVER MYSERVER TYPE DB2/400 VERSION '5.2' WRAPPER "DRDA" AUTHID "XXX" PASSWORD "XXX" OPTIONS( ADD DBNAME 'XXX', PASSWORD 'Y')
I'm a bit confused now. We have an AIX server where the DB2 resides and I want there to create a remote database connection to an AS/400 system.
So, if I've understand well on the Control Center of the DB2 on AIX I have to create a DRDA wrapper (already created it), catalog the AS/400 node and then catalog the AS/400 library with a specific alias.
Then I create the federated server definition by using the above alias on the DBNAME parameter.