IBM Data and AI

Welcome to the IBM Data and AI Ideas Portal for Clients!

We welcome and appreciate your feedback on IBM Data and AI Products to help make them even better than they are today!
Before you submit an idea, please perform a search first as a similar idea may have already been reported in the portal. If a related idea is not yet listed, please create a new idea and include with it a description which includes expected behavior as well as why having this feature would improve the service and how it would address your use case.
IBM Employees:
Clients:
  • Our team welcomes any feedback and suggestions you have for improving our offerings / products! This forum allows us to connect your offering / product improvement ideas with IBM product and engineering teams.

  • If you have not registered on this portal please click on the following link and register. To complete registration you will need to open the email you will receive from Aha to confirm your identity. http://ibm.biz/IBM-Data-and-AI-Portal-Register

Additional Information:
  • The shorter URL for this site is: https://ibm.biz/IBM-Data-and-AI-Ideas

  • 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

  • Please do not use the Ideas Portal for reporting bugs - we ask that you report bugs or issues with the product by contacting IBM support.

Improve AOT backup performance

We're using IDAA loader V 2.1 to run backups for very huge AOTs. When IDAA loader takes a backup from an IDAA AOT it uses SQL multirow fetch to transfer the data from IDAA into a z/OS sequential file. This may work fine for small AOTs. But in our environment the AOTs are very big and the SQL fetch mechanism to backup the data is not a good choice since this leads to very high CPU usage and very long elapse times. For example we determine a 70 time longer elapse time, 35 time higher CPU usage, 2.8 time higher I/O-Count and 46 time higher SU count (including zIIP-SU for the IDAA loader Backup Utility) compared to a full DSNUTILB IC for a table containing the same data in Db2 for z/OS and on IDAA. (51'239'384'238 Rows)

From a product like the IDAA loader we expect a much better backup performance. There should be another mechanism than SQL fetch to transfer the data from IDAA to z/OS. For example DSNUTILB uses direct access paths to the VSAM Cluster to read the data instead of fetching it.

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Mar 3 2020
  • Future consideration
Who would benefit from this IDEA? All customers using the AOT backup function.
How should it work?

Get data with an internal IDAA mechanism instead through Db2 SQL fetch.

Idea Priority Urgent
Priority Justification For succeeding our project we need much higher backup performance very soon.
Customer Name Zuercher Kantonalbank
  • Attach files
  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    3 Mar 08:59pm

    Good to know, thanks for sharing

NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "anonymous@euprivacy.out" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions