IBM Data and AI Ideas Portal for Customers


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:

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

Help IBM prioritize your ideas and requests

The IBM team may need your help to refine the ideas so they may ask for more information or feedback. The product management team will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at IBM works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.

Receive notification on the decision

Some ideas can be implemented at IBM, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.

Additional Information

To view our roadmaps: http://ibm.biz/Data-and-AI-Roadmaps

Reminder: This is not the place to submit defects or support needs, please use normal support channel for these cases

IBM Employees:

The correct URL for entering your ideas is: https://hybridcloudunit-internal.ideas.aha.io


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

    Summary:

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

    Outcome:

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

    Conclusion:

    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: https://www.ibm.com/support/pages/how-diagnose-hang-openfcntl-system-call

    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.


    Thanks.

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


    Thanks.