Paul McWilliams's Blog (21)

Transferring ownership of Db2 objects in Db2 12

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

Announcing Db2 12 function level 505!

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

New blog post: PBR table spaces with relative page numbers - a Db2 12 Greatest hit

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:

http://ibm.biz/BdzPr4…


Continue

Added by Paul McWilliams on June 12, 2019 at 19:30 — No Comments

New blog post: Simplified application compatibility for IBM Data Server Drivers and Db2 12 function levels

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

Create services for provisioning Db2 susystems (DBaaS) with the sample Db2 software services template

By Sueli Almeida and Paul McWilliams.

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

Announcing Db2 12 function level 504

We're proud to announce Db2 12 function level 504!



Function level 504 (activation enabled by APAR PH07672) introduces the following new capabilities in Db2 12 for…

Continue

Added by Paul McWilliams on March 6, 2019 at 18:26 — No Comments

Video: Introduction to Db2 Utilities for z/OS

Got millennials?

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

A reminder to convert pagesets for Db2 for z/OS objects to the 10-byte extended RBA and LRSN format

Db2 for z/OS APAR PH02437 introduces the new DSNB233I message in Db2 12 and Db2 11. The new message reminds you to convert pagesets to the extended 10-byte RBA or LRSN format, to avoid outages that might occur if Db2 reaches the 6-byte logging limit.…

Continue

Added by Paul McWilliams on January 8, 2019 at 19:20 — No Comments

The new SQL Reference for Cross-Platform Development is here!

Version 6 of the…

Continue

Added by Paul McWilliams on October 3, 2018 at 23:56 — No Comments

IBM Db2 AI for z/OS and Db2 12 function level 503 available now!

 



For more about IBM Db2 AI for z/OS and Db2 12 function level 503, check out the blog posts:

Continue

Added by Paul McWilliams on September 21, 2018 at 17:26 — No Comments

Enhanced SQL MERGE—a Db2 12 greatest hit with John Campbell

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

Db2 for z/OS Master Classes

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

New SQL pagination syntax - a Db2 12 greatest hit with John Campbell

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

Fast index traversal - a Db2 12 greatest hit with John Campbell

Fast index traversal is one of the the most important new performance features in Db2 12 for z/OS. It is an in-memory index performance optimization that enables Db2 to do fast index lookup, by avoiding expensive index B-tree traversal.…

Continue

Added by Paul McWilliams on May 8, 2018 at 17:53 — No Comments

Db2 12 function level 502 now available with z/OS data set encryption support and more

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

News about PDF for Db2 for z/OS documentation

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, …

Continue

Added by Paul McWilliams on October 18, 2017 at 22:35 — No Comments

Avoid automatic binds at migration to Db2 11 or Db2 12 for z/OS

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…

Continue

Added by Paul McWilliams on September 28, 2017 at 17:00 — 1 Comment

Reduce cost and effort with new LOAD utility IGNORE options in Db2 for z/OS

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…

Continue

Added by Paul McWilliams on September 18, 2017 at 16:00 — No Comments

List groups of values with the LISTAGG built-in function in Db2 for z/OS

By Jason Cu and Paul McWilliams

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

Db2 for z/OS Pain Points Survey

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.

http://ibm.biz/db2zos-pain-points-survey

Added by Paul McWilliams on July 21, 2017 at 20:35 — No Comments

Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.

User Groups

Blog Posts

Retrieval of current DSNZPARM and DSNHDECP settings

Posted by Peter Hartmann on July 16, 2019 at 8:04 2 Comments

History:

With DB2 Version 9.1 for z/OS a new system supplied stored procedure…

Continue

Videos

  • Add Videos
  • View All

IDUG Conference News

PlanetDB2.com [Latest Blogs from the Biggest Names in DB2]

© 2019   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service