IBM Support

Automatic cancel of QSQSRVR jobs when an application is ended

News


Abstract

Automatic cancel of QSQSRVR jobs when an application is ended

Content

You are in: IBM i Technology Updates > Db2 for i - Technology UpdatesDb2 for i Database Engineer (DBE) Enhancements > Automatic cancel of QSQSRVR jobs when an application is ended

When an application using SQL Server Mode is terminated and the SQL Server Mode connections have not been ended, the termination of the application job may completely end while the QSQSRVR job remains active performing a long running system operation.

Job termination has been improved to signal an SQL Cancel request to any QSQSRVR jobs being used by the application. The cancel will interrupt some long running operations, allowing the QSQSRVR job to observe that the application is ending.

SQL Server Mode users only need to apply the PTF to receive the improved cancel handling support.

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

Modified date:
11 April 2021

UID

ibm11169680