IBM Db2 - The Ultimate Database for Cloud, Analytics & Mobile
Added by Paul McWilliams on March 6, 2019 at 18:26 — 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
Added by Paul McWilliams on January 8, 2019 at 19:20 — No Comments
Added by Paul McWilliams on October 3, 2018 at 23:56 — 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
Back in Version 9, Db2 for z/OS introduced minimal support for MERGE statementst, only providing an upsert capability with limited functionality. Db2 12 for z/OS enhances MERGE statements to be consistent with the SQL 2016 Core standard, as…Continue
Added by Paul McWilliams on August 1, 2018 at 22:51 — No Comments
The first Db2 for z/OS Master Class to be hosted by IBM Europe was recently held at IBM Hursley. The next invitation-only session at IBM Silicon Valley Laboratory is already full, but future session are planned. For the full story, see Db2 for z/OS Master Classes.
Always get the latest news about Db2 for z/OS from the IBM lab!…Continue
Added by Paul McWilliams on July 18, 2018 at 16:53 — 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
Added by Paul McWilliams on May 8, 2018 at 17:53 — No Comments
We're proud to announce that Db2 for 12 for z/OS function level 502 is now available!
Function level 502 introduces support for new policy controls in Db2 12 for…Continue
Added by Paul McWilliams on April 30, 2018 at 21:30 — No Comments
The Db2 for z/OS documentation team recently changed how we deliver PDF manuals for Db2. These changes are mostly transparent to you. However, I've recently fielded several questions related to the recent process changes and more general concerns about the future of PDF manuals for Db2, and I want to respond to those questions.
But first: advantages of IBM Knowledge Center
As I hope you're aware, …
Added by Paul McWilliams on October 18, 2017 at 22:35 — No Comments
By Patrick Bossman and Paul McWilliams
Automatic binds of plans and packages for applications that run on Db2 for z/OS introduce avoidable risk to online and offline migrations. During and after migration, automatic binds can cause costly problems, including performance regression and even application outages.
However, you can take action before migration to…
By Patrick Malone and Paul McWilliams
Db2 for z/OS DBAs who use the LOAD utility in Db2 11 and Db2 12 can reduce the cost and effort of preparing input data sets for the LOAD utility, examining LOAD utility job output, and dealing with discard data sets, by using several new IGNORE options.
DBAs are often aware of records in input data sets that trigger…
Added by Paul McWilliams on September 18, 2017 at 16:00 — No Comments
In Db2 12 for z/OS function level 501, you can write efficient queries to select groups of related values and return each group as a list in a single string value, with optional separators, without writing complex recursive SQL statements. Consider the sample EMP table that is supplied with Db2. You can write a query that calls the…Continue
Added by Paul McWilliams on September 11, 2017 at 9:00 — No Comments
Complete the Db2 for z/OS Pain Points Survey to identify and rank the pain points you currently experience while using Db2 for z/OS. We gladly accept multiple responses from your company. Your feedback is very important to us. Thank you for taking 5-10 minutes to complete the survey.
Added by Paul McWilliams on July 21, 2017 at 20:35 — No Comments
Discover how new DB2 for z/OS features can help your enterprise get the most out of its database applications by visiting the DB2 for z/OS What's New web page at http://ibm.biz/db2zos-whatsnew.
This web page highlights key new features and the business value they bring. Today, this web page focuses on several new capabilities that can help you modernize your application development…Continue
Added by Paul McWilliams on April 20, 2017 at 17:00 — No Comments