Using a Single Database

Instead of creating multiple databases for each of your datastores, MFDBFH allows you to store multiple datastores, in a single physical database. This is facilitated by using unique database schema names to differentiate between the resources. If you view the contents of your databases in your vendor's database management tool, you can see the resources grouped under their own unique schemas:

Resource type	Schema Name Format	Notes
Datastore	DBFH_<datastore-name>	For example, if the datastore name is VSAM, its associated schema name will be DBFH_VSAM

Using a single database is optional, but from a performance point of view, it is advantageous to store related resources all in one place. It also allows connection sharing, which significantly reduces the number of connections required for each process; see Sharing Database Connections.

The alternative to using a single database is that you use individual databases for each resource (datastores, region databases, and cross-region database). For a single operation/transaction, each resource will require separate connections, which is obviously less efficient.

Note: Regardless of the storage method you use, additional connections may also be required for other MFDBFH-related processes.

The database creation instructions within the configuration sections explain how to create the resources using both a single and separate databases.