Specifying a relational database alias name on i5/OS

Specifying a relational database alias name

This example shows the addition of a directory entry that specifies an RDB alias name. This allows networks that have relational databases of the same name to uniquely identify each in a Distributed Relational Database Architecture™ (DRDA^®) environment.
When an entry using an alias has been added to the RDB directory, the entry is identified by its alias name. To display or delete the entry, specify the alias name.
The following display has RDBALS specified as the relational database alias name.
Type choices, press Enter. 

Relational database . . . . . . > TEST Character value 
Relational database alias . . . RDBALS 
Remote location: 
Name or address . . . . . . . MP311.spiffy.com 



Type . . . . . . . . . . . . . 	*IP 					*SNA, *IP 
Text . . . . . . . . . . . . . . 'Oak Street Dealership'
When you add an entry for an alias using WRKRDBDIRE and option 1, you should first put the real RDB name in the Entry field, and press Enter. Then, after filling in the other fields including the alias name in the Relational database alias field, you will see the alias name replace the real RDB name in the Entry field of the list of RDB entries. Note that change Type for the remote location name from *SNA to *IP.
When removing a relational database entry with the Remove Relational Database Directory Entry (RMVRDBDIRE) command, the alias name, rather than the real relational database name, is used to specify which entry to remove.
If you identify a remote database by an alias, you cannot also refer to it by its real name in the same directory.
Instead of specifying MP311.spiffy.com for the RMTLOCNAME parameter, you can specify the IP address (for example, 9.5.25.176). For IP connections to another System i™ environment, leave the PORT parameter value set at the default, *DRDA, unless use port 447. For example, you might have port 447 configured for transmission using IP Security Architecture (IPSec). For connections to an IBM^® DB2 Universal Database™ (UDB) server on some other platform, for example, you might need to set the port to a number such as 50000. Refer to the product documentation for the system you are using. If you have a valid service name defined for a DRDA port at a certain location, you can also use that name instead of a number. However, on the i5/OS^® operating system, *DRDA is preferred to the use of the DRDA service name.

Parent topic:
Working with the relational database directory