In WebSphere Partner Gateway, 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 data files 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 needs to be run only 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 one of the following locations, depending on your platform:
UNIX: /opt/{INSTALL DIR}/DBLoader/scripts/Oracle/export.sh
Windows: \{INSTALL DIR}\DBLoader\scripts\Oracle\export.bat The export script takes the following parameters for Oracle:
Syntax of export script:
./export <system password> <connect string> <destination directory> <schema name> <cut off date YYYYMMDD>
Example of export script:
./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 one of the following, based on your platform:
UNIX: /opt/{INSTALL DIR}/DBLoader/scripts/DB2/export.sh
Windows: \{INSTALL DIR}\DBLoader\scripts\DB2\export.bat The export script takes the following parameters for DB2:
Syntax of export script:
./export <cutoff date YYYY-MM-DD> <archive location> <database name> <database user name> <database password>
Example of export script:
./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/{INSTALL DIR}/bin
Windows: \{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 or root privileges.
Syntax of the AR_NONREP_MAINTENANCE stored procedure:
Oracle: execute AR_NONREP_MAINTENANCE(YYYY-MM-DD)
DB2: call AR_NONREP_MAINTENANCE(YYYY-MM-DD)