IBM Db2 - The Ultimate Database for Cloud, Analytics & Mobile
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…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…Continue
Added by Joe Geller on February 27, 2018 at 19:00 — No Comments
Added by Sandy Flippen on March 19, 2018 at 17:32 — No Comments
HURRY today is the last chance for you to register our DOUBLE Webcast Series - Db2 12 Migration Planning and EARLY CUSTOMER EXPERIENCES. There will be a with LIVE Q &A session with John Campbell - IBM Db2 Guru. This is fresh content for 2018 to help you accelerate your Db2 12 Migration.
DB2 12 for z/OS Technical Overview PART 1 & 2 with live…Continue
Some time ago, John Campbell, Michael Dewert and I published a Db2 white paper on the support for the extended LRSN and RBA format introduced in Db2 11. This paper is no longer available on the internet, so we have decided to reproduce it here as it contains valuable information for safely implementing the extended format in both data sharing and non-data sharing environments, and in particular for avoiding pitfalls which can lead to unplanned outages. …Continue
Added by Gareth Copplestone-Jones on January 28, 2018 at 19:30 — No Comments
With Db2 for z/OS continuous delivery model, new Db2 for z/OS features/enhancements are continuously delivered in service stream when they are ready. LISTAGG is one of first set of functions delivered in function level 501 since Db2 adopted continuous delivery model.
Added by Jane Man on November 24, 2017 at 18:34 — No Comments
Added by Judy Tobias on November 17, 2017 at 17:11 — No Comments
Do you ever wish you could just ask a Db2 expert about something? Maybe about how to do something with Db2 that you've never done before? Or maybe about problems that occur during migration from an older version of Db2 to Db2 12 or Db2 11? If having an expert available sounds appealing to you, then IBM's recent announcement about…Continue
Added by Ann Hernandez on October 30, 2017 at 7:30 — No Comments
Customers have been telling us that they lack adequate safeguards to protect data in Db2 for z/OS from viewing by unauthorized internal personnel. In Db2 11 for z/OS, we address that problem…Continue
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
Why did over 1000 Db2 users downloaded this valuable whitepaper ?
Whitepaper: DB2 12 for z/OS The In-Memory Enterprise Database for Transactions and Analytics
This paper will provide a high-level overview of the major new features of IBM DB2 12 for z/OS from an IT Executive’s perspective, with the emphasis on the underlying business value that the…Continue
Added by Surekha Parekh on October 13, 2017 at 18:00 — 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…
In Db2 11 for z/OS and Db2 12 for z/OS, we introduce an enhancement that improves your ability to obtain accurate real storage usage statistics. In the past, z/OS capacity planners have experienced difficulties in determining an accurate estimate of the main memory that their Db2 subsystems used. With this enhancement, you can have…Continue
Added by Judy Tobias on October 2, 2017 at 13:23 — No Comments
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
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