Skip to Main Content
IBM Data and AI Ideas Portal for Customers


This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:


Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,


Post your ideas

Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

IBM Employees should enter Ideas at https://ideas.ibm.com


Status Not under consideration
Workspace Db2 for z/OS
Created by Guest
Created on Jun 10, 2022

Issue command DISPLAY DB CLAIMERS on a LOAD SHRLEVEL NONE when DRAIN fails in UTILINIT phas

We faced situations in which LOAD SHRLEVEL NONE jobs abends with S04E and Reason Code 00C200EC during UTILINIT phase.

When this abends occurs, LOAD was unable to DRAIN all the claimers, once it is SHRLEVEL NONE, before beggining LOAD data into table.

In these cases no command -DIS DB CLAIMERS is automatically issued in order to show what are the claimers that are blocking the LOAD drain. In these cases we depend on a operator issue this command, but sometimes when command is issued claimers are not in place anymore and we don't know what was blocking LOAD DRAIN. No DB2 message is issued to MSTR or SYSLOG either.

So we think it would be very useful if this -DIS DB CLAIMERS command was automatically issued in this scenario with LOAD SHRLEVEL NONE as it already happens for LOAD SHRLEVEL REFERENVE and REORG SHRLEVEL CHANGE/REFERENCE in SWITCH phase whem DRAIN fails.

Needed By Not sure -- Just thought it was cool
  • Admin
    Janet Figone
    Reply
    |
    Jan 11, 2023

    Dear Paulo, Thank you for submitting this Aha! Idea. Our Db2 for z/OS development team indicated this request is consistent with our general desire to enhance utilities to provide additional information on drain failures whenever such failures occur. Unfortunately we do not believe that we will be able to prioritise this work in the near term and therefore we are marking this idea as not under consideration. However it will be reviewed and reassessed in future.

    Please do continue to submit enhancement requests for our consideration for implementation in the Db2 for z/OS product.

    Sincerely,

    The Db2 for z/OS Team