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

By Chris Crone and Paul McWilliams .   You can now download images to deploy text search servers for IBM Text Search for Db2 for z/OS in Docker containers , in your private cloud-based environments.  IBM Text Search for Db2 for z/OS, is part of the zero-priced Db2 Accessories Suite for z/OS Version 4 offering. It provides text search capability for text columns that are stored in Db2 tables, with excellent query performance and scalability.   Before the availability of the Docker images, clients who wanted to use IBM Text Search for Db2 for... [More]

Tags:  administrator accessories-suite dba

By Chris Crone and Sarbinder Kallar   Db2 12 Function Level 505 introduces a new Encryption Built-in Function (BIF) ENCRYPT_DATAKEY that can be used to encrypt data at the column level using the AES algorithm .    Previously, Db2 had the ENCRYPT_TDES function, but it was not widely used or enhanced to support AES because it required the application to manage the encryption key. Encryption itself is easy because algorithms are standardized, even to the point that HW implementations exist, key management, however, is hard. Encryption without key... [More]

Tags:  fl505 continuous-delivery security encryption

By Kate Wheat and Koshy John. When the RUNSTATS utility gathers statistics, the utility can either do row sampling after all the rows for the table are read or page sampling wherein all the rows from select pages in the table space are read. Page sampling is typically faster in both elapsed time and CPU time. In Db2 12 function level 500, APAR PH07220 introduces a new subsystem parameter (or zparm) called STATPGSAMP that you can use to make page sampling the default behavior for RUNSTATS.   The new STATPGSAMP zparm applies to universal table... [More]

Tags:  administration video performance utilities fl505 runstats dba

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. Update: The migration completed on Sunday, July 28, 2019 at 9:00 PM US Eastern Time.   The new support site is powered by the Cognitive Support... [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 fl505

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