webMethods

webMethods

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

Pruning DB in Integration Server amp Trading Networks

  • 1.  Pruning DB in Integration Server amp Trading Networks

    Posted Fri April 11, 2003 12:09 PM

    Hello,
    Is there any way provided by WM to prune Database used for Integration Server & Trading Networks…
    if so, please let me know the way to do it.
    Thanks in advance.
    Balaji Kuduva


    #webMethods
    #B2B-Integration
    #Integration-Server-and-ESB


  • 2.  RE: Pruning DB in Integration Server amp Trading Networks

    Posted Mon April 14, 2003 08:20 AM

    we use a combination of the following:

    1. built a wrapper service around wm.tn.archive:archive (refer to TN built in services doc) and scheduled this service through IS.
    2. Delete records from BIZDOCCONTENT older than x days, with typename = ‘xxx’ for those messages that contain a large amount of content and should be deleted sooner than those picked up by 1) above. This keeps the storage size down but still allows for a longer period of audit records at a ‘what happened when’ level.
    3. delete records from ACTIVITYLOG (which 1) doesn’t).
    4. Reorganized the Trading Network schema for storage and
      performance improvement. This schema as created by the default wM .sql for oracle, doesn’t have any storage parameters and has indexes in same tablespace as tables, which is very BAD.

    regards


    #Integration-Server-and-ESB
    #webMethods
    #B2B-Integration


Related Content