IBM recently announced   IBM DB2 DevOps Experience for z/OS . This new collaborative offering helps you bring Db2 applications to market faster with lower costs and less risk. With IBM DB2 DevOps Experience for z/OS, you can: Respond quickly to competitive and customer needs with faster delivery of new or changed Db2 applications. Enable the Db2 DBA to set criteria for application developers to create their own Db2 for z/OS application environments, with the DBA retaining control and approval over the databases changes. Enable... [More]

Tags:  devops announcement dba db2_tools application_developer

We're just a few days away from the start of the  IBM and IDUG Data Tech Summit at  IBM Silicon Valley Laboratory in San Jose, CA, the home of Db2 for z/OS!   If you aren't able to join in person, you still have an opportunity to join a livestream broadcast. Live from IBM Silicon Valley Lab - Breakthrough Announcements on Db2, AI, Machine Learning, DevOps, Analytics & More When: Monday, October 8, 2018 9:00... [More]

Tags:  webcast event

By Claire McFeely and Paul McWilliams . Version 6 of the SQL Reference for Cross-Platform Development   is available now! Developers who build applications that must be portable across the IBM Db2 family of database products can use the SQL Reference for Cross-Platform Development to ensure the portability of the SQL in their applications.  It describes the common set of SQL language features that are supported across all platforms by the Db2 family. The new Version 6 covers the following newest available... [More]

Tags:  db2_family sql programming application_developer

We're proud to announce that function level 503 (V12R1M503) is now available in Db2 12! IBM recently announced IBM Db2 AI for z/OS (Db2ZAI), and Db2ZAI is the biggest news in function level 503. IBM Db2 AI for z/OS Db2ZAI uses the Db2 optimizer and leverages IBM Machine Learning for z/OS technology to improve Db2 SQL access path selection and application performance, with rapid model learning specific to the data and Db2 subsystem configuration. For the full story on Db2ZAI, check out:... [More]

Tags:  continous-delivery db2zai db2z12

    IBM Db2ZAI is a new product that empowers the optimizer in the Db2 for z/OS engine to determine the best-performing query access paths, based on workload characteristics. We asked members of the Db2 development team for their thoughts on what IBM Db2 AI for z/OS will do for our clients, both now and in the future, and here's what they said*: Mo Townsend, Director of Development, Db2 for z/OS “ The first version is focused on delivering a value proposition of improved performance or reduced CPU. We will be looking to add... [More]

Tags:  db2zai

We're excited that today IBM announced IBM Db2 AI for z/OS (Db2ZAI) , which uses the Db2® for z/OS® optimizer and leverages IBM® Machine Learning for z/OS (ML for z/OS) technology to provide: Improved Db2 SQL access path selection Improved Db2 application performance Rapid model learning specific to the data and configuration per Db2 subsystem Models trained and deployed from Db2ZAI are managed by the security-rich infrastructure in ML for z/OS, which also gives defined users a window into the models' performance metrics.... [More]

Tags:  db2zai announcement db2z12

Mark your calendars if you use Db2 11 for z/OS! IBM announced in February 2018 that end of support for Db2 11 is September 30, 2020. Db2 11 for z/OS has already been withdrawn from marketing since July 2, 2018. General availability for Db2 12 for z/OS began on October 21, 2016.   Always get the latest news about  Db2 for z/OS from the IBM lab! How to subscribe Follow us on Twitter: @DB2zLabNews

By  Jane Man  and  Xiao Bo Wang . This post is adapted from an article that was originally published in October 2017 . Introduction In Db2 12 for z/OS continuous delivery, new capabilities and enhancements are delivered in the service stream as soon as they are ready. The LISTAGG function, which is used to aggregate a set of string values within a group into a single string, is the most important function in Db2 12 for z/OS function level 501. In this article, we'll... [More]

By John Campbell , Jennie Chang , and Regina Liu . This post is part of a series that provides John Campbell's perspective on new capabilities in Db2 12 for z/OS. Db2 12 for z/OS introduces a new partition insertion feature that provides the ability to add a new partition into the middle of an existing partitioned table space. This feature is implemented by a pending ALTER, which can be initiated by using an ALTER TABLE statement with ADD PARTITION ENDING AT and a new limit key value. You must run a REORG  TABLESPACE SHRLEVEL CHANGE or... [More]

Tags:  db2z12 administration dba jc_hits

By Paul McWilliams and Ann Hernandez. In the next installment of what is becoming a series about PDF format documentation for Db2 for z/OS, we want to answer some questions from reader comments on a previous post. Previous posts described recent changes to how we deliver PDF and discussed best practices for using PDF manuals , mainly suggesting that you always download the latest PDF whenever possible. Questions & Answers Q: "Theoretically there will now be more frequent changes;" Since we changed our PDF process in September... [More]

Tags:  documentation pdf

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... [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]