Problem solve Get help with specific problems with your technologies, process and projects.

Query locking problem

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.


Dig Deeper on Implementation

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close