WebSphere brand IBM WebSphere Premises Server, Version 6.1.x

Backing up and restoring data

This topic describes how you back up historical and event data for Location Awareness Services for WebSphere® Premises Server.

About this task
You are responsible to back up historical and event data for Location Awareness Services for WebSphere Premises Server. This data is stored in the Location Awareness Services for WebSphere Premises Server databases and the CEI events database. You can use the database management system (DBMS) to automatically schedule backups, archive, and delete tasks or you can manually back up these databases.

Go online to see the DB2® information center for more information.

Note: Once you make a backup you can replay the transaction logs that were used during the online backup. The data stored in the backup image will be replayed. However, if you wish to replay transactions after you back up databases, ensure that your log files are in the path where they were archived and that the subdirectories are in the data directory, such as in C:\DB2_Archived_Logs\DB2\ATLASDB\NODE0000.

Backing up your databases while online

Before you begin
Prior to backing up your system, make sure that:
  • The DB2 backup batch files are in the same directory and that the log files are also created in the directory where the batch files are located. The DB2 scripts are shipped with Location Awareness Services for WebSphere Premises Server in the LAS_HOME\DB2\Backup Restore directory.
  • The following directories exist:
    • C:\DB2_Database_Backups: Directory where the database backups are stored
    • C:\DB2_Archived_Logs: Directory where DB2 stores the archived log files
    • C:\DB2_LOGTEMP: Directory where temporary log files are created during the roll forward operation of logs stored in the database backup image
About this task
The following instructions describe how to back up your databases when you are online, which allows you to be connected to the database. To perform a backup, do the following:
Procedure
  1. Set up the environment by running the DoSetupBackup.bat script. It calls the setupbackup.bat script.
  2. Schedule online backups of the ATLASDB and EVENT databases using the Windows® at command and the DoONLINEBackups_Runstats.bat command from the C:\DB2_Backup_Scripts directory:
    Note: The DoONLINEBackups_Runstats.bat command also updates statistics for the tables in both databases after the backups are done. The script can also be run manually from a command prompt in the directory where the file is located and calls the following scripts:
    • OnlineBackup_Databases.bat: Creates an offline backup of the ATLASDB and EVENT databases
    • ATLASDB_RUNSTATS.bat: Updates the statistics for the ATLASDB database
    • EventDB_RUNSTATS.bat: Updates the statistics for the EVENT database
    1. To run a weekly backup at 00:30 on Sunday morning, run the following command:
      at 00:30 /every:Sunday "C:\DB2_BACKUP_SCRIPTS\DoOnlineBackups_Runstats.bat"
    2. To run a backup every day at 00:30, run the following command (on one line):
      C:\DB2_Backup_Scripts>at 00:30 /every:Sunday,Monday,Tuesday,Wednesday,
      Thursday,Friday,Saturday "C:\DB2_BACKUP_SCRIPTS\DoOnlineBackups_Runstats.bat" 
    3. To delete an entry from the at list, run the following commands:
      1. Run at to list the scheduled tasks:
        at
      2. Use the ID from the list to delete the entry:
        at task_ID /DELETE
      3. Run at again to verify that there are no entries in the list:
        at

Backing up your databases while offline

Before you begin
Prior to backing up your system, ensure that:
  • All backup scripts are located in the C:\DB2_Backup_Scripts directory. The scripts for offline backups are shipped with ATLAS in the LAS_HOME\DB2\Backup Restore\OFFLINE (cold) backups directory.
  • No users are active in the system and that WebSphere Application Server is not running.
  • The following directories exist:
    • C:\DB2_Database_Backups: Directory where the database backups are stored
About this task
The following instructions describe how to back up your databases when you are offline, which means that users cannot be connected to the database.
Note: To turn off log archiving and allow only offline backups, run the DoTurnOffArchiving.bat script.

To make a backup, do the following:

Procedure
Schedule offline backups of the ATLASDB and EVENT databases using the Windows at command and the DoBackups_Runstats.bat command from the C:\DB2_Backup_Scripts directory:
Note: The DoBackups_Runstats.bat command also updates statistics for the tables in both databases after the backups are done. The script can also be run manually from a command prompt in the directory where the file is located and calls the following scripts:
  • Backup_Databases.bat: Creates an online backup of the ATLASDB and EVENT databases
  • ATLASDB_RUNSTATS.bat: Updates the statistics for the ATLASDB database
  • EventDB_RUNSTATS.bat: Updates the statistics for the EVENT database
  1. To run a backup weekly at 00:30 on Sunday morning, run the following command:
    at 00:30 /every:Sunday "C:\DB2_BACKUP_SCRIPTS\DoBackups_Runstats.bat"
  2. To run a backup every day at 00:30, run the following command (on one line):
    C:\DB2_Backup_Scripts>at 00:30 /every:Sunday,Monday,Tuesday,Wednesday,Thursday,
    Friday,Saturday "C:\DB2_BACKUP_SCRIPTS\DoBackups_Runstats.bat" 
  3. To delete an entry from the at list, run the following commands:
    1. Run at to list the scheduled tasks:
      at
    2. Use the ID from the list to delete the entry:
      at task_ID /DELETE
    3. Run at again to verify there are no entries in the list:
      at

Restoring databases

Before you begin
Prior to running the script, verify the following:
  • The database you are restoring was dropped.
  • There is only one backup image file in the path of the database backup. For example, the ATLASDB database should only have one data directory with one backup file in that directory, such as C:\DB2_Database_Backups\ATLASDB.0\DB2\NODE0000\CATN0000\20060330.
About this task
To restore a single database, run the DoRestoreOneDB.bat script from a command line, which calls the RestoreToNewDatabase.bat script.

Library | Support | Terms of use

(c) Copyright IBM Corporation 2004, 2008. All rights reserved.
U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.