Monday, 22 April 2013

configure the DB2 client connection / Catalog the DB2 Database

   Windows NT    The application server connects using DB2 client aliases. These aliases are configured using IBM's Client Configuration Assistant. login must have administrator authority and the ID must be no longer than eight characters. You need to be the DB2 administrator or have administrator privileges to complete these steps.
 
 To create a new DB2 client alias:
 
  1. Open the DB2 Client Configuration Assistant from the DB2 for Windows NT program folder.
  2. Click the Add button at the top right of the Client Configuration Assistant screen. Select Next to continue.
  3. Choose to manually configure a connection to a DB2 database. Select Next to continue.
  4. Choose the appropriate protocol (default is TCP/IP). Select Next to continue.
  5. Choose the appropriate platform or LAN-based.
  6. Configure the DB2 server host name, TCP port number, and service name (optional) that your DB2 server is operating on. Select Next to continue.
  7. Enter the target database name. Select Next to continue.
  8. Enter the alias name (you will use this name later to add the database to the application server). Select Next to continue.
  9. (Optional) Register these settings as an ODBC data source. This step is not required but is recommended.
  10. Finally, test the connection from inside the Client Configuration Assistant.
 
 
Solaris   To establish a connection to your DB2 database, enter the DB2 command-line processor and enter the following two commands.
  catalog tcpip node <node name> remote <servername> server <portno>
where tcpipnodealias is the local alias for your DB2 server (usually the same as the servername), servername is the name of the DB2 server, and port# is the port on the database server that is set to receive TCP/IP calls.
  catalog database <dbname> as <aliasname> at node <node name> 
where databasename is the actual database name, aliasname is the local name of the database (which may be the same as the actual name), and tcpipnodealias is the name given in the first catalog statement.
To test the DB2 connection:
  connect to aliasname user <userid> using <password>


 

No comments:

Post a Comment