What's New

Web Control Center Installation and Configuration

The Web Control Center is the Java version of the DB2 Universal Database Control Center. From a tools perspective, it is modeled on the DB2 Release 5 Control Center, but it provides you with a more flexible network-centric database administration environment. The Web Control Center is implemented as a Java applet that uses DB2's JDBC support.

Information on supported Web browsers and operating systems can be found on the Web at http://www.software.ibm.com/data/db2/library/browsers.html

Components to Install

To get started with the Web Control Center, you need to install DB2 Universal Database Server Version 5.2, where the server is any of:

• Workgroup Edition
• Enterprise Edition
• Enterprise - Extended Edition (EEE)

To run the Web Control Center, you need:

• A Web browser; for supported browsers see the Web at http://www.software.ibm.com/data/db2/library/browsers.html

• A Web server (optional). See "Machine Configuration" for details on when you need a Web server.

Machine Configuration

You can set up your Web Control Center (Web CC) in a number of different ways. The following table identifies four scenarios, each showing a different way of installing the required components. These scenarios are referenced throughout the "Web Control Center Setup" section that follows the table.

Scenario	Machine A	Machine B	Machine C
1 - Standalone	Browser Web CC applet JDBC server DB2 server
2 - Two Tier1	Browser Web CC applet JDBC server CAE3		DB2 server
3 - Two Tier2	Browser	Web CC applet Web server JDBC server DB2 server
4 - Three Tier	Browser	Web CC applet Web server JDBC server CAE	DB2 server
Note: Browser and JDBC server on one machine. Standalone browser. Client Application Enabler.

In Scenarios 1 and 2, there is no requirement for a Web server because the Web Control Center (Web CC) applet and the browser are on the same machine.

In Scenarios 3 and 4, the Web Control Center applet code is remote, which enables code sharing across several browsers. This means that you can access the Web Control Center from browsers on different machines. Since the applet has not been implemented as a trusted applet, the Web server and the JDBC server must reside on the same machine.

Web Control Center Installation

This section describes how to install the Web Control Center and how you can customize it for your environment.

Web Control Center Setup

1. Start the DB2 servers:

   • On the Windows NT operating system, start the db2 security server. Click on Start->Control Panel->Services. Select the db2 security server and click on the Start push button.

     Note:

     This step is not required if your security server is autostarted.

   • On Windows NT or OS/2 operating systems, enter the db2start command on the machine with the DB2 Universal Database server.

     On the UNIX operating system, logon to the account where you want to run the JDBC server and issue the db2start command.

   • On the Windows NT or OS/2 operating system containing the JDBC server, enter:

       start db2jd 6790
     

     On the UNIX operating system containing the JDBC server, enter:

       db2jd 6790 &
     

     The port number 6790 is an example; any 4-digit number that is not already in use can be used. The default port number is 6789.

     Note:

     The first time you start the JDBC server, it will create several node directory entries, together with various files for administration purposes. In Scenario 1 and 3, all of these administration files and directory entries will be created in the current DB2 instance.

   • On the UNIX operating system, logon to the administration server account and issue the db2admin start command.
   this startup on either the Client Application Enabler or the DB2 Universal Database server.

2. You can start working with the Web Control Center without an existing database by creating a sample database. Enter the db2sampl command on the DB2 Universal Database server. On a UNIX operating system, ensure that you are logged on to the DB2 instance before you enter the db2sampl command.

3. Load the HTML page to start the Web Control Center:

   • If you are running Scenarios 1 or 2, then you do not need a Web server set up on your machine.

     1. Start the DB2 Web Control Center Launch page. In your Web browser, select File->Open Page. The Open Page dialog box appears.

        On a Windows or OS/2 operating system

        Enter x:/sqllib/java/prime/db2webcc.htm, where x: represents the drive where DB2 is installed.

        On a UNIX operating system

        Enter INSTHOME/sqllib/java/prime/db2webcc.htm, where INSTHOME represents the home directory of the instance.

        Click on the Open push button.

     2. The DB2 Web Control Center Launch page appears. When the control panel appears, click on the Launch push button.

   • If you are running Scenarios 3 or 4, then you must have a Web server set up on the machine that contains the Web Control Center applet code and the JDBC server. The Web server must allow access to the sqllibdirectory.

     1. Start the Web Control Center Launch page through your Web server. In your browser, select File->Open Page. The Open Page dialog box appears. Enter the URL of your Web server and the main Web Control Center page and click on the Open push button. For example: http://yourserver/java/prime/db2webcc.htm.

     2. The DB2 Web Control Center Launch page appears. When the control panel appears, select the Remote radio button, and enter the address of your Web server in the host entry field. For example: yourserver.yourdomain.com.

     3. Enter the number of the db2jd port. For example: 6790.

     4. Click on the Launch push button.

