Managing Databases › Restore the H2 Database › Run the H2 Database Restore

Run the H2 Database Restore

Important! We recommend that you perform this procedure only when requested to do so by CA Support.

Follow these steps:

1. Verify that you have BPX.SUPERUSR authority. This authority is required to unmount the databases later in this procedure.
2. Stop the JBoss server (CHORJBOS started task):

   P CHORJBOS
   

   A message indicating that the JBoss server started task has ended is logged.

3. If CA Chorus for Storage Management is installed, unmount the CA Chorus for Storage Management database:

   unmount INSTALL_HOME/database/storage
   

4. Unmount the H2 database directory file system:

   unmount INSTALL_HOME/database
   

5. Run the JCL member for the H2 database restore. This JCL member was created in Create the H2 Database Restore JCL.
6. Mount the H2 database directory file system:

   mount -t ZFS -o aggrgrow -f 'chorus_runtime_hlq.CETJDB'  INSTALL_HOME/database
   

7. If you unmounted the CA Chorus for Storage Management database, remount it:

   mount -t ZFS -o aggrgrow -f 'storage_webclient_derby_db' INSTALL_HOME/database/storage
   

   storage_webclient_derby_db

   Name of the CA Chorus for Storage Management Web Client Derby database. To determine the database name, see the E4HI0007 member in CE4HJCL.

   Example: CHORUS.RUNTIME.CE4HVDB

8. Restart the JBoss server (CHORJBOS started task):

   S CHORJBOS
   

   The following message appears when JBoss server startup is complete:

   ETJTC001I CA Chorus Startup Complete
   

   You have restored the H2 database.