Join/Signup
To subscribe to notifications, complete the following steps:
Last updated: 02-Mar-2018.
Thanks a lot James. We had "COMMIT+1" locks only on SKPTs (no other resources were involved). Now we realized that KEEPDYNAMIC(YES) was the reason for that holding the prepared statements in the local cache. With KEEPDYNAMIC(NO) the locks disapeared ...
LOCK DURATION The lock duration: COMMIT Until commit (QW0021DR=x '40') COMMIT+1 Past commit; applies to locks needed to maintain the position for a cursor opened WITH HOLD (QW0021DR=x '41') https://www.ibm.com/support/knowledgecenter/SSUSPA_5.4.0/com.ibm.omegamon.xe.pm_db2.doc_5.4.0/ko2rr/r0021out.htm ...
Hi, can someone explain the difference between "COMMIT" and "COMMIT+1" (QW002140 and QW002141)? I can't find a description for these values of the "Lock Duration" field. Thanks SDSNMACS(DSNDQW00) QW0021DR DS X * LOCK DURATION * QW002120 EQU X'20' ...
By John Lyle, Chris Leung, and Jennie Chang. With the End of Support (EOS) for Db2 11 for z/OS approaching on March 31st, 2021, migrating to Db2 12 will soon be an essential step to take if you haven't done so already. New instrumentation ...
By Shu Li Kragness and Paul McWilliams. We've written previously about how secure protocols are now required for exchanging data with IBM Support, and more changes are coming soon. The following changes to the anonymous FTP server and the FTPS ...
Register for DB2 for z/OS technical sessions at Data & AI on IBM Z Technical Symposium IBM will be hosting this complimentary virtual event to learn how you can use IBM Z data for modern engagement, analytics and AI applications to become ...
This is a quick email to remind you that the Enterprise Data and AI on IBM Z Virtual Event is kicking off on Tuesday, May 19. Secure you place now - once you register you have access to the complete replay series We look forward to seeing you at ...
With 6 months remaining until Db2 11 for z/OS end of service (EOS), while most clients are working with Db2 12, completion of production migrations is slower than originally anticipated. As a result, we have announced an extension of the EOS for Db2 11 ...
Db2 11 for z/OS reaches end of service (EOS) on September 30, 2020 . Make the move to Db2 12 for z/OS ...
Check out smarter query optimization with Db2 AI for z/OS! Enhancing the performance of a Db2 system ...
Optimizing the performance of database systems and applications is time consuming and costly. Database ...