All Blog Posts (313)

Announced today -- Innovations in IBM Db2 AI for z/OS! Learn More!

As the market manager of IBM Db2 for z/OS, I am really excited to share with you all some great news. Today IBM introduces new AI and machine learning capabilities with IBM Db2 AI for z/OS V1.2 - if you are at IBM THINK 2019 please can an visit us to learn more!…

Continue

Added by Surekha Parekh on February 12, 2019 at 13:30 — No Comments

How to increase the DSSIZE of partition in PBG and PBR

Hello Everyone,

Please can somebody tell me the correct procedure to do this activity like how to increase the DSSIZE of specific partitions for UTS objects without any data loss. 

I would appreciate your quick responses.

Thanks,

Vinaykumar Kanathala

Added by VINAYKUMAR KANATHALA on February 5, 2019 at 10:07 — No Comments

Starting at 11 AM EST, 4PM GMT LIVE webcast 29th Jan with John Campbell

Starting at 11 AM EST, 4PM GMT LIVE webcast 29th Jan John Campbell - IBM Distinguished Engineer.

Title: JC's Greatest Hits, War Stories, and Best Practices Part 1

Date: 29th January 2019…

Continue

Added by Surekha Parekh on January 29, 2019 at 13:05 — 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

Db2 for z/OS JSON SQL APIs and Native REST Services

In the recent customers’ conference calls, a lot of customers are confused about Db2 for z/OS JSON capability and Native REST services. They think they are the same thing. In fact, they are completely different. In the following article, I will describe the difference and share the questions I have been asked many times. A node.js application is included as example to invoke a Db2 native REST service.…

Continue

Added by Jane Man on December 20, 2018 at 21:44 — No Comments

Read how Banco do Brasil migrated to IBM Db2 Utilities

Banco do Brasil, one of the largest worldwide Db2 sites, migrated to using IBM Db2 Utilities. This article was first presented at the IBM THINK 2018 Conference and is now published in the IBM Systems Magazine, online now.  http://ibmsystemsmag.com/mainframe/administrator/db2/banco-do-brasil/

 …

Continue

Added by Calene Janacek on November 13, 2018 at 19:37 — No Comments

IBM Announces Db2 DevOps Experience for z/OS - General Availability - November 23, 2018

IBM Announces Db2 DevOps Experience for z/OS

General Availability: November 23, 2018

IBM Db2 DevOps Experience for z/OS helps you deliver Db2 applications to market faster with lower costs and less risk:

  • Lines of Business…
Continue

Added by Calene Janacek on October 8, 2018 at 8:00 — 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

XIII PDUG Wrocław Conference. Summary

On  20-21 September took place the XIII Conference of the Polish DB2 User Group. The meeting place was the Scandic hotel in Wroclaw. We would like to thank all the guests for participation in the conference - speakers for technical presentations and our sponsor UBS for their support! Over 96 participants came to Wrocław! We also thank IBM for funding the voucher for the upcoming IDUG conference to be held in Malta in November. The voucher covers the costs of registration at IDUG Malta…

Continue

Added by Sekowski Pawel on September 27, 2018 at 11:26 — 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

IBM announces IBM Db2 AI for z/OS TODAY! General Availability - September 21, 2018

IBM announces IBM Db2 AI for z/OS

General Availability - September 21, 2018

I'm very excited to let you know that today IBM Announced Db2 AI for z/OS. IBM Db2 AI for z/OS (Db2ZAI) empowers the Db2 for z/OS optimizer to…

Continue

Added by Surekha Parekh on September 11, 2018 at 15:52 — No Comments

Db2 for z/OS monitoring: Evaluating deadlock and timeout events on the Enhanced 3270 UI

New features are being continuously added to the OMEGAMON for Db2 Performance Expert Enhanced 3270 User Interface.  A continued investment in the 3270 UI demonstrates a commitment to synergy and integration with the entire OMEGAMON family of products. This blog describes the latest feature introduced through the version 5.4.0 service stream.

Introduction

Deadlocks and timeouts are a fairly routine occurrence in Db2 as applications…

Continue

Added by Paul Kenney on August 10, 2018 at 22:28 — 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

Register for IDUG EMEA Db2 Tech Conference 2018 - Join IDUG's 30th Anniversary Celebrations

Register Now for IDUG Malta 2018 Early Bird Discount Available

and join IDUG's 30th Anniversary celebrations !

http://bit.ly/IDUGMalta2018

#Db2 #Analytics #Cloud #ML #DataScience #Db2z #IDUGDb2 #IDUG30 …

Continue

Added by Erwin Hattingh on May 30, 2018 at 16:00 — 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

IDUG EMEA Db2 Tech Conference , Bring A Friend !

Register and BRING A FRIEND , and get 60% discount for …
Continue

Added by Erwin Hattingh on April 27, 2018 at 13:09 — No Comments

Monthly Archives

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

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

User Groups

Blog Posts

Announced today -- Innovations in IBM Db2 AI for z/OS! Learn More!

Posted by Surekha Parekh on February 12, 2019 at 13:30 0 Comments

As the market manager of IBM Db2 for z/OS, I am really excited to share with you all some great news.…

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