Restoring data

To restore data to the database, follow these steps:

  1. Run the import script to copy the data to the database.

    Oracle

    The import script needs to be run from a machine running Oracle client. The script can be found in the following directories:

    UNIX: {INSTALL DIR}/DBLoader/scripts/Oracle/import.sh

    Windows: {INSTALL DIR}\DBLoader\scripts\Oracle\import.bat The import script takes the following parameters for Oracle:

    DB2

    The import script needs to be run from the DB2 command prompt after you connect to the database. The script can be found in the following directories:

    UNIX: {INSTALL DIR}/DBLoader/scripts/DB2/import.sh

    Windows: {INSTALL DIR}\DBLoader\scripts\DB2\import.bat

    The import script takes the following parameters for DB2:

    Syntax of import script:

    ./import.sh <archive location> <schema name>
    <database name> <database user name> <database password>

    Example using import script:

    ./import.sh /tmp/2003-01-01 db2inst1 bcgapps
    db2inst1 pa55word

  2. Run the Restore script to restore the payload files. The script can be found in the following directories:

    UNIX: {INSTALL DIR}/bin

    Windows: {INSTALL DIR}\bin

    The Restore script takes the following parameters:

    This program needs to be run on the machines which have the non-repudiation file storage system with admin/root privileges.

Copyright IBM Corp. 2003, 2005