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 CA Chorus Application Server (CHORJBOS started task):

   P CHORJBOS
   

   A message indicating that the CA Chorus Application Server started task has ended is logged.

3. Stop the TSF Server (CHORNTSF started task):

   P CHORNTSF
   

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

   unmount INSTALL_HOME/database/storage
   

5. Unmount the TSF Server database:

   unmount INSTALL_HOME/database/ntsf
   

6. Unmount the H2 database directory file system:

   unmount INSTALL_HOME/database
   

7. Run the JCL member for the H2 database restore. This JCL member was created in Create the H2 Database Restore JCL.
8. Remount the H2 database directory file system:

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

9. 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

10. Remount the TSF Server database:

    mount -t ZFS -f' chorus_runtime_hlq.CETJNTSF' INSTALL_HOME/database/ntsf
    

11. Restart the TSF Server (CHORNTSF started task):

    S CHORNTSF
    

12. Restart the CA Chorus Application Server (CHORJBOS started task):

    S CHORJBOS
    

    The following message appears when CA Chorus Application Server startup is complete:

    ETJTC001I CA Chorus Startup Complete
    

    You have restored the H2 database.