When someone is creating or modifying a Query, Query/400 puts a *SHRNUP lock on the file (working as designed apparently).�...
IBM has come up with a workaround.�Create a data area in QUSRSYS called QQULCKLVL and put 'LSRD' in it using the following command:
QSYS/CRTDTAARA DTAARA(QUSRSYS/QQULCKLVL) TYPE(*CHAR) + LEN(4) VALUE(LSRD) AUT(*USE)
This tells Query to put a *SHRRD lock on the file instead of a *SHRNUP.
Putting 'LSRO' or any other value in this Data Area will result in the *SHRNUP lock being placed on the file.