Performance

In releases V5R4M0 and higher, if you are experiencing poor performance when viewing lists of integrated file system objects using the BRMS IBM i Navigator or IBM Director interface, use the STRSQL NAMING(*SYS) command to run these statements and improve performance:

CREATE INDEX QUSRBRM/TEST_INDEX_1 ON QUSRBRM/QA1AHS (BKHCMD ASC, BKHNET ASC, BKHSYS ASC, BKHSWT ASC, BKHLIB ASC, BKPKGN ASC, BKMFNB ASC)
CREATE INDEX QUSRBRM/TEST_INDEX_2 ON QUSRBRM/QA1ALI2 (LINAME ASC, LITYPE ASC)

Notes:

1. The CREATE statements may be long running.

2. Careful consideration must be made if the CREATE statements are used in release V5R4M0. In V5R4M0, if BRMS is re-installed using distribution media, the install will fail due to the existence of these indexes.
   To circumvent the failure, do one of the following:

   • Drop the indexes with the following SQL statements

     • DROP INDEX QUSRBRM/TEST_INDEX_1

     • DROP INDEX QUSRBRM/TEST_INDEX_2

   • Re-install BRMS from a SAVLICPGM created on a V5R4M0 system with PTF SI37269 applied.

3. The CREATE statements must be run again after BRMS product installs are performed.