By Thomas Eng and Emily Alameida   With APAR PH14688, BIND SERVICE now supports the COPY option to copy existing REST services to either local or remote Db2 servers running on Db2 12 with versioning enabled.     Many customer environments do not permit applications to be directly developed and deployed on production systems.  You can now code and test native REST services in a development system, and use the new BIND SERVICE COPY option to promote those services to production environment.  The existing tools you are already familiar with can be... [More]

By Regina Liu , Long Tu , and Jennie Chang .   With Db2 12 function level 506 at application compatibility level V12R1M506 or higher, Db2 now automatically drops explicitly created universal and LOB table spaces when the tables they contain are dropped. More specifically, the following enhancements are introduced: If you drop a base table that resides in an explicitly created universal table space, Db2 implicitly drops the table space along with the table , instead of returning an error in SQLCODE -669. If you drop a system-period temporal... [More]

Tags:  fl506 db2z12 function_level

Db2® AI for z/OS® (“Db2ZAI”) empowers the optimizer in your Db2 for z/OS engine to determine the best-performing query access paths, based on your workload characteristics. In addition, Db2ZAI detects Db2 system performance exceptions and provides recommended actions for tuning which are based on your environment.    Version 1.2.0.2 delivers the following new capabilities :   with the IBM Db2 AI for z/OS SQL optimization function you can manually lock in or unlock the access paths for static or dynamic SQL statements.   a RESTful API to... [More]

By Paul McWilliams. Db2 12 function level 506 is now available. It introduces new alternative spellings for existing SQL built-in functions to improve compatibility with competitive database platforms, the SQL standard, and the Db2 product family. It also introduces a new capability to implicitly drop explicitly created table spaces when dropping tables, which we'll cover in more detail in a future post.  You can activate function level 506 after you apply the PTF for APAR PH16829 .  The new alternative function names are supported for... [More]

Tags:  fl506 function_level db2z12

By Tammie Dang and Paul McWilliams .   Db2 12 function level 505 (activation enabled by APAR PH09191 ) introduces a new REBIND phase-in capability for application packages, which enables DBAs to issue REBIND PACKAGE commands successfully when target packages are being concurrently executed. This new capability enables DBAs to deploy the new features in new Db2 12 function levels, which often require packages to be rebound at a higher APPLCOMPAT level, without having to either wait for a suitable window when applications are not running, or take... [More]

Tags:  fl505 db2z12 function_level

WHEN:  Tuesday, October 29th TIME:     11 AM EST Register: http://bit.ly/RBS_Oct29 Royal Bank of Scotland (RBS) has a large, mission-critical Db2 for z/OS environment with extremely high availability and performance requirements.  Since 2014, the RBS staff of database administrators, system programmers and over 2,000 developers have converted to the IBM Db2 Utilities and Tools to meet ever-increasing expectations.  Mark Turner, chief architect and strategist for mainframe databases at the bank, will share the RBS story and experiences.  He will... [More]

Tags:  tools client utilities webcast

Perhaps you've seen the banner at the top of the page announcing the sunset of the developerWorks Connections platform on December 31, 2019. That doesn't mean we're discontinuing this blog. However, we'll be moving it to a new platform soon, and we'll let you know the new location as soon as we have that set up. Stay tuned! Update: We're moving to the new Db2 for z/OS Community!   Always get the latest news about Db2 for z/OS from the IBM lab! https://ibm.biz/db2znews-subscribe Follow us on Twitter: @DB2zLabNews    

IBM has simplified installation and migration for Db2 12 by integrating 1,070 Db2 12 PTFs (more than 33 months of maintenance) in a new SMPE SUP (service update) product base tape for new SMPE installation of Db2 12 for z/OS.  The new Db2 12 base product tape was cut on July 30, 2019 (PDO1930), and integrates maintenance that enables you to activate function level s up to function level 505.    The new SMPE product base tape is available for all orders placed in Shopz beginning on Friday, October 4, 2019.   Db2 development also evaluated each... [More]

Tags:  db2z12 installation migration

By Mo Townsend and Paul McWilliams .   Are you ready? The End of Support (EOS) for Db2 11 for z/OS is coming fast, just 12 months away on September 30, 2020! If you haven't started your Db2 12 migration, here are some next steps resources to help you get started: Watch Db2 12 for z/OS Migration webcast replays featuring John Campbell , to build a solid foundation for your migration plan and to ensure a safe and successful migration. In particular, the following replays are available: Db2 12 for z/OS Technical Overview - Part 1 Db2 12... [More]

Tags:  migration database_administrator dba db2z12 db2z11

By Adrian Burke and Paul McWilliams . In Db2 for z/OS you can use the profile monitoring capability to monitor or limit resource consumption by distributed database facility (DDF) workloads. This capability, which was first introduced in Db2 10, provides a helpful solution for clients who have been burdened in recent years by trying to control the consumption of resources for distributed workloads, as the number of inbound connections and consumption of database access threads by ill-behaved or unpredictable applications have impacted Db2 for... [More]

Tags:  database_administrator best_practice dba monitor

At popular request, IBM Distinguished Engineer John Campbell will host a new edition of his two-part webcast series: " Db2 12 for z/OS Migration Planning and Customer Experiences " Part 1: Tuesday, September 24 at 10:30 AM EDT In part 1, John will introduce and discuss the subjects: Evolution of Db2 table space type Facts about UTS partition by range (PBR) and partition by growth (PBG) table spaces UTS Partition by Range (PBR) with relative page numbering Conversion to UTS; Tips for using DSN1COPY with UTS PBG tablespaces with multiple... [More]

Tags:  jc_hits dba migration event

A new addition to the REST services series on the World of Db2 Youtube channel is now available. In the video, you can learn how to use versions to increase flexibility and manageability of your new or existing services. Watch more videos on the World of Db2 channel Related information How to create Db2 for z/OS Rest Services - Tutorials playlist Now available in Db2 12: Db2 for z/OS support for z/OS data set encryption   Always get the latest news about Db2 for z/OS from the IBM lab! How to subscribe Follow us on Twit ter : @DB 2zLa bNew... [More]

By Chris Crone and Randy Nakagawa .   One of the current Db2 for z/OS Ideas with the most votes ( RFEs are now Ideas ) is to provide a message when an autobind fails and a package goes inoperative. We are happy to announce that we have now satisfied that requirement. After you apply APAR PH13550 , if an autobind fails resulting in an inoperative package, Db2 issues console message DSNT500I .   An autobind occurs when a package that is invalid is executed. There are many ways that packages become invalid but the most common are related to ALTER... [More]

Tags:  application dba application_developer database_administrator

This coming Fall, IBM clients have two opportunities to visit the home of Db2 for z/OS—and meet the IBM experts who design, build, test, and support Db2—at IBM Silicon Valley Lab in San Jose, California. However, s pace is limited for both events, so don't delay!   Db2 for z/OS Master Class - September 23 - 27 The second and last 2019 session of the popular Db2 for z/OS Master Class is being held at IBM SVL from 23 - 27 September, 2019. This invitation-only class is taught by experts from the world-wide Db2 SWAT team and aimed at... [More]

Tags:  event