IBM Db2 - The Ultimate Database for Cloud, Analytics & Mobile
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
For more about IBM Db2 AI for z/OS and Db2 12 function level 503, check out the blog posts:
Added by Paul McWilliams on September 21, 2018 at 17:26 — No Comments
IBM announces IBM Db2 AI for z/OS
General Availability - September 21, 2018
I'm very excited to let you know that today IBM Announced Db2 AI for z/OS. IBM Db2 AI for z/OS (Db2ZAI) empowers the Db2 for z/OS optimizer to select improved access paths for SQL and improves application…Continue
Added by Surekha Parekh on September 11, 2018 at 15:52 — No Comments
Db2 12 for z/OS introduces new SQL syntax that makes the difficult task of coding efficient SQL pagination—returning a portion of a result set based on data position—much easier for application developers. Read more in New SQL pagination syntax - a Db2 12 greatest hit with John…Continue
Added by Paul McWilliams on May 22, 2018 at 21:25 — No Comments
This IBM® Redpaper™ publication provides key information about continuous delivery in IBM Db2® 12 for z/OS®. It discusses how continuous delivery works and the changes that have been made in Db2 12 to support continuous delivery,…
I imagine my story is not entirely uncommon, but it is certainly unique to me. I was a SQL Server DBA for 7 years at Southern Farm Bureau Life Insurance, when a sudden personnel change led me to becoming our company’s new Db2 for z/OS DBA, (in addition to my role as the SQL Server DBA) literally overnight. Because I had database experience, management thought this made sense and would not be out of my realm of knowledge or comfort. Anyone working with Db2, z/OS, knows there is so much…Continue
Added by Brandon Hodges on April 2, 2018 at 13:46 — No Comments
IBM and IDUG will again be raffling off complimentary IDUG Conference Passes to the 2018 IDUG Tech Conference in Philadelphia, PA during the week of April 29 - May 3.
If your user group is a Virtual Group on the World of DB2, then your User…Continue
Added by Judy H. Nall on March 23, 2018 at 13:00 — No Comments
Location: IBM Corporation 590 Madison Ave (between 56th & 57th)
Room 1219, 12th Floor
A free day of Db2 education with speakers:
See the attached flyer for the session abstracts.
Added by Joe Geller on February 27, 2018 at 19:00 — No Comments