Welcome to the IBM TechXchange Community, a place to collaborate, share knowledge, & support one another in everyday challenges. Connect with your fellow members through forums, blogs, files, & face-to-face networking.
IBM TechXchange Community Together, we can connect via forums, blogs, files and face-to-face networking. Find your community
To the Db2 for z/OS Community, it gives me great pleasure to announce that Haakon Roberts is assuming the role of Director of Development for Db2 for z/OS and Db2 Tools effective immediately. Many of you are already familiar with Haakon and know that he has been a highly respected member and...
1 Comment - no search term matches found in comments.
Haakon Roberts is a name that many Db2 for z/OS customers are familiar with. As a key member of the Db2 for z/OS technical leadership team, he devotes much of his time to interacting directly with the people who depend on Db2 for z/OS to run their businesses, whether that be at conferences, on...
In both Db2 12 and Db2 13, the Db2 for z/OS declarations generator (DCLGEN) was recently enhanced by new-function APARs that deliver the following improved support of certain data types. COMP-5 declarations for integer data in COBOL applications With PH42857 in Db2 12 and in Db2...
Introduced in Db2 13, SQL Data Insights brought artificial intelligence (AI) functionality to the Db2 for z/OS engine. It provided the capability to run SQL AI query to find valuable insights hidden in your Db2 data and help you make better business decisions. SQL DI prepares AI functions by...
With the availability of the PTF for APAR PH51469 , you can now activate function level V13R1M503 in Db2 13 for z/OS. Function level 503 introduces the following new application capabilities in Db2 13 for z/OS: New default values in existing rows for added ROW CHANGE TIMESTAMP...
Starting in Db2 13 at function level 500, application developers and DBAs have new controls over lock contention situations, with the CURRENT LOCK TIMEOUT special register and DEADLOCK RESOLUTION PRIORITY built-in global variable . Before the availability of these new controls, application...
The first edition of IBM Db2 13 for z/OS Performance Topics is now available from IBM Redbooks! It provides performance comparisons between Db2 13 and Db2 12, including high-level performance expectations when you migrate to Db2 13. Db2 13 delivers significant innovations that can improve...
By Long Tu with Paul McWilliams. Starting in function level 500 or higher with APAR PH51359 (December 2022), Db2 13 for z/OS supports stacking of certain pending data definition changes (DDL) when you use the new capability in Db2 13 to convert a table in a partition-by-growth (PBG)...
The stability of Db2 for z/OS systems is legendary. That stability is based upon a partnership between Db2 development and the customer, where each party has a responsibility that cannot be wholly mitigated by the other. Haakon Roberts recently described the Db2 for z/OS development side of this...
Does your Db2 system hit its specified MAXDBAT limit regularly? If it does, you might need to evaluate whether your MAXDBAT and CONDBAT settings are configured to allow your Db2 subsystem to run with optimal performance. The MAXDBAT subsystem parameter controls the maximum number of database...