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:  continous-delivery dba administration db2z12

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:  db2z12 temporal application administration

Db2 for z/OS Utilities Suite continues to deliver new features and enhancements to further  simplify and reduce the cost of database management. Continuous delivery has enhanced the ability for IBM Db2 Utilities to deliver new features supporting not only Db2 engine enhancements, but delivering value to your business in terms of availability, performance and reducing overall cost. In the webcast, we'll focus on some of these enhancements that you'll find in Db2 12, as well as a significant number of them available for use with Db2... [More]

Tags:  db2z11 administration utilities db2z12 webcast

By Jae Lee and Paul McWilliams .   In  Db2 11 and 12, APARs PI44721 and  introduce tracing procedures for writing trace information from native SQL procedures.  Application developers can use these procedures to debug native SQL routines, by writing SQL statements to write and retrieve the trace information.  These new procedures are especially useful for debugging SQL routines running on production systems.   APAR PI44721 introduces the following sample procedures in the DSN8 schema: DSN8.DISABLE... [More]

By Wei Li and Michael Wendel .   Db2 12 function level 503 (V12R1M503) introduces a new built-in global variable, SYSIBMADM.REPLICATION_OVERRIDE , that provides support needed to replicate system-period temporal tables or tables that contain generated expression columns.   This built-in global variable is not intended for general use. It is intended for use on the apply side of the replication process by products that enable replication of Db2 data. As such, write privileges on the variable are not granted to... [More]

Tags:  replication db2z12 administration continous-delivery

By Tom Toomire and Emily Alameida   In Db2 11 and 12, APAR PI98649 introduces three new Db2 commands, START RESTSVC, STOP RESTSVC, and DISPLAY RESTSVC for operational control of Db2 REST services and support for versioning of REST services .   With the STOP RESTSVC command, you can stop a service during maintenance so that invocation attempts will display an unavailable reply. Once the maintenance is completed, the START RESTSVC command can be used to start the service again. The DISPLAY RESTSVC command displays the status... [More]

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 changes the Db2 12 changes to support DB2ZAI (a separate offering—product ID: 5698 GCN) are 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... [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]