| Re: OTM table sizing
Also, the best way to reduce OTM DB growth is to setup and utilize the purge packages/procedures mentioned in the OTM Administration guide. This often requires customization of the processes to get them to fully work (we've done this for a lot of clients), but should improve significantly in OTM v6.0.
This process will purge out the integration XML that is saved for incoming and outbound transmissions, which can account for 70-80% of your database growth.
--Chris |