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?
Release : 14.0
Component : Output Management Web Viewer
DB2
The Web Viewer r14 database holds the following product data:
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:
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.