Db2 for z/OS - The AI Database

nested-group-icon.png

DB2

Welcome to the IBM Community for Db2 for z/OS, the leading AI enterprise database for mission-critical data with over 35 years of proven history.
To always be notified of the latest updates, sign in and join this group.

If you have any feedback how we can improve this community, send an email to Surekha Parekh.

Announcements

Latest Posts

  • Hi. I have considerable experience in Oracle PL/SQL and now I am in a DB2 on zOS project. So far I understand, that SQL PL is the tool, you would want to use for writing programs with a lot of data manipulation. Right? Where do I start, besides the IBM ...

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

Latest Articles

  • Most Db2 for z/OS organizations are running the latest version of the product (Version 12). Where are you with the implementation Db2 12 and Function Level features and functions you need to take advantage of the benefits they can deliver to both you ...

  • We are excited to announce that the first iteration of IBM Db2 for z/OS Developer Extension is available now as a free downloadable extension in the Visual Studio Code Marketplace . Db2 Developer Extension simplifies and modernizes the experience ...

    1 person recommends this.
  • In Db2 12, with the PTF for APAR PH19242 applied, you can now use the DSN1COMP stand-alone utility to estimate the space savings that you might realize by compressing your data in Db2 for z/OS table spaces with IBM z14 hardware-based Huffman compression ...

  • By Jim Pickel and Paul McWilliams. In Db2 12 with APAR PH16111 applied, you can now use more detailed location statistics to better understand the behavior of your remote applications, how work coming from network connections is changing, and ...

    1 person recommends this.
  • By Eric Radzinski The latest release of IBM Db2 AI for z/OS, Db2ZAI 1.3.0, which is generally available as of June 19th, comes equipped with an entirely new feature called Distributed Connection Control that's designed to ease the burden of ensuring ...

Latest Files

Community Members
543 Members
group Admin
group Moderator
group Leadership
group Admin
group Moderator
group Leadership
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 Admin
group Moderator
group Admin
group Moderator