TN Database old data deletion.

, ,
1

Dear friends,

Good day :smiley:
We are using the webMethods 6.0.1 version.
We are planning to DELETE the old transactional data from TN database to free up the space. Current TN database size is 95GB :frowning:
For this we have analysed and decided to delete the old data from below tables.

  1. ActivityLog
  2. BizDocAttribute
  3. BizDocContent
  4. BizDocRelationship
  5. DeliveryJob
  6. BizDoc

Please let us know if we delete the old data from above tables, does it affect to TN functionalities? Any best solutions are highly appreciated.

Warm regards
Maitri.

2

Yes those are the heavier main tables eats more space and a regular archiving required.

It’s always safe to use wm.tn:archive service to do this maintanence thing…Please refer the TN Userguide for more information and you can schedule this service safely once you ran the TN archive table script provided by webMethods.

HTH,
RMG

3

Thank you very much for quick reply.

When we run the wm.tn:archive service first time, it will automatically create the archive tables in TN database?
Can I get the TN archive table script in webMethods advantage?

With Best Regards,
Maitri

4

Dear RMG,

I have found TN Archive script at \webMethods6\common\db\scripts\create\create_archive_TN_6-0-1_SQLServer.
Shall i run the above script and than execute wm.tn:archive service?

With Best Regards,
Maitri

5

YES…you can trial in some DEV/QA environment first and if you feel comfortable working fine then prod is best:

6

Thank you very much for your kind help :slight_smile:

7

your welcome any time:

8

Hi RMG,

We are using webMethods 6.0.1 version.
We have been given the .P7B certs by partner. How to extract the 2 certs in DER format inside .P7B?
Once extract the DER formatted certs, we should put these certs under ‘Trusted Certificates’ location in IS and restart the server? Please advise. Thanks

With Best Regards
Maitri.

9

Dear RMG,

Getting below error while startup webMethods 6.0.1 after archived the TN data by using wm.tn:archive service.
Please help how to resolve this issue.

2012-02-04 21:15:38 [ISS.0028.0012C] SpGeneralUtil: Startup service (GenStartup:putControlFileForSchedulers)
2012-02-04 21:15:38 [ISS.0028.0012C] SpGeneralUtil: Startup service (GenStartup:startUp)
2012-02-04 21:15:38 [ISS.0028.0012C] SpGeneralUtil: Startup service (GenStartup:activateUserPwds)
2012-02-04 21:15:39 [LGU.0001.0003C] Error creating broker admin client:
2012-02-04 21:16:23 [ISS.0004.0001V1] Loaded JDBC driver: com.inet.tds.TdsDriver

10

Dear RMG,

Found the solution. Please ignore my previous post. Above erro is not bacause of archival process.

Regards
Maitri

11

OK great: