In some environments, it would be better to have SQL server mode work occur in the same subsystem as the job which is initiating the work. By default, QSQSRVR prestart jobs use the QSYSWRK subsystem for all SQL server mode connections.

This can be changed so that the subsystem choice is made upon first use of SQL server mode within a job and does not change for the life of that job.

To enable the switch, you should use the following command:

ADDENVVAR ENVVAR(QIBM_SRVRMODE_SBS) VALUE('*SAME') LEVEL(*SYS)

This will mean that all SQL server mode work will occur in the same subsystem as the job which is initiating the work. Please note that this is system wide change.

To disable the switch, you should issue the following command:

RMVENVVAR ENVVAR(QIBM_SRVRMODE_SBS) LEVEL(*SYS)

For further details please see https://www.ibm.com/support/pages/qsqsrvr-subsystem-customization