This post is part of the Db2 12 GA feature series , which highlights new features and capabilities introduced by the Db2 12 for z/OS, at general availability (GA) in October 2016. By Gayathiri Chandran.   There is a demand for a way to change the ownership of Db2 objects from one user to another. Since the owner of an object implicitly gets all privileges on the object, and those privileges cannot be explicitly revoked, there are times when an object’s owner must be changed. Although dropping the object would remove the implicit privileges so... [More]

Tags:  db2z12_ga db2z12

By Shu Li Kragness and Paul McWilliams .   IBM recently announced that support for all IBM Z software products and offerings is migrating to a new user friendly support site that will replace the IBM Service Request Tool during the summer of 2019, including your Db2 for z/OS Client Success Team.  After the migration, all new and existing Db2 for z/OS support cases will be managed through the new site.   The new support site is powered by the cognitive Support Platform (CSP) and you can check it out now (but you won't be able to open a case... [More]

Tags:  client_success support

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.1 delivers:   - the ability to determine whether the performance of a statement has regressed, and if it has, to automatically re-train the model to improve statement performance - the ability to uncover time-specific... [More]

By Florence Dubois and Paul McWilliams .  The Db2 for z/OS development SWAT team recommends using FlashCopy as a best practice for non-disruptive consistency checks with the Db2 CHECK INDEX, CHECK DATA, CHECK LOB SHRLVL CHANGE utilities. FlashCopy also offers interesting options to optimize the backup and recovery of your Db2 data with System-Level Backups (SLB) and FlashCopy Image Copies (FCIC). However, one of the common obstacles for using FlashCopy with Db2 utilities is missing RACF or equivalent authorizations. In this post, we summarize... [More]

Tags:  best_practice utilities

We're proud to announce that Db2 12 for z/OS function level 505 becomes available for activation when you apply APAR PH09191 . Function level 505 introduces the following new capabilities in Db2 12 for z/OS.   Improved Hybrid Transactional Analytical Processing performance Performance improvements address the perceived latency between Db2 for z/OS and IBM Analytics Accelerator for z/OS in Hybrid Transactional Analytical Processing (HTAP) environments. The functional code was delivered in APAR PI98630.   Rebind phase-in for packages being... [More]

Tags:  continuous-delivery db2z12

This post is part of the Db2 12 GA feature series , which highlights new features and capabilities introduced by the Db2 12 for z/OS, at general availability (GA) in October 2016. By Regina Liu and Paul McWilliams . Db2 12 for z/OS introduced a new capability to alter certain attributes of table columns as pending data definition changes . With pending data definition changes, you can reduce data unavailability and better manage the scheduling of alterations and REORG utility operations. In previous releases, and by default in Db2 12, all... [More]

Tags:  db2z12_ga db2z12 adminstrator dba

This post is part of the Db2 12 greatest hits series , which highlights the most popular new features and capabilities introduced by the original Db2 12 for z/OS release, at general availability in October 2016. By Haakon Roberts and Paul McWilliams . In Db2 12, we introduced a new capability to use relative page numbers (RPN) for partition-by-range (PBR) universal table spaces (UTS) . In this post, we'll call this new type of table space "PBR RPN" for short, and we'll explain what it is and the issues that it addresses. If you... [More]

Tags:  dba jc_hits administration db2z12 db2z12_ga

By Ann Hernandez . ITERGO is an affiliate of its holding company ERGO AG, which is a major insurance group that operates in Germany, throughout Europe, and worldwide. Headquartered in Düsseldorf Germany, ITERGO is the company’s IT service provider and employs about 1700 people at four locations in Germany.   This blog post is based on a recent conversation with two key ITERGO employees, who shared their perspective on the company’s migration to Db2 12 for z/OS. Walter Janissen , a DBA for the application development area, has worked with Db2... [More]

Tags:  db2z12 sysprog migration

By Paul McWilliams . If you use the PDF download scripts to download the PDF manuals Db2 for z/OS, and you last downloaded the scripts before May 31, 2019, you'll need to get the latest versions. We recently made a small adjustment to the URL paths for the PDF files in IBM Knowledge Center , for internal tooling reasons. Because we put redirects in place, this change is mostly transparent to you, but the scripts do not work with the redirects. However, we also updated the scripts to handle the changes, and y ou can download the updated... [More]

Tags:  pdf documentation

This post is part of the Db2 12 GA feature series , which highlights new features and capabilities introduced by the Db2 12 for z/OS, at general availability (GA) in October 2016. By Paul McWilliams and Eric Katayama . Db2 12 for z/OS introduced the capability for Db2 data sharing members to participate in the recovery of failed peer members. With this peer recovery capability , a Db2 data sharing group can automatically recover retained locks for failed members, without the need for other automation or manual procedures. When a data sharing... [More]

Tags:  db2z12 adminstration dba db2z12_ga

By Jim Pickel and Paul McWilliams . In Db2 12, APAR PH08482 simplifies the process of activating new function levels without impacting existing JDBC, CLI, and .net applications, and it possibly reduces the coordination effort required between Db2 administrators and application programmers, for activating new application compatibility (APPLCOMPAT) levels. With this APAR applied, Db2 12 assumes that the IBM Data Server Drivers at the following levels or higher fully support all new SQL capabilities: IBM Data Server Driver for JDBC and SQLJ... [More]

Tags:  application continuous-delivery application_developer dba db2z12 administrator

By Tammie Dang , Euna Park , and Jennie Chang . Db2 12 for z/OS introduced the capability to specify resource limits for static SQL statements , and APAR PH07658 recently introduced the following resource limit facility (RLF) usability enhancements in Db2 12: A new Db2 capability that automatically refreshes the in-memory resource limit tables The ability to specify resource limit tables that are already active when issuing the START RLIMIT command A new SCOPE(GROUP) keyword in the START RLIMIT command   Resource limits for static SQL... [More]

Tags:  db2z12 rlf

By Sueli Almeida and Paul McWilliams . We recently published a sample Db2 software services template . As a service provider, you can use it to create services (DBaaS) to rapidly provision from scratch one or multiple standalone Db2 subsystems, in IBM Cloud Provisioning and Management for z/OS . The sample Db2 software services template is intended for service providers, who configure and make the Db2 system provisioning services available to the consumers of the service in their shops.   Services created from the sample template provision... [More]

Tags:  provisioning cloud dbaas

By Kalpana Shyam . Insert algorithm 2 (IAG2) was introduced in Db2 12 to increase throughput of INSERT statements and to reduce logging in specific conditions.  The purpose of this blog post is to help you understand IAG2 in the simplest terms possible and to provide you with information that will help you get the greatest benefits from using it. This blog post provides overview information to help you get started and more detailed information to help ensure your ongoing success with IAG2 in a production environment. This information will be... [More]

Tags:  performance dba db2