Create the H2 Database Server

Web Viewer
works with the H2 Database to store administrative data and improve the run-time performance. The H2 database for
Web Viewer
can be either internal or external:
view140
Web Viewer
works with the H2 Database to store administrative data and improve the run-time performance. The H2 database for
Web Viewer
can be either internal or external:
  • An internal H2 database can be used by a single
    Web Viewer
    instance only, it cannot be shared.
  • You can share an external H2 database with multiple
    Web Viewer
    instances using an H2 database server. Sharing an H2 database lets you share resources (that is, repositories) by multiple
    Web Viewer
    instances. If you add a repository on one
    Web Viewer
    instance, it is available to the other
    Web Viewer
    instances.
If the H2 database is shared, you must create the H2 database server to manage the H2 database. Each
Web Viewer
instance connects to the H2 server to access the H2 database.
Follow these steps to create the H2 database server:
  1. Edit member CAHVHS2 in the &CAI.CVDEJCL partitioned dataset. &CAI is the high level qualifier of the datasets for the CA View installation.
  2. Replace the JOB card with a valid JOB card for your site.
  3. Change all occurrences of the following fields to the appropriate values:
    Field
    Description
    <tcpport>
    The port the TCP server component listens on.
    <webport>
    The port the H2 Web server component listens on.
    <javahome>
    Name of your JAVA home USS directory.
    <cvinstall>
    Name of the
    Web Viewer
    USS installation directory.
    Java 1.8 64 bit is required.
  4. (Optional) If you plan to create your own database, you must start both the TCP and Web components of the H2 server. To start both the TCP and Web components of the H2 server, comment out the empty WEBOPTS statement and uncomment the WEBOPTS with the -webAllowOthers option.
  5. (Optional) By default, the H2 TCP server only allow connections from the local system. To allow connections from other systems, add the -tcpAllowOthers option to TCPOPTS.
  6. Run the job and verify that the H2 TCP and/or Web components started successfully.
    Example:
    TCP server running at tcp://10.10.10.10:12345tcp://10.10.10.10:12345 (only local connections)
  7. Keep track of the address and port of the TCP server because it is used later for the DBLOCATION parameter in the configuration file..
    When you share an H2 database, the H2 database server must be running for
    Web Viewer
    to access the H2 database.