How do you set you configure your catalogue with the Client Configuration Wizard to DB2 for LUW Databases?
Configure DB2 Client Connections
From the Client Configuration wizard, you can manually catalog entries for DB2 for z/OS (mainframe or gateway) or for LUW. You can also import an existing catalog profile and remove catalog entries.
Manually Catalog Entries to DB2 for LUW Databases
To manually catalog entries to DB2 for LUW databases
Click Client Configuration beside the Database Alias drop-down list in the New Connection window.
Select Manual Configuration in the Welcome window of the Client Configuration wizard.
Click Next to open the Add a Host window.
Complete the following fields:
Operating system Select the operating system for the server on which the DB2 instance containing the DB2 database you are cataloging resides. For a list of supported server platforms, refer to the release notes.
Host name Enter the TCP/IP address or the machine name for the server on which the DB2 database resides.
Port number Enter the port number for the server on which the DB2 database resides.
Enable SOCKS security Select this checkbox to enable the SOCKS secure protocol to handle TCP traffic for this connection. SOCKS adds an authentication mechanism for additional security.
Click Next to open the Specify an Instance window.
Complete the following fields:
Node name Enter a user-defined name for the DB2 instance containing the database you are cataloging.
Instance name Enter the real name of the DB2 instance.
Comment Enter a descriptive comment for the instance, if needed.
Click Next to open the Add a Database window.
Complete the following fields:
Database name Enter the real name of the DB2 database.
Database alias Enter a unique nickname to identify the database on your system.
Authentication Select the authentication method that is required to connect to the database.
Target principal Enter the service account name for server's service where the database resides. Note: This option is available only when Kerberos is selected as the authentication method.
Comment Enter a descriptive comment for the instance, if needed.
Click Next to open the Catalog Script Review window.
Review and modify the script in the preview pane as needed.
Click Finish. A dialog informs you whether the entry was added successfully.
You can now select the database alias in the New Connection window and connect to the database.
Import Profile
Note: Before importing a profile, you must export your existing DB2 catalog entries from a DB2 client to a profile using the Connectivity Configuration Export Tool Command (db2cfexp). For more information, refer to the IBM documentation at: <http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/r0002442.htm>
To import a catalog profile
Click Client Configuration beside the Database Alias drop-down list in the New Connection window.
Select Import Profile in the Welcome window of the Client Configuration wizard.
Click Next to open the Select a Database from a Profile window.
Click Open in the Profile name field to browse to the location of the profile. After selecting a profile, the contents of the file are loaded in the panel.
Click Next to open the Catalog Script Review window.
Review and modify the script in the preview pane as needed.
Click Finish. A dialog informs you whether the entry was added successfully.
You can now select the database alias in the New Connection window and connect to the database.
