Command Reference

ADD DATALINKS MANAGER

Adds a DB2 Data Links Manager to the list of registered DB2 Data Links Managers for a specified database.

Authorization

None

Command Syntax

>>-ADD DATALINKS MANAGER FOR----+-DATABASE-+--dbname---USING---->
                                '-DB-------'
 
>-----+-NODE--hostname---PORT--port-number---------------+-----><
      '-CELL--DFS-cellname---DLMINSTANCE--instance-name--'

Command Parameters

DATABASE dbname

Specifies a database name.

USING NODE hostname

Specifies a fully qualified host name, or the IP address (but not both), of the DB2 Data Links Manager server.

PORT port-number

Specifies the port number that has been reserved for communications from the DB2 server to the DB2 Data Links Manager server.

CELL DFS-cellname

Specifies the fully qualified name of the DFS cell. For example, dln1.almaden.ibm.com.

Note:

This parameter allows only one cell to be registered in a database.

DLMINSTANCE instance-name

Specifies the instance name which runs the Data Links Manager in the cell.

Usage Notes

A Data Links Manager added by specifying USING NODE is said to be of type "Native", whereas a Data Links Manager added by specifying USING CELL is said to be of type "DFS". All Data Links Managers registered to a database must be of the same type, and only one Data Links Manager of type "DFS" can be registered to a database.

When registering one or more DB2 Data Links Managers for a database using this command, ensure that the DB2 Data Links Manager is not registered twice; otherwise, error SQL20056N with reason code "99" may be returned during DataLink processing. The db2diag.log file for the DB2 Data Links Manager server that is registered twice will have the following entry when such a failure occurs:

   dfm_xnstate_cache_insert : Duplicate txn entry.
   dfmBeginTxn : Unable to insert ACTIVE transaction in cache, rc = 41.
   DLFM501E : Transaction management service failed.

Note: The Command Line Processor detects errors if duplicate Data Links Managers are added using the same name or address. However, duplicates are not detected if a Data Links Manager is added more than once using a different IP name or address. For example, if a Data Links Manager was added twice, once using the name dln1.almaden.ibm.com and again using the short name dln1, the failure described above is possible.

See Also

LIST DATALINKS MANAGERS.

[ Top of Page | Previous Page | Next Page ]