Tag Archive: configuration

Using the DB2 Control Center to Connect to a Remote Database

DB2CCWhen using DB2 you might want to use the Control Center GUI to query or manage a database that resides on a remote machine, took me a little time to work out and I promised others I would share this.  I am sure there is more then one way to accomplish this, your mileage may vary.

Before you begin you need to collect the following information

  1. Fully Qualified Hostname where the DB2 database resides
  2. Services file entry for the database – this will include the instance name and port number (default is 50000, but could be different depending on your DB2 Configuration
  3. The Database Name to connect to
  4. The operating system of the DB2 Install
  5. Username & Password to connect to the Database

You can get this information from your friendly Database administrator or find it yourself.  If you have access to the physical machine where DB2 is installed you can get the instance name and port number from the services file on that machine.

Before you begin edit the Services file on the machine with the DB2 Client, simply cut and paste the entry from the DB2 host machine for example this would represent two unique DB2 instances

db2_LC3    50000/tcp
DB2_LC25  60000/tcp

From the DB2 Control center (on the client machine) launch the Configuration Assistant

1

From the ‘Selected’ dropdown choose Add a Database Using Wizard

2

Select Manually configure a connections to a database and click Next

image

Select TCP/IP as the communications protocol

image

Enter the FQHN of the DB2 server and the Service name (that you added to the services file above) use the “Retrieve” button to fill in the port number (from the services file)

image

Fill in the database name (in this example I am connecting to an IBM Connections Profiles DB named PEOPLEDB.  Assign an Alias – Aliases must be unique, for example I might connect to a production and test PEOPLEDB, the aliases must be unique (aliases are also limited to 8 characters the first of which must be alpha).  Optionally you can add a descriptive comment.

image

Simply accept the defaults on this screen

image

Use the dropdown to fill in your operating system, and fill in the Instance Name, the instance name is the same value you put in the System file

image

Fill in the system name using the same value as instance name above, the other fields should already be filled in

image

Keep the default of Use authentication value in server’s DMB Configuration (unless you are using a different authentication method).  Click Finish when you are doneimage

Click on Test Connection to verify your work

image

Enter your database username and password (username is most likely LCUSER for an IBM Connections database) and click Test Connections

image

If you see this you have completed the setup successfully, if not go back and double check your work

image

Once you have successfully created connections to DB2 databases you can back them up, or share them with others.  See Exporting a configuration profile using the Configuration Assistant and Configuring database connections using a client profile with the Configuration Assistant for details on importing and exporting.

New Template and Rules for Domino Configuration Tuner

If you are using Domino Configuration Tuner (DCT) (and if you are not why not?)  make sure you update your DCT database.  There is a template and rules update available. A picture named M2 Check out the ‘Tuner Blog for the details on the update. Domino Configuration Tuner