IBM Db2 - The Ultimate Database for Cloud, Analytics & Mobile
Sometimes it is useful to generate JCL executable code for //SYSIN via SQL mass operations, e.g. change specific tables from one option to another. If the result row fits into one JCL line with a length of 72, then all is fine. If the line must be split, then the question comes up: How to split?
Here is a solution for commands (like REBIND PACKAGE), SQL (like ALTER TRIGGER) or…Continue
Added by Guillaume ARNOULD on September 9, 2019 at 8:20 — No Comments
This blog is part of a blog series around Analytics on IBM Z and has been created by
Added by Khadija Souissi on September 10, 2019 at 8:43 — No Comments
Added by Leif Pedersen on September 9, 2019 at 8:15 — No Comments
The idea of the traditional data center being centered on relational database technology is quickly evolving. Many new data sources exist today that did not exist as little as 5 years ago. Devices such as active machine sensors on machinery, autos and aircraft, medical sensors, RFIDs as well as social media, and web click through activity are creating tremendous volumes of mostly unstructured data which cannot be…Continue
Added by Jim Wankowski on September 4, 2019 at 19:30 — No Comments
AUTOBIND is a very useful automation instrument inside the Db2 engine.
Suppose you change the definition of the table or index and these changes have impact on the dependent package, the static SQL package is marked as invalid,…Continue
Added by Peter Hartmann on August 20, 2019 at 19:29 — No Comments
One of the major challenges for RUNSTATS is the sampling of the data rows e.g. for calculation of the COLCARD value in SYSIBM.SYSCOLSTATS and SYSIBM.SYSCOLUMNS.
The challenge is to balance the CPU resources used by RUNSTATS to calculate column cardinalities with high accuracy…Continue
With DB2 Version 9.1 for z/OS a new system supplied stored procedure SYSPROC.ADMIN_INFO_SYSPARM was delivered. As the name suggests, this routine can be called to obtain the current settings of the Db2 subsystem parameters (DSNZPARM) and the…
Description of the new feature:
When Db2 in a data sharing environment writes a changed page to the GBP the same page in the buffer pool(s) of the other member(s) must be invalidated to avoid back level data access in this/these member(s). This invalidation is done by the cross invalidation (XI) feature which is a key functionality of data sharing and controlled by coupling facility…Continue
Added by Peter Hartmann on July 12, 2019 at 7:57 — No Comments
We're proud to announce that Db2 12 for z/OS function level 505 becomes available for activation when you apply…Continue
Added by Paul McWilliams on June 26, 2019 at 18:41 — No Comments
IDUG are pleased to once again invite all Db2 Regional User Group (RUG) leaders attending the IDUG conference in Charlotte to join us for a RUG Leaders Luncheon on Tuesday, June 4, 2019, 11:40 AM - 12:40 PM, Craft City Social Club, Charlotte Sheraton.
This is a chance to connect with fellow Db2 RUG leaders while you learn about news and updates from IDUG and IBM.
The objectives of this session…Continue
Added by Surekha Parekh on April 9, 2019 at 14:29 — No Comments
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…Continue
Added by Paul McWilliams on April 2, 2019 at 22:32 — No Comments
Db2 for z/OS APAR PH02052 provides some significant enhancements to Insert Algorithm 2, which was introduced in Db2z 12 to provide faster INSERT throughput for unclustered INSERTs on universal table space objects that use the MEMBER CLUSTER option.
Read the full story here: https://ibm.biz/Bd2wDL
Always get the latest…Continue
Added by Eric Radzinski on March 13, 2019 at 19:51 — No Comments
It can be challenging to train a new generation of Db2 for z/OS users whose model of learning no longer includes days of reading long “manuals.” But they have energy, enthusiasm and lots of new ideas that you want to foster. Why not try teaching them with short videos?
Check out this Db2 Utilities video, specifically aimed at orienting someone who is new to Db2 for z/OS and knows little or nothing about Db2 Utilities.…Continue
Added by Paul McWilliams on March 1, 2019 at 23:13 — No Comments
As the market manager of IBM Db2 for z/OS, I am really excited to share with you all some great news. Today IBM introduces new AI and machine learning capabilities with IBM Db2 AI for z/OS V1.2 - if you are at IBM THINK 2019 please can an visit us to learn more!…Continue
Added by Surekha Parekh on February 12, 2019 at 13:30 — No Comments
Added by Katie Higgs on April 25, 2019 at 15:23 — No Comments
Starting at 11 AM EST, 4PM GMT LIVE webcast 29th Jan John Campbell - IBM Distinguished Engineer.
Date: 29th January 2019…Continue
Added by Surekha Parekh on January 29, 2019 at 13:05 — No Comments
Added by Paul McWilliams on January 8, 2019 at 19:20 — No Comments