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.

 View Only
  • 1.  WMProcess table contents

    Posted Wed January 04, 2006 01:48 PM

    Do we have any documentation regarding the possible status of the instances inside this table? I want to create an Oracle procedure to automate the clean up of the tables… I want to program this script only to delete the instanceIDs that have status completed in Monitor.

    Regards,

    Kleber Ferreira


    #webMethods
    #Integration-Server-and-ESB
    #webMethods-Architecture
    #webMethods-General


  • 2.  RE: WMProcess table contents

    Posted Fri January 06, 2006 07:41 PM

    Additional doubt:
    In order to get a best performance in my company database, we find out that the field called contextid, inside of WMProcessStep is not part of any index.
    As we have a problem opening an instance pipeline in Monitor (the oracle database stopped to answer the clients requests), we are considering to create an additional index to this table. The index will be the contextID itself.

    Any suggestion about this problem?

    Regards,

    Kleber Ferreira


    #Integration-Server-and-ESB
    #webMethods-General
    #webMethods-Architecture
    #webMethods


  • 3.  RE: WMProcess table contents

    Posted Fri January 06, 2006 08:14 PM

    There are archive services provided by wM in WmMonitor/pub/monitor/archive and you can archive right from the lower left hand side of the WmMonitor page. We however found that if you are trying to archive large amounts of data, these are pretty inefficient. Because of confidentialilty reasons I can not share the source code of the stored procs we wrote, but I can tell you that we set the debug level to 10 on the IS and then ran the supplied archives to view the sql that was executed. Then we tuned those statements.

    We also added an index for contextid and did not experience any problems. Additionally we have one for audittimestamp and another with the columns (instanceid, instanceiteration, stepid, and stepiteration). I can’t remember if either of these were supplied by wM or not however.

    Good luck!
    Tim


    #webMethods-General
    #Integration-Server-and-ESB
    #webMethods
    #webMethods-Architecture