DB2 v10 for z/OS provides a new Dynamic Cache enhancement feature with the use of attribute "CONCENTRATE STATEMENTS WITH LITERALS". The use of the feature results
in more sharing and reuse of cached statements.
Could someone help provide a example that sets the attribute via perl db2 code. I am using perl 5.8 and perl 5.10 version. I have been able to use the feature via Rexx.
Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
Pinned topic DB2 V10 z/OS CONCENTRATE STATEMENTS via Perl DB2
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-02-26T15:59:47Z at 2013-02-26T15:59:47Z by SystemAdmin
SystemAdmin 110000D4XK3105 Posts
Re: DB2 V10 z/OS CONCENTRATE STATEMENTS via Perl DB22013-02-26T15:59:47ZThis is the accepted answer. This is the accepted answer.can you post the code you tried and the error you get?
I never used perl but you should be able to specify that in the prepare command