SQL_CALL information differs between Detector r14 and r20 related to Db2 version

Products

• Detector for DB2 for z/OS

Issue/Introduction

New install of Detector for Db2 for z/OS (PDT) release r20.

PDT SQL_CALL info is different between r14 and r20 which appear to be only in SQLJ type. 

 

In PDT r14 the SQL_CALL info was "OPEN,FETCH,DESCRIBE".  In PDT r20 the SQL_CALL info of the same SQL is "OPEN,COMMIT".

In other SQL, PDT r14 the SQL_CALL info was "OPEN,FETCH,DESCRIBE".  In PDT r20 the SQL_CALL info of the same SQL is "OPEN" only. 

In other SQL, PDT r14 the SQL_CALL info was "OPEN,FETCH,DESCRIBE".  In PDT r20 the SQL_CALL info of the same SQL is "OPEN,FETCH,COMMIT ". 

 

Why is the SQL_CALL information different between PDT r14 and r20?

Resolution

The noted differences are due to different versions of Db2 (between Db2 v9 and Db2 v12).

Between these two releases IBM made many changes processing DISTSERV which the SQLJ falls under.
Either in Db2 v10 or Db2 v11 IBM introduced changes for the COMMIT intercept and products are required to keep
up with IBM changes. Because of that Detector now processes the COMMIT which Detector did not do in the past.