IBM and IDUG are teaming up to deliver a three-day IBM & IDUG Data Tech Summit at the home of Db2 for z/OS, IBM Silicon Valley Lab. The event takes place Monday, October 8th though Wednesday, October 10th 2018, in San Jose, California. The summit is designed for Db2 professionals, architects, developers and data scientists and features four content tracks: two parallel Db2 for z/OS tracks, an analytics and machine learning track, and application development track. The summit features sessions delivered by IBM lab experts such as John... [More]

By Paul McWilliams and Bruce McAlister . In Db2 11 and Db2 12, APAR PI79053 introduced a new QUIET option for the TOLWARN parameter for the DSNTIAUL program . APAR PH00572 will soon introduce the same change for several similar applications, including SPUFI and the DSTNTEP2 and DSNTEP4 programs.  When you specify the QUIET option for TOLWARN, the result is the same as YES, except that the programs suppress all SQL warnings for FETCH and OPEN statements if the SQLCODE is 0 or greater. Before the introduction of... [More]

By John Campbell , Claire McFeely , and Jennie Chang . This post is part of a series that provides John Campbell's perspective on new capabilities in Db2 12 for z/OS. Back in Version 9, Db2 for z/OS introduced very simple and minimal support for the SQL MERGE statement , only providing an upsert capability with limited functionality. This feature restricted MERGE statements to only accept a single INSERT clause and UPDATE clause. Now, Db2 12 for z/OS enhances MERGE statements to be consistent with the SQL 2016... [More]

Tags:  application_developer jc_hits application db2z12

Want to learn more about real-life practical preferred practices for the IBM Db2 for z/OS Utilities Suite? Check out the new IBM Redbooks Red paper: Db2 for z/OS Utilities in Practice by Craig Friske and Hendrik Mynhardt. This IBM® Redpaper™ publication helps Db2 Database Administrators, Db2 System Programmers, and anyone who runs Db2 for z/OS utilities implement best practices. The intent of this paper is not to replicate the Db2 for z/OS Utilities Reference Guide or the Db2 for z/OS Installation Guide. This paper describes and... [More]

By Eric Radzinski . For many Db2 for z/OS customers, Query Management Facility (QMF) is a crucial and indispensable piece of their enterprise. They rely on QMF as a means to easily and efficiently reveal insights into their business data and to render those insights visually on dashboards and as reports, charts, and graphs. And QMF provides a whole lot more, including analytical functions, data editing capabilities, and application development interfaces that enable QMF functions to be integrated within existing applications. QMF is what... [More]

Tags:  qmf db2z12

By Paul Read and Paul McWilliams . In a recent post in the IBM UK Lab Campus blog, Early Experience Programs manager Paul Read wrote about the first week-long Db2 for z/OS Master Class to be held by IBM in Europe . Db2 Masterclass in Hursley In a first for IBM in Europe, the Early Experience Programs brought a popular Db2 for z/OS Master Class to a multinational audience. First class teachers The class was led by John Campbell, Florence Dubois, Adrian Burke, and Gareth Jones of the world-wide Db2 SWAT team, with decades of experience... [More]

Tags:  education

The Db2 for z/OS REST video series explains how to set up, authorize, create, bind, discover, and invoke REST services in Db2 for z/OS.   Related information Getting started with Db2 native REST service provider (blog post) IBM Knowledge Center: Db2 Rest Services (IBM Knowledge Center)

IBM Machine Learning for z/OS is an end-to-end enterprise machine learning solution that brings advanced predictive capabilities to the mission-critical Z platform. Leveraging the combined strength of IBM proprietary industry-leading technologies, such as IzODA Spark and Db2, and popular open source contributions, the solution enables you to capitalize on actionable intelligence from real-time transaction data and to do so without leaving the secure Z environment. Since the inaugural release of Machine Learning for z/OS last year, teams across... [More]

Tags:  db2znews machine_learning_for_z/os

In the last blog post in the education series, Tim discussed the Db2 SQL Coding badge offered by InterSkill. Another company that offers Db2 skill courses is ExitCertified. They offer a variety of instructor-led classroom or virtual courses as well as self-paced learning including the Db2 11 for z/OS Application Programming Workshop.    ExitCertified’s Application Programming Workshop is intended for users who have experience with COBOL or PL/I for z/OS. The course is offered as both an instructor-led class or as a self-paced... [More]

Tags:  db2z11 education db2z12

By John Campbell , Terry Purcell , and Paul McWilliams . This post is part of a series that provides John Campbell's perspective on new capabilities in Db2 12 for z/OS.   In Db2 12, you can expect to see increased use of list prefetch access, and possibly more use of hybrid join access paths by design, except where Db2 previously chose a sort-avoidance access plan, such as for statements that use SQL pagination . Db2 12 introduces enhancements to the optimizer cost model, to more closely reflect the true costs and benefits of list... [More]

Tags:  performance dba jc_hits administration

By John Campbell and Paul McWilliams . This post is part of a series that provides John Campbell's perspective on new capabilities in Db2 12 for z/OS.   Dynamic SQL statements are more susceptible to creating performance problems than static SQL. A full PREPARE occurs for every miss in the dynamic statement cache, and such SQL statements might go through query optimization several times per day. Whereas, with static SQL, the access paths are determined at bind time and the access path is stabilized and reused until the next BIND or... [More]

Tags:  dba administration performance jc_hits

By Guilherme Saueressig and Paul McWilliams . IBM is working to transform our tools for GDPR readiness . As part of that effort Enhanced Customer Data Repository (ECuRep) servers, including the IBM Boulder Test Case Data Repository ('testcase') servers, now require an authenticated log-in using an IBM Support File Transfer ID and password (token), and they support only secure transfer protocols.   Beginning on May 24, 2018, to exchange data with IBM using either the 'testcase' or ECuRep servers, you  must now use an... [More]

Don't miss this live event - June 19th at 11:00 AM EST REGISTER AT:  http ://b it.l y/Db 2_Ju ne1 9   GDPR compliance (General Data Protection Regulation of the European Union) went into effect on May 25th of this year. GDPR has many facets and affects many things from how you manage your customer data to providing backup and recovery services.   This webcast looks at GDPR and other topics that provide more data security and protection, such as Multi-Factor Authentication (MFA), Transparent Data Encryption (TDE), and auditing... [More]

Tags:  security gdpr encryption

By John Campbell and Paul McWilliams . This post is part of a series that provides John Campbell's perspective on new capabilities in Db2 12 for z/OS.   One of the biggest challenges for application developers is writing good SQL for pagination — returning a portion of a result set based on data position—that performs well for both pseudo conversational transactions and also for batch programs, when starting from an intermediate commit point. Several possible solutions exist, ranging from the use of... [More]

Tags:  jc_hits application_developer application db2z12