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,

  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 (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


Add a new idea Subscribe
Status Not under consideration
Workspace Db2 Utilities Suite for z/OS
Created by Guest
Created on Oct 7, 2019

RELATED IDEAS

Eliminate Reorgs failing with S513 & IEC146I 513-04 when reorging LOBs

The cause of the S513 error is due to the DB2 reorg utility trying to write two image copies in parallel (one for BASE and one for LOB) when a BASE UTS with LOB TS is being REORG’d and the specified template for image copy datasets has the STACK YES parameter. We understand that in order to allow parallel writes to image copy datasets for BASE and LOB table space, the template to use should have the STACK NO parameter.

However, since we image copy to tape it causes the DB2 utility to acquire multiple tape drive units all at once on REORG of UTS for each partition, especially on PBRs with high number of partitions. In our shop we cannot do this and would like not to have to break our reorg jcl into pieces. One step should handle all objects without failure. the utility should be smart enough not to cause S513 abends

Needed by Date Jan 1, 2020
  • Guest
    Reply
    |     Oct 12, 2020

    This issue complicates our automation to an unnecessary degree. We have to split out tables with LOBs into separate LISTDEF with STACK NO (by joining sysibm.systables to sysibm.sysauxrels). I understand the goal is to allow for parallel REORG of the table tablespace and the LOB tablespace. However it would be good if we had some smarts (as detailed in the IDEA) or options to simplify REORG/LISTDEF/TEMPLATE automation please?

  • Guest
    Reply
    |     Mar 2, 2020

    Might it be a better solution to remove the conflict altogether, allowing the LOB and the TS to exist on the same tape? For example, the table DSN_QUERYINFO_TABLE is in TS DSN8S11Q; it has two related LOBs : DSN_QUERYINFO_AUX and DSN_QUERYINFO_AUX2 which exist in TS DSN8L11Q and DSN8L11R respectively. If the IC datasets differentiate on the TS level and it also happens that the internal object identifiers are different, is it possible to avoid the conflict for the IC?

  • Guest
    Reply
    |     Oct 10, 2019

    This IDEA came from Case # TS002809105 - Reorgs fails with S513 &
    IEC146I 513-04

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.