Managing Databases › Back Up the H2 Database › Run the H2 Database Backup

Run the H2 Database Backup

Important! We recommend that you schedule the H2 database backup job to run regularly, with more frequent backups during system setup.

Follow the backup policy for your site, and consult with your system administrator.

Follow these steps:

1. Verify that the setup for the H2 database backup is complete. See Prepare the H2 Database Backup.
2. Verify that you have BPX.SUPERUSR authority. This authority is required to unmount the databases later in this procedure.
3. Delete the file.trace.db.old files from the H2 database at INSTALL_HOME/database/h2. Repeat this step for each file.trace.db.old file in the H2 database. These files contain outdated database activity records that should not be included in the backup.

   rm INSTALL_HOME/database/h2/file.trace.db.old
   

   file

   Name of the file that you are deleting from the H2 database.

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

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

   P CHORNTSF
   

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

   unmount INSTALL_HOME/database/storage
   

7. Unmount the TSF Server database:

   unmount INSTALL_HOME/database/ntsf
   

8. Unmount the H2 database directory file system:

   unmount INSTALL_HOME/database
   

9. Run the JCL member for the H2 database backup. This JCL member was created in Prepare the H2 Database Backup.
10. Remount the H2 database directory file system:

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

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

12. Remount the TSF Server database:

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

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

    S CHORNTSF
    

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

    S CHORJBOS
    

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

    ETJTC001I CA Chorus Startup Complete
    

    You have created a backup of the H2 database.