The sample Q.SYSTEM_INI procedure provided with QMF makes SHARE=YES the default for all users.
When you specify the DSQSUSER parameter, QMF issues a CONNECT command to connect to the database. Thus, the rules for this parameter are the same as for the CONNECT command.
GRANT CONNECT TO userid IDENTIFIED BY password
-- -- QUERY D S Q 0 B I N I -- MANAGEMENT --------------- -- FACILITY -- -- Q M F S Y S T E M I N I T I A L I Z A T I O N P R O C -- ----- ----------- --------------------------- ------- -- -- FUNCTION: PROVIDE AN EXAMPLE QMF SYSTEM INITIALIZATION PROCEDURE -- THAT CAN BE ADDED AFTER QMF INSTALLATION. YOU MAY MOD- -- IFY OR REPLACE THIS PROCEDURE WITH YOUR OWN VERSION. -- -- THE PROCEDURE MUST BE STORED IN THE DATABASE UNDER THE -- NAME OF Q.SYSTEM_INI BEFORE IT WILL RUN AUTOMATICALLY. -- ------------ -- -- THE COMMAND BELOW IS AN EXAMPLE OF ESTABLISHING A NEW DEFAULT -- FOR THE SHARE OPTION OF THE SAVE COMMAND THAT WILL APPLY TO ALL -- QMF USERS. (REMOVE THE LEADING COMMENT SYMBOLS "--" TO ACTIVATE -- IT.) -- -- SET GLOBAL ( DSQEC_SHARE=1 -- MAKE SHARE=YES THE DEFAULT FOR ALL