Registering the Db2 wrapper

You must register a wrapper to access Db2 family data sources. The federated server uses the wrapper to communicate with and retrieve data from the data sources. A wrapper is implemented as a set of library files.

Procedure

Use one of the following methods to register a wrapper:

Method Description

Use the Administration Explorer in IBM® Data Studio. In the Federated Database Objects folder, right-click the Wrappers folder, and select Create Wrapper.

Issue the CREATE WRAPPER statement and specify the name for the wrapper.

Method	Description
Use the Administration Explorer in IBM® Data Studio.	In the Federated Database Objects folder, right-click the Wrappers folder, and select Create Wrapper.
Issue the CREATE WRAPPER statement and specify the name for the wrapper.	The default wrapper name for the Db2 family data sources is DRDA. For example: `CREATE WRAPPER DRDA` When you use the default name to register the wrapper, you do not need to specify the library name because the federated server automatically uses the default library name that is associated with the wrapper. If the wrapper name conflicts with an existing wrapper name in the federated database, you can replace the default wrapper name with a name that you choose. However, if you do so, you must include the LIBRARY parameter in the CREATE WRAPPER statement. For example, to register a wrapper with the name db2_wrapper on a federated server that uses the AIX® operating system, issue this statement: `CREATE WRAPPER db2_wrapper LIBRARY 'libdb2drda.a'`

The default wrapper name for the Db2 family data sources is DRDA. For example:

CREATE WRAPPER DRDA

When you use the default name to register the wrapper, you do not need to specify the library name because the federated server automatically uses the default library name that is associated with the wrapper. If the wrapper name conflicts with an existing wrapper name in the federated database, you can replace the default wrapper name with a name that you choose. However, if you do so, you must include the LIBRARY parameter in the CREATE WRAPPER statement.

For example, to register a wrapper with the name db2_wrapper on a federated server that uses the AIX® operating system, issue this statement:

CREATE WRAPPER db2_wrapper 
 LIBRARY 'libdb2drda.a'

The default library name is specific to the operating system of the federated server. For more information, see the list of Db2 wrapper library files.