Restoring data

Use the following steps to restore data back to the database.

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

    Oracle:

    This script needs to be run from a machine running Oracle client. The script can be found in:

    UNIX: /WBIConnect_Install_Dir/opt/IBM/WBIConnect/DBLoader/scripts
    /Oracle/import.sh
    

    Windows: \WBIConnect_Install_Dir\DBLoader\scripts\Oracle\import.bat
    

    The import script takes the following parameters for Oracle:

    DB2:

    This script needs to be run from DB2 command prompt after connecting to the database. The script can be found in:

    UNIX: /WBIConnect_Install_Dir/opt/IBM/WBIConnect/DBLoader/scripts
    /DB2/import.sh
    

    Windows: \WBIConnect_Install_Dir\DBLoader\scripts\DB2\import.bat
    
    The import script takes the following parameters for DB2:

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

    Example: ./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:
    UNIX: /WBIConnect_Install_Dir/opt/IBM/WBIConnect/bin
    

    Windows: \WBIConnect_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, 2004