DB2 11 for z/OS

This group is for everyone that is interested in DB2 10 and DB2 11 ESP. If you have any questions then do not hesitate to ask.

Members: 337
Latest Activity: Aug 1, 2018

Glimpse of DB2 11 by Jeff Josten, Chief Architect, DB2 for z/OS, and IBM Distinguished Engineer, IBM Software Group

Getting Excited about DB2 11? Get a Sneak Preview from

Jeff Josten - IBM DB2 for z/OS Chief Architect

Highlights - Register NOW


Speaker: Jeff Josten, Chief Architect, DB2 for z/OS, and IBM Distinguished Engineer, IBM Software Group
Replay: Available for your convenience, register now.
Developed for: IT and enterprise architects; IT managers; data analysts; database administrators and managers
Technical Level: Intermediate


Many of you will remember the first release of IBM® DB2®, launched in 1983, which marked the birth of the relational database. In 1983, there were many skeptics about the relational database. Thirty years later, it is still growing stronger and more valuable to businesses, and DB2 is still the market leader.

DB2 on z/OS®, or System z®, continues to deliver and meet the expectations of Fortune 100 CIOs and CxOs by improving operational efficiencies, reducing costs, and enabling businesses to adapt quickly to support business growth — all without sacrificing the resiliency required for today’s demanding business requirements.

Join us for this complimentary webcast and hear from Jeff Josten, IBM DB2 Chief Architect, as he shares the latest DB2 10 customer experiences with its new features and functions, including the IBM DB2 Analytics Accelerator and updates on DB2 synergy with zEnterprise® EC12. You’ll also get a glimpse into the future and IBM plans for the next release, DB2 11. It continues the DB2 history of addressing current challenges that organizations are facing, such as keeping pace with higher user expectations and, at the same time, adjusting to budget cuts. Jeff will also review the demand for more business analytics, and why it is now more important than ever to leverage existing investments for that competitive edge.

If your data resides on DB2 for z/OS — it’s a great time to exploit and maximize your investment.

Join us after the webcast for a live question-and-answer session. The webcast will also be available for replay after the event.

Discussion Forum

Unexpected results from results of UDF executed twice with UNION ALL

Started by Tom Wies Jan 26, 2015. 0 Replies

I have a user executing this statement:SELECT T.TRIGRAM_STR , 'T'  FROM TABLE(CSG.TRIGRAM('dogs')) AS TUNION ALL SELECT S.TRIGRAM_STR ,'S'  FROM TABLE(CSG.TRIGRAM('cats')) AS S; calling this…Continue


Complimentary DB2 Administration Certification Seminars available at IDUG AU.

Started by Paul Murray Jul 1, 2014. 0 Replies

IDUG Australasia is offering complimentary DB2 Administration Certification Seminars to registered attendees on the day prior to the IDUG Australasia 2014 Tech Conference in Sydney Australia being on…Continue

Need your advise on DB2 Connect 10.1

Started by Sreeharsha Naik Apr 11, 2013. 0 Replies

I am looking for some advice based on experience people may have with DB2 Connect PE V10.1 connecting to a DB2 z/OS V9.1 subsystem.  This is the first DB2 Connect V10 server I have worked with. When…Continue

DB2 for z/OS - What's On Blog

Loading… Loading feed

Comment Wall

Add a Comment

You need to be a member of DB2 11 for z/OS to add comments!

Comment by Surekha Parekh on December 2, 2010 at 14:36
Checkout our new DB2 10 Launch website

Download complimentary whitepapers

A Matter of Time - Temporal Whitepaper
Comment by Surekha Parekh on November 16, 2010 at 15:24
"Over the past several months, BMW has tested the new version of DB2 10 for z/OS, focusing on specific features and comparing these directly to the same features in DB2 9 for z/OS. One of the IBM design goals expected a general improvement in massive parallel SQL-insert performance, where we achieved close to 40% CPU improvement and significant elapse time reduction in direct comparison to DB2 9 for z/OS. For all of our critical tested selects statements, the version 10 optimizer chose the optimal access path, sometimes even improving previous access path choices in version 9. Overall, we are very pleased with the added functionality and architectural enhancements, and are looking forward to this exciting release."

- Philipp Nowak -BMW Group DB2 Product Manager
Comment by Surekha Parekh on November 16, 2010 at 15:24
Comment by Surekha Parekh on November 16, 2010 at 15:23
Comment by Surekha Parekh on October 31, 2010 at 20:12
IBM Announces IBM DB2 10 for z/OS - 19th Oct
Introducing IBM® DB2® 10 for z/OS
In today's business and economic environment, the challenge for IT is clear: improve operational efficiencies, reduce costs, and adapt quickly to support business growth -- all without sacrificing the resiliency required for today's demanding business requirements. DB2 for z/OS continues to be the undisputed leader in total system availability, scalability, security, and reliability at the lowest cost per transaction. DB2 10 for z/OS continues to build on these formidable capabilities of DB2 9 for z/OS, and delivers innovations in these key areas:

Improved operational efficiency for "out-of-the-box" DB2 CPU savings
DB2 10 delivers great value by reducing CPU usage. IBM's internal testing and early beta customer results revealed that, depending on the specific workload, customers could achieve out-of-the-box DB2 CPU savings of up to 5% - 10% for traditional workloads and up to 20% for specific workloads; when compared to running the same workloads on DB2 9. DB2 reduces its CPU usage by optimizing processor times and memory access, leveraging the latest processor improvements, larger amounts of memory, and z/OS enhancements. Improved scalability and virtual storage constraint relief can add to the savings. Continued productivity improvements for database and systems administrators can drive even more savings.

Unsurpassed resiliency for business-critical information
Business resiliency is a key component of the value proposition of DB2 for z/OS and the System z platform. Uniquely integrated technology allows DB2 for z/OS and System z to support your efforts of keeping your business running even when things go wrong or you need to make changes. DB2 10 innovations raise the bar on data resiliency through scalability improvements and fewer outages. This release delivers the ability to support up to five to ten times more concurrent active users in a single DB2 subsystem than in DB2 9, allowing customers to scale-up or scale-out simply, and with less system management. Schema evolution or data definition on demand as well as query performance manageability enhancements support improved availability and performance manageability.

Rapid application and warehouse deployment for business growth
Staying competitive in today's global economy is tougher than ever, requiring agility, adaptability, and responsiveness. SQL and pureXML enhancements in DB2 10 help extend usability, improve performance, and ease application portability to DB2 for z/OS, supporting your efforts to create an efficient, productive application structure with a sustainable competitive advantage. DB2 10 adds unique temporal capabilities to support business and system time within the database itself, making application development and maintenance significantly simpler and more cost effective.
Read More
Comment by Surekha Parekh on March 27, 2010 at 0:25
Don't forget to register for our first DB2 10 for z/OS webcast
April 13th - Register Now
Comment by Surekha Parekh on February 10, 2010 at 11:07
Comment by Surekha Parekh on February 9, 2010 at 16:30
Follow me via my Blog
Comment by Christian Daser on February 9, 2010 at 16:00
Looking forward to V10 ;-)
Comment by Mitesh Nagar on February 9, 2010 at 15:56
That is going to be quite a jump. We doing a V8 to V9.

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



  • Add Videos
  • View All

DB2 for z/OS APARS

© 2019   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service