...
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:
The CREATE statements may be long running.
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 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.
The CREATE statements must be run again after BRMS product installs are performed.