DB2 11 for z/OS An IDUG User Technical Perspective

    By: Julian Stuhler on Oct 07, 2013


    In March 2013 the IDUG DB2 11 Editorial Committee was formed, comprised of volunteers from IDUG’s worldwide community of DB2 users and consultants. Working alongside IBM's formal Early Support Program (ESP), the Editorial Committee gained valuable insight into exactly what makes the new release tick. This White Paper contains their findings, including practical experiences and independent evaluations of the new features.

    DB2 11 contains a large number of enhancements, but some will be of more interest than others depending on your job role and background. We have organised this paper according to the features likely to be most applicable to each of the three major technical roles in a DB2 for z/OS environment: Systems Programmers, Database Administrators and Application Developers.

    Download the paper from The IDUG Content File Library here: http://www.idug.org/p/do/sd/sid=5511&type=0

    NEW! You can now also download the paper in the open EPUB format suitable for e-readers here: http://www.idug.org/p/do/sd/sid=5879&type=0

    Please add comments, suggestions, tips about DB2 11, or any other feedback you may have in the comments secton below.

    In early March, the IDUG Content Committee randomly selected one contributor to the comments below for a free IDUG Technical Conference admission at either IDUG NA, IDUG Australasia or IDUG EMEA in 2014. Congratulations to Henrick Krackowski, winner of the IDUG white paper drawing. Thank you to all who participated.


    Released: October 7, 2013, 9:28 am | Updated: March 14, 2014, 1:23 am
    Keywords: DB2 for z/OS | Database Administrator | Database Performance | DB2 11 | DB2 11 for z/OS | developer | New Release

    Martin Hubel Thanks for a great job.
    By: Martin Hubel | Posted: October 15, 2013, 7:41 am

    IDUG has a long tradition of papers like this, and this is a great job. Well done!

    Nadir Doctor Suggestion comments
    By: Nadir Doctor | Posted: January 11, 2014, 1:26 am

    Thanks a lot to you all for your contributions - this paper is extremely helpful and informative. 

    I believe it will be helpful to have a "Continuos Data Ingest" feature natively for DB2 on z/OS as well like DB2 on LUW -

    o It is often not practical to create a clone for large table as an extra similar amount of space is needed for such operations

    o Bypass using DB2 Connect to load voluminous data from other platforms

    For DB2 on z/OS data warehousing environments, it will assist in having Multi-Dimensional Cluster indexes for faster data retrieval - similar functionality available in DB2 LUW.

    Nadir Doctor Suggestion comments - continued
    By: Nadir Doctor | Posted: January 11, 2014, 2:14 am

    Or, if more convenient, extend DB2 LUW Ingest utility support to also include DB2 for z/OS tables.

    Thanks again.

    David Alban Kudos to the writers
    By: David Alban | Posted: February 5, 2014, 1:39 pm

    This will be very helpful for when my company goes to v11, which will hopefully be soon. Thanks!

    Paul Baguley DB2 11 Whitepaper
    By: Paul Baguley | Posted: February 6, 2014, 3:36 am

    Thanks for taking the time to put these excellent White Papers together... They are extremely helpful in both moving to the new release, and once there being able to make full use of the new features. Another excellent document !

    Kadir Guray Meric DB2 11 for z/OS: An IDUG Technical User Perspective
    By: Kadir Guray Meric | Posted: February 12, 2014, 5:20 am

    DB2 11 for z/OS: An IDUG Technical User Perspective book is a very good example to get an idea about db2 v11

    Georg Peter First class white paper
    By: Georg Peter | Posted: February 12, 2014, 5:21 am

    Escpecially the DBA topics are very interesting. And yes I am a DBA ;-)

    Jose Antonio Morcillo Valenciano DB2 11 finally paper
    By: Jose Antonio Morcillo Valenciano | Posted: February 12, 2014, 5:31 am


    Thanks for the recap is amazing!


    William Miller A bigger & better DB2
    By: William Miller | Posted: February 12, 2014, 7:54 am

    I am constantly astounded by the growth in DB2.  As a long-time user & DBA, I have, in the past, thought that IBM had come to the end of new features.  As this white-paper shows, the developement lab hasn't slowed down. 

    Kudos to the authors for summarizing some of the features at a level the experienced DBA are comfortable with.

    Henrik Krakowski DB2 11 Whitepaper
    By: Henrik Krakowski | Posted: February 12, 2014, 10:57 pm

    I think Julian made a great job. I found many interesting facts for future usage

    Henrik Krakowski Volvo IT 

    Raf Mathijs DB2 11
    By: Raf Mathijs | Posted: February 28, 2014, 1:53 am

    interesested in everything DB2...

    Armando Arranja Great job!
    By: Armando Arranja | Posted: February 28, 2014, 4:20 am

    Some suggestions to improve the paper:

    - Include a sample of the input data in the OLAP examples

    - Move the security features from the DBA topics into a new section Security topics

    - Move the XML descriptions from the DBA topics to the Developer Topics

    Congratulations to the Editorial Committee for the good job! The description of the new features and their limits save lots of reading and research times.


    Copyright © 2015 IDUG. All Rights Reserved

    All material, files, logos and trademarks within this site are properties of their respective organizations.

    Terms of Service - Privacy Policy - Contact