Retrieving data using SQL queries

You can create SQL queries to search for messages and display their contents. For example, to select all messages with the status ERROR, issue the following query:

SELECT MWH_WMQI_MSG_ID, MWH_MSG_GRP FROM schema.DNIV_MWH_ou
    WHERE MWH_MSG_STATUS = 'ERROR'

where schema represents the schema name of the runtime database, which is set by the DNIvSN placeholder.

Note: Querying the message warehouse can affect the overall performance of your FTM SWIFT instance. A poorly designed query might even lock out other FTM SWIFT services. Therefore, observe the following recommendations:

For your queries, create an index or a small number of indexes on the base table of the message warehouse. Otherwise, even a simple query on the message warehouse forces Db2® to scan the entire table.
If you search the LOB column, specify additional selection criteria to limit the scope of the query so that the LOB value is checked only for a small number of rows.
Never search or retrieve the values in the LOB column for a large number of entries while FTM SWIFT is running.