IBM Db2 - The Ultimate Database for Cloud, Analytics & Mobile
In Db2 12, you can transfer the ownership of database and system objects online if you are the owner of the object or have SECADM authority. You can use TRANSFER OWNERSHIP statements to transfer ownership of an objects to another authorization ID or a role, without any application changes.
For the full story on this new SQL capability, see the new Db2 12 GA feature series post, Transferring ownership of Db2…Continue
Added by Paul McWilliams on July 12, 2019 at 22:38 — 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
Partition-by-range (PBR) table spaces with relative page numbers (RPN) in Db2 12 for z/OS improve the usability, manageability, scalability, and availability for the largest tables in Db2 environments.
Read the full story in the Db2 for z/OS News from the Lab blog:
Added by Paul McWilliams on June 12, 2019 at 19:30 — No Comments
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…Continue
Added by Paul McWilliams on May 9, 2019 at 23:32 — 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
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