Database administration steps for the MSIF transfer service

Table 1 lists table spaces for which you can run utilities to improve overall database performance.
Table 1. Table spaces for which utilities improve database performance
Table Space Description
DNFOCD1 MSIF configuration data
DNFOFA Base state of all scenarios
DNFOFD Information related to download requests
DNFOFR Information related to requests to receive files
DNFOFS Information related to requests to send files
DNFOLD Large objects related to received InterAct requests
DNFOLH Information used for SAG event correlation and possible duplicate detection
DNFOMD Metadata related to the message warehouse
DNFOMI1S Miscellaneous information
DNFOMI2S Information related to file downloads and reattempting to receive files
DNFOMP IBM® MQ messages, for example, requests that are to be included in responses
DNFORM1 Information related to MsgReceived scenarios
DNFOSM Information related to SendMsg scenarios
DNFOTO Transfer options used by each message transfer or file transfer
Table 2 lists table spaces that store error information only. Running utilities for these table spaces improves database performance only if they contain a large amount of data.
Table 2. Table spaces that store error information
Table Space Description
DNFOFE Messages that caused errors
DNFORE1 Error information