IBM Gold Consultants Db2 12 for z/OS Function Level Adoption Survey

Db2 12 for z/OS Continuous Delivery and Function Levels

The most significant change in the way new features and functions are delivered in Db2 12 for z/OS – and in future Db2 releases – is Continuous Delivery, where function levels can be activated to make new features available. Businesses have dealt with this in a variety of ways, from remaining at the lowest possible function level to pushing ahead with later levels as part of their maintenance strategy.

What is your strategy for advancing function levels under Db2 12 for z/OS, and what is the strategy being adopted by your fellow professionals in other businesses in your geography and round the world? Please help the IBM Gold Consultants understand the global and regional picture of how IBM customers are progressing through the Db2 12 for z/OS function levels in their production systems by filling out the following questionnaire on SurveyMonkey, where we will ask you about your catalog and function levels:

Db2 for z/OS Function Level Adoption survey.

The survey will only take a few minutes of your valuable time, and all your data will be anonymised and aggregated, so we won’t be able to identify you. To help preserve anonymity, we are not asking for your company name.

The objective of the survey is two-fold: we want to quantify the adoption of function levels; and we want to understand what the challenges are that prevent users from advancing function levels.  We plan to share our findings with IBM and publish them on the World of Db2 so that you and IBM will be able to understand the approach being adopted by your peers. We will also be issuing a white paper based on the survey data, with the objectives of: addressing the challenges to activating function levels; and promoting function level adoption.The white paper will be made availabale for download.

Additional Guidance on Survey Questions

You can find out most of the information requested in the survey by issuing the following Db2 command:

 -DIS GROUP DETAIL

This applies to non-data sharing systems as well as data sharing systems. The output should look something like this (the display output lnes are truncated for readability):

*** BEGIN DISPLAY OF GROUP(.......) CATALOG LEVEL(V12R1M500)
                  CURRENT FUNCTION LEVEL(V12R1M100)
                  HIGHEST ACTIVATED FUNCTION LEVEL(V12R1M100)
                  HIGHEST POSSIBLE FUNCTION LEVEL(V12R1M100)
                  PROTOCOL LEVEL(2)
                  GROUP ATTACH NAME(....)
-------------------------------------------------------------
DB2                                   DB2    SYSTEM   IRLM
MEMBER   ID  SUBSYS CMDPREF  STATUS   LVL    NAME     SUBSYS
-------- --- ----   -------- -------- ------ -------- ----  
DB1A       1 DB1A    -DB1A   ACTIVE   121500 MVSA     DJ1A  
DB1B       2 DB1B    -DB1B   ACTIVE   111500 MVSB     DJ1B  
DB1C       3 DB1C    -DB1C   ACTIVE   121500 MVSC     DJ1C  

 

If you are non-data sharing, there will be only one member listed here.

Views: 272

Add a Comment

You need to be a member of The World of DB2 to add comments!

Join The World of DB2

Comment by John Lyle on April 8, 2021 at 14:59

The SYSLEVELUPDATES catalog table can be queried to determine with function levels have been activated and which catalog changes have been made. Every time a catalog change is made or a function level is activated we add a row into SYSLEVELUPDATES. It's a great way to see the history of how a subsystem/group has progressed through function levels.

Latest Activity

A blog post by Surekha Parekh was featured
14 hours ago
blon sin liked Jim Wankowski's blog post Leveraging your Db2 Skills with Big Data
yesterday
Jonathan Sloan liked Surekha Parekh's event 2021 April 27th Enterprise Data & AI Virtual Symposium
Apr 14
A blog post by Surekha Parekh was featured
Apr 14
2 events by Surekha Parekh were featured
Apr 14
Jim Reed liked Umesh J Mehta's event TRIDEX Db2 for z/OS Q22021 Meeting
Apr 13
An event by Umesh J Mehta was featured

TRIDEX Db2 for z/OS Q22021 Meeting at Virtual Event

May 20, 2021 from 9:30am to 1:15pm
Apr 13
Jim Reed liked Manuel Gomez Burriel's event IDUG Db2 North America Virtual Tech Conference
Apr 12
Jim Reed liked Surekha Parekh's event 2021 April 27th Enterprise Data & AI Virtual Symposium
Apr 12
Jonathan Sloan liked Annette Zawacki's event Client Experiences with Integrated Synchronization in IBM Db2 Analytics Accelerator for z/OS
Apr 8
Julian Stuhler liked Gareth Copplestone-Jones's blog post IBM Gold Consultants Db2 12 for z/OS Function Level Adoption Survey
Apr 8
An event by Surekha Parekh was featured
Thumbnail

Enterprise Data & AI Virtual Symposium at Virtual LIVE

April 27, 2021 from 10am to 12pm
Apr 8
Gareth Copplestone-Jones posted a blog post
Apr 8
Gail Myers liked Manuel Gomez Burriel's event IDUG Db2 North America Virtual Tech Conference
Apr 7
Daniel liked Annette Zawacki's event Client Experiences with Integrated Synchronization in IBM Db2 Analytics Accelerator for z/OS
Apr 7
Annette Zawacki added a discussion to the group Data, Analytics and AI on IBM Z
Apr 6

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

Forum

Submit Your Abstract for the IDUG EMEA Db2 Tech Conference 2021 !!

Started by Ferdinand Prahst in What's hot ? Mar 19. 0 Replies

The submission deadline has been extended to March 29, 2021!We are currently accepting abstracts for our EMEA conference…Continue

Tags: conference, tech, db2

Replaying past database activities

Started by Shaun Hide in Security and DB2. Last reply by Alexander Dashevsky Nov 17, 2020. 1 Reply

I would need to know who modified table data on a certain day.I do have my backups and database logs available.DB2audit was however not activated at this point.How would i  be able to access this information?Continue

Tags: #DataAccess

© 2021   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service