Quick Beginnings

Setting Up and Working with the Control Center

This section describes how to set up and customize the Control Center for your environment.

Control Center Services Setup (Applet Mode only)

If you will run the Control Center as an application, skip this section and go to Running the Control Center as a Java Application.

To set up the Control Center to run as an applet:

  1. Start the Control Center JDBC Applet Server.
  2. On Windows NT or Windows 2000, start the security server.

1. Start the Control Center JDBC Applet Server

To start the Control Center JDBC Applet Server, enter the db2jstrt 6790 command, where 6790 represents any 4-digit port number that is not already in use.

We recommend that you start the Control Center JDBC Applet Server with a user account that has SYSADM authority.

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

Most DB2 resources are accessed over database connect or instance attach. In both cases the user must supply valid user ID and password combinations to gain access. However, some resources are accessed directly by the Control Center JDBC Applet Server, including the database and node directories (catalogs), and the Command Line Processor. Access to these resources is performed by the Control Center JDBC Applet Server on behalf of the logged in Control Center user. Both the user and the server are required to have the proper authorization before access will be granted. For example, to update the database directory, a minimum of SYSCTRL authority is required.

It is possible to run an instance of the Control Center JDBC Applet Server with any level of security, but you will be unable to update certain resources such as database and node directories. In particular, you may encounter a SQL1092N message informing you of the lack of authorization for a request. The user specified in the message can be either the user signed into Control Center, or the user account running the Control Center JDBC Applet Server.

On Windows NT, you can start the Control Center JDBC Applet Server by clicking Start and selecting Settings --> Control Panel --> Services. Select the DB2 JDBC Applet Server - Control Center service and click Start.

On Windows 2000, you can start the Control Center JDBC Applet Server by clicking Start and selecting Settings --> Control Panel --> Administrative Tools --> Services. Select the DB2 JDBC Applet Server - Control Center service, click the Action menu and then select Start.

On any system, you can start the Control Center JDBC Applet Server by entering:

   net start DB2ControlCenterServer

This step is not required if your Control Center JDBC Applet Server is autostarted.

If you start the Control Center JDBC Applet Server as a Windows NT or Windows 2000 service, you must configure the startup in the services dialog to change the account information.

2. Start the Windows NT or Windows 2000 Security Server

To work with the Control Center on Windows NT or Windows 2000, the security server must be running. During DB2 installs, the Security Server is usually set up to autostart.

You can check if the Security Server is running on Windows NT by clicking Start and selecting Settings --> Control Panel --> Services.

On Windows 2000, click Start and select Settings --> Control Panel --> Administrative Tools --> Services.

If the DB2 Security Server is not started on Windows NT, select it and click Start. On Windows 2000, select the Action menu and click Start.

After you have started the Control Center JDBC Applet Server and started the Windows NT or Windows 2000 security server (if necessary), go to Running the Control Center as a Java Applet.

Working with the Control Center

You can run the Control Center as a Java application or as a Java applet. If your environment is configured similar to Scenarios 1 or 2 in Table 12, you must run the Control Center as an application. If your environment is configured like Scenarios 3 or 4, you must run it as an applet.

Running the Control Center as a Java Application

To run the Control Center as a Java application, you must have the correct Java Runtime Environment (JRE) installed. See Table 13 for the correct JRE level for your operating system.

  1. To start the Control Center as an application:

    On Windows 32-bit operating systems:
    Click Start and select Programs --> IBM DB2 --> Control Center.

    On OS/2:
    Open the IBM DB2 folder and double-click on the Control Center icon.

    On all supported platforms:
    Start the Control Center from a command prompt by entering the db2cc command.
  2. The DB2 Control Center window opens.
  3. You can start working with the Control Center without an existing database by creating a sample database. Enter the db2sampl command on the DB2 Universal Database server. On UNIX operating systems, ensure that you are logged in to the DB2 instance before you enter the db2sampl command.

Running the Control Center as a Java Applet

To run the Control Center as a Java applet, you must have a Web server set up on the machine that contains the Control Center applet code and the Control Center JDBC Applet Server. The Web server must allow access to the sqllib directory.

If you choose to use a virtual directory, substitute this directory for the home directory. For example, if you map sqllib to a virtual directory called temp on a server named yourserver, a client would use the URL: http://yourserver/temp

If you do not have the DB2 documentation installed and you would like to configure your web server to work with DB2's online documentation, refer to the Installation and Configuration Supplement.

To run Control Center as an applet on Windows 32-bit or OS/2 operating systems, you must run db2classes.exe on the machine where the DB2 JDBC Applet Server resides to unzip the required Java class files. On UNIX-based systems, you must uncompress and untar db2classes.tar.Z to make the required Java class files available.

To load the Control Center HTML page, perform the following steps:

  1. Start the 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 Control Center page and click on the Open push button. For example, if your server is named yourserver, you would open http://yourserver/cc/prime/db2cc.htm
  2. In the Server port field, enter a value for the Control Center JDBC Applet Server port. The default server port value is 6790.
  3. Click on the Start Control Center 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 Control Center JDBC Applet 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 OK.
  5. The DB2 Control Center window opens.
  6. You can start working with the Control Center without an existing database by creating a sample database. Enter the db2sampl command on the DB2 Universal Database server. On UNIX operating systems, ensure that you are logged in to the DB2 instance before you enter the db2sampl command.

Customizing Your Control Center HTML File

To automatically start the Control Center the next time you open db2cc.htm, perform the following steps:

Configuring Your Web Server to Work with the Control Center

For general web server configuration information, consult the setup documentation that came with your web server.

For more information on serving DB2 online documentation through a web server, refer to the Installation and Configuration Supplement.


[ Top of Page | Previous Page | Next Page ]