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,
Post an idea
Upvote ideas that matter most to you
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
Hello,
Yes, Db2 HPU for z/OS already has the possibility to activate parallelism when reading the partitions with a single output file in output.
But.. it works diferent if you specify one output file for all partitions. These are not readed exactly in parallel and all are locked (if LOCK=YES) untill the writing is completely finished, and also its takes longer to complete. This has been discused in case TS018259855.
There, we arrived to:
Regarding your question
the lock on the table was kept for 10min which seems to indicate that it is kept until all the partitions are written to the output file, but we think it is not necessary to keep the lock on the table during the writing step just when reading the table which should take much less time assuming it is done in parallel. Please can you confirm that the lock is released after the writings to the output file and if so, could it be enhanced to keep the lock only until all the reads have been performed?
Due to HPU architecture such a change is not easy at all and no change of that kind is planned at this time.
We suggest that you open an AHA for this enhancement request via this url https://ibm-data-and-ai.ideas.ibm.com/
Hi, thanks for making the suggestion. I believe Db2 HPU for z/OS already has the possibility to activate parallelism when reading the partitions with a single output file in output. Please check out the Understanding and mastering parallelism in Db2 HPU section in HPU document, and in particular the paragraph that describes the VUU036/GBLPARA parameter:
partition parallelism: this applies to native mode only and stands for the parallelism between reading
tasks processing the dataset (either LDS or image copy data sets) of the partition from a single
tablespace. It is driven by the PARALLELISM lds or PARALLELISM (lds,...,...) option or the VUX025/
PARALLEL parmlib parameter. Such parallelism of reading can be enabled of disabled when a
partitioned table space is unloaded into a single output dataset with the VUU036/GBLPARAL parmlib
parameter. When the zIIP use is requested, the ZIIPMXPL option from the technical parameters options
block or the VUX042/ZIIPMXPL parmlib parameter is also taken into account.
Please let me know if you still have questions or suggestions for further enhancements.