Use the following steps to restore 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.batThe 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
UNIX: /WBIConnect_Install_Dir/opt/IBM/WBIConnect/bin
Windows: \WBIConnect_Install_Dir\bin
The Restore script takes the following parameters:
C:\Installers\DBOutput.txt
This program needs to be run on the machines which have the non-repudiation file storage system with admin/root privileges.