What are the are the steps to use adminRN tool?
Article ID: KB0087058
Updated On:
| Products | Versions |
|---|---|
| TIBCO BusinessConnect RosettaNet Protocol | - |
| Not Applicable | - |
Description
Resolution:
Steps to use adminRN tool:
1> Create Archiving Schema. It should be separated from "live" SQL DB, by doing so, you can
Create different user to own this set of archiving schema. Eg. Archiver.
OR
This set of archiving schema located in different instance from the ¿live¿ SQL DB.
2> Provide the parameters to do the archive
1. period of time to archive.
2. which table wants to archive
a. audit (audit + related bin table)
b. nr (nr + related bin table)
c. both audit table pair + nr table pair
3> Archive the data from "live" Audit or NR to <Archiver> SQL DB
4> When Successful Purge data from "live" SQL DB
The logging you would see in the white window when you run the AdminRN utility.
Also there is a log file gets created in Archiving.log under tools/RosettaNet directory
Steps to use adminRN tool:
1> Create Archiving Schema. It should be separated from "live" SQL DB, by doing so, you can
Create different user to own this set of archiving schema. Eg. Archiver.
OR
This set of archiving schema located in different instance from the ¿live¿ SQL DB.
2> Provide the parameters to do the archive
1. period of time to archive.
2. which table wants to archive
a. audit (audit + related bin table)
b. nr (nr + related bin table)
c. both audit table pair + nr table pair
3> Archive the data from "live" Audit or NR to <Archiver> SQL DB
4> When Successful Purge data from "live" SQL DB
The logging you would see in the white window when you run the AdminRN utility.
Also there is a log file gets created in Archiving.log under tools/RosettaNet directory
Issue/Introduction
What are the are the steps to use adminRN tool?
Feedback
Yes
No
Powered by
