IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

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.


#TechXchangePresenter
 View Only
Back to discussions
Expand all | Collapse all

Truncate to BizDoc DB table

  • 1.  Truncate to BizDoc DB table

    Posted Wed June 05, 2019 04:17 AM

    Dear. webMethods experts

    In our business, we are using webMethods 9.7 and ebXML packages, TN DB for B2B Interface.

    Recently, the size of BizDoc table which used at ebXML package gets bigger so we want to remove the data which in BizDoc table.

    Is there any side effect that if I truncate(DDL) the BizDoc table?

    If it is OK, I do like this.

    1. Stop the schedule of B2B Interface that use the BizDoc table.
    2. Copy the BizDoc table to backup Database server.
    3. Truncate to the BizDoc table.
    4. Start the schedule of B2B Interface that use the BizDoc table.

    Thank you for any reply that to this Message.


    #webMethods
    #edi
    #Integration-Server-and-ESB


  • 2.  RE: Truncate to BizDoc DB table

    Posted Wed June 05, 2019 07:55 AM

    I would recommend follow the “Archiving and Deleting Documents” from the below link

    http://techcommunity.softwareag.com/ecosystem/documentation/webmethods/wmsuites/wmsuite9-7/Trading_Networks/9-7_Trading_Networks_Administrators_Guide.pdf


    #Integration-Server-and-ESB
    #webMethods
    #edi


Related Content