Skip to Main Content
IBM System Storage Ideas Portal


This portal is to open public enhancement requests against IBM System Storage products. 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
  1. Post an idea.

  2. Get feedback from the IBM team and other customers to refine your idea.

  3. Follow the idea through the IBM Ideas process.


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.

Status Not under consideration
Categories Flashcopy Manager
Created by Guest
Created on Mar 18, 2015

Flashcopy Offload Optimization of db2_all command

Offload apparently waiting for several minutes.
We saw issues during our offload testing with failing db2inidb commands when the log directories were not there. That is why we created the piece of code to create the log directories. Since for multi partitioned databases, multiple offload hosts can be used, we used the db2_all command to make sure that they are created on all offload hosts. There isn't a check if these directories are already there. From my pov, an additional check if all directories are already there on all offload hosts does not make too much sense since it would consume a lot of time as well. So in summary that code exists to make the offload work for all supported offload scenarios.

Now let's talk about performance. In your case the directory creation takes 23 minutes (taken from tsm4acs.brfr118atm1.20150219150017.trace). Unfortunately the code was not optimized. It issues 164 db2_all commands, each taking ~8-10s which sums up to the 23 minutes. That can be optimized to 24 db2_all commands (2 log dirs per partition) which would then only take 3-4 minutes for the log directory creation.

Idea priority Medium
  • Guest
    Reply
    |
    Jun 16, 2015

    Thank you for your recommendation, we have decided to implement this function as described. Our time frame is within the remainder of this year.

  • Guest
    Reply
    |
    Jun 12, 2015

    Due to processing by IBM, this request was reassigned to have the following updated attributes:
    Brand - Servers and Systems Software
    Product family - Storage
    Product - Tivoli Storage FlashCopy Manager

    For recording keeping, the previous attributes were:
    Brand - Tivoli
    Product family - Storage
    Product - Tivoli Storage FlashCopy Manager