In Business Integration Connect, archiving is used to move the inactive (non-repudiation) content to a safe media. Archiving consists of removing old data from the LG_MSG_ARCHIVE and LG_CERT_ARCHIVE tables. It also moves the payload datafiles from the non-repudiation store on the file system to the archive. The archived files can be restored if the non-repudiation data is needed.
Oracle:
For Oracle, the catexp.sql or catalog.sql script needs to be run to allow the database to be exported. Refer to the Oracle documentation for details. The catexp.sql or catalog.sql script only needs to be run once on a database. You do not need to run it again before you perform the export.
Before you begin using Export, confirm the following:
The export script needs to be run from a system which has the Oracle client installed. Also, the ORACLE HOME, ORACLE SID, and ORACLE PATH environment variables must be defined. The script is located in:
UNIX: /opt/IBM/WBIConnect/DBLoader/scripts/Oracle/export.sh
Windows: \WBIConnect_Install_Dir\DBLoader\scripts\Oracle\export.bat
The export script takes the following parameters for Oracle:
Syntax: ./export <system password> <connect string> <destination directory> <schema name> <cut off date YYYYMMDD>
Example: ./export password connectstring /tmp bcgapps 20030101
The archive, named export.dmp, and the export.log file will be added to the /tmp/20030101 folder.
DB2:
The export script needs to be run from the db2 command window after establishing a connection with the database. The script is located in:
UNIX: /opt/IBM/WBIConnect/DBLoader/scripts/DB2/export.sh
Windows: \WBIConnect_Install_Dir\DBLoader\scripts\DB2\export.bat
The export script takes the following parameters for DB2:
Syntax: ./export <cutoff date YYYY-MM-DD> <archive location> <database name> <database user name> <database password>
Example: ./export 2003-01-01 /tmp bcgapps bcgapps db2inst1 pa55word
The archive and the msgarchive.txt log file will be added to the /tmp/2003-01-01 folder.
UNIX: /opt/IBM/WBIConnect/bin
Windows: \WBIConnect_Install_Dir\bin
This script needs to be run on the machines which have the non-repudiation file storage system. Also, this script must be run with administrator/root privileges.
Oracle: execute AR_NONREP_MAINTENANCE(YYYY-MM-DD)
DB2: call AR_NONREP_MAINTENANCE(YYYY-MM-DD)