I have installed the Archive component of the IS Core and Process Audit database (Audit_Archive) in MSSQL 2000 with IS 6.5 SP3. I was going through the tables and found that there are no tables starting with “ARCHIVE_” and the database structure is same as that of the AUDIT Database (Audit). I have 2 Questions now,
1.When we run the stored procedures mentioned in the guide “webMethods_Database_Guide_6_5_and_6_5_1.pdf”, where does this archive data go to? i mean, which tables does this archived data go to (since there are no tables starting with “Archive_”)?
- Should we install the Archive database component also in the same database schema as that of Audit database? So that we can run this stored procedures from the Audit database itself, instead of from the Archive database.