Need assistance choosing H2 Database vs DB2 database for 14.0 Web Viewer
search cancel

Need assistance choosing H2 Database vs DB2 database for 14.0 Web Viewer

book

Article ID: 251695

calendar_today

Updated On:

Products

Output Management Web Viewer

Issue/Introduction

Should I setup an H2 database (external) vs a DB2 database? The manual says the database is used for product data. We would like to have multiple view instances across different LPARS in the same SYSPLEX. I read that the H2 database is stored in a UNIX directory so if we want to share this across a plex, it would have to go into a shared ZFS. Would we see performance issues if it was in a shared ZFS? Maybe from the LPAR that doesn't own the ZFS? Also, does future software update methods (via z/OSMF) come into play? Meaning, would it be easier to update the database if it was in H2 format vs DB2?

 

Environment

Release : 14.0

Component : Output Management Web Viewer

DB2

Resolution

The Web Viewer r14 database holds the following product data:

  • Repository definitions
  • Repository group definitions
  • Export rule definitions
  • Configuration properties
  • Feature properties
  • Activity tables

The Web Viewer r14 database does NOT contain any report data or any report index data as that is stored and maintained by View in the View repository.

There are three configurations available for the Web Viewer r14 database:

  1. H2 Internal – With this configuration the H2 database resides under the USS file system and the DB_JDBC_URL parameter includes the path and database name.  H2 reads and writes directly to the database.  The database is opened for exclusive use by this instance of Web Viewer.
  2. H2 External – With this configuration the H2 database resides under the USS file system and the DB_JDBC_URL parameter includes the host and port of the H2 server as well as the path and database name.  H2 connects to the H2 server, it’s the H2 server that reads and writes to the database.
  3. DB2 - With this configuration the DB2 database resides in DB2 and the DB_JDBC_URL parameter includes the connection URL for the database.

With H2 External and DB2 more than one instance of Web Viewer r14 can use the same database. However, you cannot share tables between multiple Web Viewer r14 instances so each instance must have its own schema within the shared database.