Come for answers, stay for best practices. All we're missing is you.
When is it recommended to use file store vs. data message store when creating bus members?
Greg,
One reason would be that Only a single user (read MDM Developer) can connect successfully to Messaging Queues on the Development Environment since the SIB on WAS locks the tables corresponding to it on the DB. Once the tables are locked no other user/developer can connect to the same or use the messaging services. Here’s some more info on that particular topic:
https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/Switching%20from%20Data%20Store%20to%20File%20Store%20on%20WAS%20%20for%20IBM%20Infosphere%20MDM
Hope this is helpful!
In Maximo, the most common reason to configure a db store is to support a horizontal cluster. Before mxe.name and the run and donotrun sys properties, you might see multiple db's/schemas configured in a clustered environment.