Database storage and table names

You can configure the data source and table name used to manage messages for the queue or topic by setting the Data Source and Database Properties. See “Data source and database tuning” for performance considerations.

The default table name for queues and topics is jms_pm, which results in all queues and topics using a single table. If a single table becomes a bottleneck when using multiple queues and topics, specify different tables for each queue and topic. The database server may be better able to handle the load using multiple tables. You can also use different data sources to run queues and topics from different database servers.