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
Expand all | Collapse all

All JDBC Pool Alias definition residing under one DB Schema

  • 1.  All JDBC Pool Alias definition residing under one DB Schema

    Posted Tue August 19, 2008 05:42 PM

    Hi there experts,

    I am trying to fugure out what would be the pros and cons of having all Pool Alias Definitions setup under one DB Schema. What I mean to say is what are the pros and cons of having all the DB components like IS,MWS,TN,Audit,XREF,Dochist etc setup under one schema as opposed to each having its own schema.

    Any inputs would appreciated.
    Thanks
    -Scoobydoooooooooooooo


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


  • 2.  RE: All JDBC Pool Alias definition residing under one DB Schema

    Posted Wed August 27, 2008 04:59 PM

    In our development environment we have all components installed under the one schema and so far we have not had any issues with this approach (with one exception).

    The exception being the archiving component that will disable triggers required for monitor to see your process instances if archiving is run and lives on the same schema as the other components.

    Having said that I am anticipating that in the live environment components will be installed on seperate schemas for neatness and manageability reasons…


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