Configuring the Catalog Service to run on Db2 for LUW

About this task

By performing the following actions, the data is imported in the Db2 for LUW (Linux, UNIX, and Windows) database.

Procedure

Open the server.xml file from \wlp\usr\servers\ad_server.

Enable IBM® AD Catalog, by removing the  comment around its <webApplication> element.

<webApplication contextRoot="com.ibm.etools.ad.catalog" id="com.ibm.etools.ad.catalog" location="com.ibm.etools.ad.catalog.war" name="ad-catalog">
        <application-bnd>
            <security-role name="ADCatalogUser">
                <user name="catalog"/>
            </security-role>
        </application-bnd>
</webApplication>

In the  area, add the following library.
```
<library id="DB2JCCLib">
        <fileset dir="${shared.config.dir}" includes="db2jcc4-4.xx.xx.jar com.ibm.ez.db2jcc.license.cisuz-1.x.x.jar"/>
</library>
```
Important: Make sure that in the wlp/usr/shared/config folder, the two .jar files are present. Depending on the Db2 version that is installed on your machine, the .jar file names can differ.
In the  area, edit the <dataSource> XML element as follows.
Example:
```
<dataSource id="db2" jndiName="jdbc/ad/catalog/relational">
        <jdbcDriver libraryRef="DB2JCCLib"/>
        <properties.db2.jcc databaseName="CATDB" serverName="localhost" portNumber="50000" user="db2admin" password="{aes}ABitSh1jv1T9i8tpGN7uQiSvx+yAZl++igoVWxzzMu3CoI4lM6d69HP69MuRDeIEDQ=="/>
</dataSource>
```
Example: with TLS
```
<dataSource id="db2" jndiName="jdbc/ad/catalog/relational">
        <jdbcDriver libraryRef="DB2JCCLib"/>
        <properties.db2.jcc databaseName="CATDB" serverName="localhost" portNumber="50005" user="db2admin" password="{aes}ABitSh1jv1T9i8tpGN7uQiSvx+yAZl++igoVWxzzMu3CoI4lM6d69HP69MuRDeIEDQ==" sslConnection="true"/>
</dataSource>
```
Note: When configuring Catalog Service to run on Db2 for LUW, make sure that properties.db2.jcc is present in the <dataSource> XML element.
Where:
- databaseName - expects the Db2 database name.
- serverName - expects the name/IP of the server when Db2 Server is installed.
- portNumber - expects the port number configured for the communication with Db2 Server. The default value is 50000. Enter the same port that was used when IBM Db2 with TLS was selected as a default relational database server. For more information, see Managing a Relational Database Server.
- user - expects the user that is used to connect to the Db2 database.
- password - expects the password that is used to connect to the Db2 database.
  Important: The password that is used to connect to the Db2 database can be encrypted. The securityUtility command supports plain text encryption for Liberty. For more information, see securityUtility command.
- sslConnection - needs to be set on true if Db2 for LUW has been configured with TLS.
Make sure that IBM AD Catalog Service is configured in IBM AD Configuration Server. For more information, see Configuring IBM AD Catalog Service.
Once the configuration is done, go to the Dashboard tab, in IBM AD Configuration Server, click the menu button of Web Service, and select Restart Service.
Note:
- Wait until the services are restarted, this can take a few minutes to complete.
- The Catalog database will be automatically populated when Data Collector starts for the first time.