Paul McWilliams's Blog (16)

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

Discover what's new in DB2 for z/OS

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

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

User Groups

Blog Posts

Enhancements to Insert Algorithm 2

Posted by Eric Radzinski on March 13, 2019 at 19:51 0 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…

Continue

Videos

  • Add Videos
  • View All

DB2 for z/OS APARS

© 2019   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service