In WebMethods71_TN database
Ineed to develop some scripts so that based on it,
It should archive these tables day to day…and delete the old stuff…
Can u suggest me how to work on this…
Should i need to create new databse,tables…and write the scripts…so that i can schedule that daily…and it gonna archive…and i need to delete the data from orginal archive tables…
Its urgent plz gimme some suggestions…and can anybody help for scripts…sql server 2005
The archive & Delete services provided by SAG are also supported by them, so if there is a problem you can call for support.
Using self developed scripts means you are accessing the internal db structure of a product internal db structure, which is usually not supported, so everything is on your own risk including that your TN stops working.
I would not recommend such n approach. If you want to do it neverthelesse I would recommend approaching SAG support or professional services for providing the scripts.
However, the DB tables are not complicated. Do an analysis of the tables and determine what you want/need to do.
I would recommend avoiding doing an archive of the tables (copying the data to another set of tables) since that is largely useless. None of the wM tools will be able to present that data and moving the data back into the live tables can be somewhat troublesome. I usually recommend simply deleting old data and having a relatively short time period for what is considered old–30 to 45 days should be sufficient. The TN DB should not be used for long-term storage.
Is it possible to have TN Table and TN Archive Tables in different shcema? If yes, how will TN Archive process will work in this approach? Please share your thoughts on good/not approachable implementation. We are trying to keep TN DB and TN Archive DB seperate if possible.
Thanks for your replies. We have created ARCHIVE tables in same schema now. After that when I am trying to execute archive built-in service, I am getting below error:
java.sql.SQLException: An attempt was made to access the SQL statement archive.del.allevents.before.this.time, which was not defined in the configuration file
Am I missing anything? We just ran DB component configurator to create schema.