IBM Db2 for z/OS

Welcome to the new home of the Db2 for z/OS News from the Lab blog and more. Here you can find the latest news about the leading enterprise data-server technology powering business-critical transactions and analytics, subscribe to notifications, and join the discussion about Db2 for z/OS!

How to Subscribe

To subscribe to notifications, complete the following steps:

  1. Sign in at the top right corner of this page.
  2. After you sign in, click Join Group.
  3. Optionally, go to the notification settings for your account, find the Db2 for z/OS group in the table, and set your notification preferences as desired.

Get the latest Db2 for z/OS news

About Db2 for z/OS

Related IBM communities and groups

Other Db2 for z/OS communities


#Db2Znews
#Db2z/OS
#Db2World
#Db2ZAI

Announcements

Latest Posts

  • 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' ...

Latest Articles

  • 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 ...

    2 people recommend this.
  • 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 ...

    5 people recommend this.

Latest Files

Upcoming Events


Community Members
493 Members
group Admin
group Moderator
group Leadership
group Admin
group Moderator
group Leadership
group Admin
group Moderator
group Admin
group Moderator
group Admin
group Moderator
group Admin
group Admin
group Moderator
group Admin
group Moderator
group Admin
group Admin
group Moderator
group Admin
group Moderator
group Admin
group Moderator