Database Management and Recovery

Attention: This feature is in Early Adopter Product (EAP) release status. We will continue the development of additional features and provide additional interfaces via patch updates and future releases. Please contact Micro Focus SupportLine if you require further clarification.

Use the dbfhadmin command-line tool to recover resources from region, cross-region, and datastore databases in the event of a system failure.

If an enterprise server process terminates abnormally, database resources used by the process (for example, resource locks, open file handles, and record locks) may not get freed up correctly.

In the case of region and cross-region databases, you should use the -list action to display all processes currently registered in a CAS cross-region database. Any processes displayed with an "In doubt" status need to be recovered. Processes get registered when an enterprise server process (for example: casmgr and cassi) initialise use of a region database. Processes get de-registered when an enterprise server process terminates normally. If a process is killed, or abnormally terminates, its associated process record in the cross-region database does not get removed. When the processes are listed, all active ones (i.e. registered, but not yet terminated) have an "Ok" status, whereas any process that has been killed, or abnormally terminated, will have an "In doubt" status. Any process with an "In doubt" status could potentially still be owning region database resources.

For database-hosted data files, use the -list action to display any data files still open. After ensuring that the host machine or (if specifying a process id) the process is no longer running, use the -recover option on any files that are still open. When files are forced closed, their file handles are removed from the datastore database and any associated record locks released.

You can also use the dbfhadmin command-line tool to manage the column types that correspond to the primary and alternate keys of your indexed files. This management is required when creating indexed data files independently of COBOL programs (for example, when using the CFCR CICS transaction or using the JCL MFJAMS utility), as there is no mechanism to generate the key type definitions, and so when those files are created in the datastore, each column type is binary. The -keytypes action of dbfhadmin enables you to inject different key types for a file's indexed keys.

Note: You will also need to use dbfhadmin to define key type definition if your indexed files were created via COBOL programs that were not compiled with the IXNUMKEY Compiler directive.