4. The Control Center Sign On window opens. Enter your user ID and password. This user ID must have an account on the machine that is running the JDBC server. Your initial logon will be used for all database connections. It can be changed from the Control Center pull-down menu. A unique user profile will be assigned to each user ID. Click on OK.

5. The DB2 Control Center window opens.

Customizing Your Web Control Center HTML File

If you want the Web Control Center started automatically the next time you open the db2webcc.htm file:

• For Scenarios 1 or 2, modify the prompted parameter tag in db2webcc.htm from

    PARAM name="prompted" value="true"
  

  to

    PARAM name="prompted" value="false"
  

• For Scenarios 3 or 4, modify the prompted, host, and port parameter tags in db2webcc.htm to

    PARAM name="prompted" value="false"
    PARAM name="host" value="yourserver"
    PARAM name="port" value="6790"
  

  where yourserver is the host name and 6790 is the port value of the machine you want to connect to.

Configuring Your Web Server to Work with the Web Control Center

Consult the setup documentation that came with your Web server for general Web server configuration information.

To configure your Web server for use with the Web Control Center, use sqllib as your home directory. If you choose to use a virtual directory, substitute this directory for the home directory. For example, if you name your virtual directory temp then you should use sqllib/temp.

If you do not have the DB2 documentation installed and you would like information on configuring your Web server to work with DB2's online documentation, see the Web at . http://www.software.ibm.com/data/pubs/papers/db2html.html

Functional Considerations

If you are using the Web Control Center over the Internet, be aware that there is no encryption of the data flow between the JDBC server and the browser.

To use the color options of Visual Explain on Netscape, you must set your operating system to support more than 256 colors.

DB2 does not support the installation of the Web Control Center on a FAT drive for OS/2, because an OS/2 FAT drive does not support long filenames required by Java.

Every activity will be associated with an explicit DB2 connection or attachment. For security purposes, every DB2 activity will be validated.

When you are using the Web Control Center under Scenarios 3 or 4, the local system is Machine B.

Installation Tips for Web Control Center Help on UNIX Operating Systems

When installing the Web Control Center online help on UNIX operating systems you should keep the following in mind:

• You should install the Web Control Center help and the product documentation at the same time. If you install the Web Control Center help and the DB2 online product documentation separately, you can expect the second installation to take some time. This is true regardless of which is installed first.

• You must select the Web Control Center help for any non-English language explicitly. Installing the product messages for a particular language does not mean that the Web Control Center help for that language is automatically installed. However, if you install the Web Control Center help for a particular language, the product messages for that language are installed automatically.

• If you install the product documentation after editing the search form, you must edit your search form again. Installing the product documentation resets the search form to its default configuration.

• If you install the Web Control Center using SMIT rather than db2installer, you must run the db2insthtml command to set up document search. For more information on using SMIT to install The Web Control Center on UNIX operating systems, refer to the DB2 for UNIX Quick Beginnings or the DB2 EEE for UNIX Quick Beginnings manuals.

Differences From DB2 V5.0.0 Control Center

Each user has a profile of their own preferences stored on the machine were the JDBC server exists.

You cannot start a new Control Center from the existing Control Center.

The Event Analyzer and Snapshot Monitor are not included as part of the DB2 Web Control Center for Version 5.2.

Troubleshooting

If you are having problems running the Web Control Center applet:

• Verify that you are using a supported browser and operating system as outlined at . http://www.software.ibm.com/data/db2/library/browsers.html

• Check your browser's Java Console window for diagnostic and trace information for the Web Control Center.

If you are having problems connecting to the JDBC or Web server:

• Ensure the JDBC server (db2jd) is running.

• Verify the port number.

• Verify the server name.

• Ensure that you are using the db2webcc.htm file from the machine running the JDBC server.

• Ensure that you have an account on the machine running the JDBC server.

• Remember that the Web Control Center works within the Client Application Enabler's locale.

[ DB2 List of Books | Search the DB2 Books ]