A fix is available
APAR status
Closed as program error.
Error description
Dynamic statement is not put into the Dynamic Statement Cache when using the Concentrate Statements with Literals prepare attribute .
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 10 or 11 for z/OS users of an SQL * * statement containing a comparison operator * * with GRAPHIC column and a literal constant, * * and it is a dynamic statement prepared with * * attribute CONCENTRATE STATEMENTS WITH * * LITERALS. * **************************************************************** * PROBLEM DESCRIPTION: The dynamic statement that contains a * * comparison operator except LIKE with a * * GRAPHIC column and a literal constant * * and is prepared with attribute * * CONCENTRATE STATEMENTS WITH LITERALS * * may not be cache-matched with the * * existing cache statement even though * * it is qualified for literal constant * * reuse. * **************************************************************** * RECOMMENDATION: * **************************************************************** An example is shown below: CREATE TABLE T1(C1 INTEGER NOT NULL WITH DEFAULT, C2 GRAPHIC(4) NOT NULL WITH DEFAULT) CCSID UNICODE; TCGHV1 = 'SELECT C1, C2 FROM T1 WHERE C1 = 1234 AND C2 = ''ABCD'' ' ; TCGHV2 = 'SELECT C1, C2 FROM T1 WHERE C1 = 0012 AND C2 = ''ABCD'' ' ; ATTRHV = 'CONCENTRATE STATEMENTS WITH LITERALS' ; EXEC SQL PREPARE STMT1 ATTRIBUTES :ATTRHV FROM :TCGHV1 ; EXEC SQL EXECUTE STMT1; EXEC SQL PREPARE STMT2 ATTRIBUTES :ATTRHV FROM :TCGHV2 ; EXEC SQL EXECUTE STMT2; DB2 did not correctly process the second dynamic statement during PREPARE and it's not cache-matched with the existing cache statement even though it is qualified for literal constant reuse.
Problem conclusion
DB2 has been modified to correctly process the SQL statement. Additional Keywords: SQLDYNSTMTCACHE
Temporary fix
Comments
APAR Information
APAR number
PI80334
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-04-20
Closed date
2017-05-23
Last modified date
2017-07-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
016AC4 PI81571 UI47497 UI47498
Modules/Macros
DSNXOCKL
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
05 July 2017