We wrote in a previous post about Db2 for z/OS for Master Classes held for clients at IBM Silicon Valley Lab and IBM Hursley. Now the 2019 class schedule has been announced : June 24 - 28 at IBM Hursley near Winchester, Hampshire. September 23 - 27 at IBM Silicon Valley Lab in San Jose, California These invitation-only classes are taught by experts from the world-wide Db2 SWAT team and aimed at experienced professionals who want a deep dive into the internals of Db2 for z/OS. The subjects covered in the class include: Common issues related to... [More]

Tags:  education

By Eric Radzinski If you're headed to the IBM Think 2019 conference in San Francisco next week, don't miss an opportunity to hear from Db2 for z/OS technical leadership about our latest plans and innovations.  Details about their presentations and a link to a comprehensive list of z Analytics presentations are below.   We'll also be demonstrating the new features of Db2 AI for z/OS V1.2 at the Demo Center on Tuesday from 5:00 PM - 7:30 PM and on Friday from 8:00 AM - noon.    Empower IBM Db2 for z/OS with Machine Learning to Boost... [More]

Tags:  conference db2

By Paul McWilliams , based on John Campbell 's webcast. In Part 1 of his " Greatest Hits, War Stories, and Best Practices 2019 " webcast, IBM Distinguished Engineer John Campbell's provided some background on the subject of running out of the basic 6-byte log RBA addressing range in Db2 for z/OS. John said that this subject has become somewhat controversial because of conflicting recommendations given in various presentations, blog posts, and in face to face-conversations.  He also clearly outlined his strategy recommendations... [More]

Tags:  db2z11 best_practice jc_hits db2z12 migration

Calling all data professionals.  Now is the time to make your data ready for AI!  You are cordially invited to participate in the IBM Enterprise Db2 & Machine Learning forum. Discover best practices across data, analytics and open source projects. Hear about key new technologies and our latest offerings and solutions. This is your opportunity to gain insights on how to define the infrastructure needed to drive your current and future business requirements.   Date: 30th April 2019, IBM London - United Kingdom  Register today to secure your... [More]

Tags:  event

By Randy Nakagawa and Chris Crone . With all the focus on Db2 12 continuous delivery—with the associated function levels and application compatibility (APPLCOMPAT) levels, it might be difficult to notice changes in Db2 that are not tied to a new function level. However, not every change or enhancement in Db2 12 is tied to a function level or APPLCOMPAT level. APAR PH00637 is one such change that might be important to you, especially if you use cached dynamic SQL in your shop.  If you do, this is one APAR that you will want to kick the tires on... [More]

Tags:  performance db2z12 administration dba application

We're excited to announce the availability of IBM Db2 AI for z/OS 1.1.0.1 (Db2ZAI), which introduces the following capabilities: more accurate predictions of the benefit of parallel processing for static SQL, which can result in improved elapsed time and lower chargeable CPU determination of whether sort processes can benefit from increased memory utilization In addition, you can now choose to narrow the scope of operations to the package level, which means that you can target the packages that are most CPU intensive while minimizing the... [More]

Tags:  db2zai

Improve Db2 for z/OS performance by exploiting analytics and statistics Date and time: February 5, 2019 from 11am - 12pm EST Join a webcast by Db2 optimizer Guru and expert Terry Purcell to learn how you can exploit Db2 statistics to improve productivity. The Db2 optimizer relies on statistics about tables and indexes. In most cases, if the optimizer could exploit more complete and accurate statistics, queries would perform better. While, Db2 users often only gather standard or default statistics.... [More]

Tags:  administration performance webcast dba

APAR PH02437 introduces the new DSNB233I message in Db2 12 and Db2 11. The new message reminds you to convert page sets to the extended 10-byte RBA or LRSN format, to avoid outages that might occur if Db2 reaches the 6-byte logging limit. Db2 issues the DSNB233I message for the first 20 pagesets opened that remain in the 6-byte format. Db2 11 introduced support for the extended 10-byte RBA and LRSN , and you have the option to convert the bootstrap data set (BSDS) to the 10-byte format as soon as you migrate to Db2 11 new-function mode. Also,... [More]

Tags:  db2z11 db2z12 dba migration administration

DB2 for z/OS developer Jane Man recently posted in the IDUG Content Blog about modern application development in Db2 for z/OS. JSON SQL APIs and native REST services in DB2 for z/OS Do you know difference between the JSON capabilities and native REST services in Db2 for z/OS? In recent conference calls, many clients confused them. Some even thought they are the same thing. In fact, they are completely different. In her recent article, Jane describes the differences and shares answers to frequent questions about these modern application... [More]

Tags:  application application_developer

Perhaps you've read previous blog posts in our series that provides John Campbell's perspective on new capabilities in Db2 12 for z/OS. Now you have a chance to hear the latest updated for 2019, directly from John! "JC's Greatest Hits, War Stories, and Best Practices 2019" Register for Part 1 : http://ibm.biz/JCGreatestHitsPART1 January 29, 2019 11am - 12:30pm EST   Register for Part 2 : http://ibm.biz/JCWebcastPart2 January 30, 2019 11am - 12:30pm EST   This double session introduces and discusses some of most... [More]

Tags:  webcast db2z12 best_practice jc_hits

In a series of recent articles in the IDUG content blog,  Chris Crone and Meg Bernal describe three new SQL capabilities that  Db2 12 for z/OS introduces: piece-wise delete, enhanced MERGE capability, and new SQL pagination capabilities. Part 1—Piece-wise delete modification Chris and Meg discuss the piece-wise DELETE syntax in DB2 12, which allows the FETCH FIRST n ROWS ONLY clause to be specified on a searched DELETE statement. The new DELETE syntax enables clients to delete large numbers of rows from a table without severely... [More]

Tags:  application_developer application db2z12

By Rakshith Halevoor Prabhachand and Janet Figone   Your input and ideas, formalized via requests for enhancements (RFEs), are extremely valuable to the Db2 for z/OS team. This announcement describes the new tool that we'll use to collaborate on those suggestions. If you've ever submitted an RFE to the Db2 for z/OS Development team or have ever had the experience of checking the status of an RFE, you're likely familiar with the RFE tool on IBM developerWorks. For the past six years, this has been the interface that we've relied... [More]

In Db2 12 continuous delivery, activating a function level alone does not expose applications to changes introduced by the function level. To enable applications to use new capabilities in the function level, you must also rebind applications at the corresponding application compatibility (APPLCOMPAT) level. This separation enables applications to be developed, tested, and deployed at a specific application compatibility level, and remain stable across functions levels, until the application needs to take advantage of new capabilities in a... [More]

Tags:  dba administration db2z12 continous-delivery

In a series of recent articles in the IDUG Content Blog , IBM Db2 for z/OS developer Xiaohong Fu discusses the major Db2 temporal data enhancements delivered in Db2 12 for z/OS, and continuing in Db2 for z/OS continuous delivery, including: temporal logical transactions, temporal referential, and replication and temporal query enhancements for temporal auditing.   Part I—Temporal auditing enhancements in Db2 12 This article provides a brief roadmap of major temporal support across Db2 10, Db2 11, and Db2 12, and provides a detailed... [More]

Tags:  administration temporal db2z12 application