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 (

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 ( - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal ( - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM. - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

IBM Data & AI Roadmaps ( - Use this site to view roadmaps for Data & AI products.

IBM Employees should enter Ideas at

Status Not under consideration
Workspace Db2
Created by Guest
Created on Aug 12, 2021

Restore Diagnostic messages

When upgrading DB2 LUW from V10.5 to V11.5, restore got hung after processing 830G [ full backup data ] without any message

DB2 Support team was contacted to troubleshoot the issue, finally, it appeared to be an file lock issue, DB2 appeared to be lost somewhere and not knowing what to do

It would be good from an DB2 coding perspective to output proper messages on the status of restore and any valuable information in situation on hand, where we couldn't identify what's going on within DB2

DB2 LIST UTILITIES command was unresponsive

DB2SUPPORT command was unresponsive

DB2STOP command was unresponsive

DB server reboot and restore after that worked

IMO, DB2 software should not function like Microsoft products which follow shutdown/restart phenomenon during failures, DB2 has been reliable from it's inception

Needed By Quarter
  • Admin
    Michael Roecken
    Sep 13, 2021


    Db2 restore offline backup (V10.5) to Db2 v11.5.5.1 processed 700-800GB and no response, LIST UTILITIES SHOW DETAIL is also not responsive. Even db2support is not responsive at Collecting "Application snapshot".


    it was hanging on the fcntl call. Customer fixed the filesystem issue. After that it went all well


    From the PMR I did not see whether db2pd -barstats was issued. But, if other db2pd commands had issues returning then -barstats would probably have the same problem. -barstats was specifically built for giving back details while a backup/restore operation is in progress. So if it or other commands hang we usually are in the extreme case of a OS call issue and we must resort to stack dumps that can confirm the call stack. This can be reported to IBM service for guidance.

    This is a rare but documented problem when Db2 file IO is blocked behind a OS level system call and is not just restore that is prone to this. Quite sure one will find APARS and/or tech notes on this topic. Here is one such article:

    Reading the PMR, support did the best they could to assess and assist in this problem report.

    The broader initiative would be to wrap all OS calls in a fashion where we can time out and check in on progress. This adds layers and complexity to our many, many OS calls. It is not something we have in plan at this time.

    Thank you for your idea suggestion.

  • Admin
    Michael Roecken
    Aug 14, 2021

    I found the support case in the RFE, will look into it.

  • Admin
    Michael Roecken
    Aug 13, 2021

    So what specifically would you like to have seen that would have helped you in your situation? -barstats is still new and we add to it over time. Any feedback we get to make it better is much appreciated.

    I do not know what issue you reported to Db2 Support. If you can please quote a PMR number/ticket I can dig deeper to see more details into your problem report.

    In general, it is very rare for all those commands to not respond, so I am interested in seeing what conclusion was established by the PMR ticket you opened. LIST UTILITIES is our progress monitoring command for RESTORE. -barstats "should" display similar information.

    Anyhow, we look forward to your reply on how to make our tooling better.


  • Guest
    Aug 13, 2021

    db2pd -barstats was issued and nothing useful came out of it

    The speed with which this idea was closed shows the intent of IBM to not do anything, it's an waste of time trying to get this product work better, the writing is on the wall with AWS and Azure that DB2 is going down the sink, probably it'll get there sooner

  • Admin
    Michael Roecken
    Aug 13, 2021

    Was db2pd -barstats used to find out more internal information from the restore? This can tell you some helpful information.

    If it was used and information was still not helpful then please re-open this Idea with what specifically is still missing and we can assess.