Enabling support for multirow fetch and insert
The DSQSMRFI parameter controls whether the database uses multirow or single-row fetch and insert.
Use the DSQSMRFI parameter (MR) to control whether QMF uses multirow processing for database fetch and insert operations. With multirow processing, a single SQL statement can process several rows of data, resulting in decreased network traffic. The following commands take advantage of increased performance from multirow support:
- DISPLAY TABLE
- EXPORT DATA and EXPORT TABLE
- IMPORT TABLE
- PRINT REPORT and PRINT TABLE
- RUN QUERY or RUN PROC (when these specify retrieval operations)
- SAVE DATA
- When the command requires processing of XML or LOB data
- When you start QMF in the requester database with MR=YES, use the QMF CONNECT command to connect to a server other than Db2® for z/OS® Version 8.1.5 (or later), then proceed to issue a command that requires fetch or insert operations
- If MR is set to YES and you use a QMF command that includes a three-part name, both the requester where the command is initiated and the server to which the command is directed must be Db2 for z/OS 8.1.5 (or later) or the command fails. Start QMF with MR=NO if you will be issuing QMF commands with three-part names directed to servers other than Db2 for z/OS Version 8.1.5 (or later). Commands with three-part names cannot be directed to DB2® for VSE and VM servers.
- Depending on the capabilities of your query accelerator, the QMF DSQSMRFI (MR) program parameter might be of importance. Some query accelerators do not support queries that are run with rowset cursors. If QMF is started with the DSQSMRFI (MR) program parameter set to YES, QMF uses a rowset cursor. If your query accelerator does not support queries that are run with rowset cursors, start QMF with MR=NO.
- QMF supports operations with XML data only when you are connected to a database release that supports the XML data type.