Previous Topic: Prepare the H2 Database BackupNext Topic: Restore the H2 Database


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 JBoss server (CHORJBOS started task):
    P CHORJBOS
    

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

  5. If CA Chorus for Storage Management is installed, unmount the CA Chorus for Storage Management database:
    unmount INSTALL_HOME/database/storage
    
  6. Unmount the H2 database directory file system:
    unmount INSTALL_HOME/database
    
  7. Run the JCL member for the H2 database backup. This JCL member was created in Prepare the H2 Database Backup.
  8. Mount 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_dbINSTALL_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. Restart the JBoss server (CHORJBOS started task):
    S CHORJBOS
    

    The following message appears when the JBoss server startup is complete:

    ETJTC001I CA Chorus Startup Complete
    

    You have created a backup of the H2 database.