Skip to Main Content
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

Db2 High Performance Unload for z/OS

Showing 15

HPU : external file support for IN predicate

our customer wants to migrate from a competitor's product to IBM HPU. This product supports the following syntax to read a list of arguments for the SQL - WHERE IN predicate from a flat file. The syntax is as follows: SELECT * FROM creator.tbnameW...
7 months ago in Db2 High Performance Unload for z/OS 0 Planned for future release

Double " delimiter issue with HPU

When unloading from an Imagecopy using HPU, data gets unloaded like this : " 12345"~"SMA "O" DRAIN TILE CO. LTD. 05 while with DSNUTILB, it gets unloaded like this: " 12345"~"SMA ""O"" DRAIN TILE CO. LTD. 05. If you look at 'O' in the company name...
about 1 year ago in Db2 High Performance Unload for z/OS 1 Future consideration

Unload LOCK YES Drain Writers instead of executing LOCK TABLE

When executing HPU in Native MODE with parameters ULLOCK = YES, ULLOCKTE = LOCK and ULLOCKMO = NATIVE_ONLY HPU executes a EXEC SQL LOCK TABLE. Sometimes table being locked is in a TS whose a IX TS lock was left in DB2 due to this table be used in ...
over 1 year ago in Db2 High Performance Unload for z/OS 1 Not under consideration

For DB2 Force, allow for execution of SQLs prior to the SELECT

There are many times when we need to execute some SQLs prior to the actual SELECT that will unload the data. This could be as simple as SET CURRENT SCHEMA TO XXXX; (if we are using secondary auth id, the default schema of the tables can not be spe...
about 2 years ago in Db2 High Performance Unload for z/OS 1 Not under consideration

HPU usage

I have a question about HPU for Z/OS, and I’m wondering if you can open a ticket with IBM for me? The issue is that we would like to extract character columns such that they are wrapped in quotes, and if there are any quotes in the column, we’d li...
over 3 years ago in Db2 High Performance Unload for z/OS 1 Not under consideration

Allow more than one separator character when unloading in delimited format

A competitor's unload tool allowed us to specify more than one character in the separator field when unloading data in delimited format. We had to use more than one character, because for unloads of certain tables, we couldn't find a character tha...
almost 4 years ago in Db2 High Performance Unload for z/OS 0 Not under consideration

Support spanned unload of XML columns

Although the documentation and the error message content if you try to do this suggests that this is possible, it isn't. We would like XML to be supported with spanned unloads just as LOB columns are today (and have been supported in the core IBM ...
over 4 years ago in Db2 High Performance Unload for z/OS 2 Planned for future release

LOCK YES should imply QUISECE YES

Because HPU is not an application program and not a 'true Utility', it does not check all instances of other Utilities for incompatibility. Users will run HPU and other Utilities will that try to start may not see that HPU is running and there cou...
almost 5 years ago in Db2 High Performance Unload for z/OS 1 Not under consideration

Value 00000 on variable &PART in TEMPLATE for partitioned by growth tablespaces

We would like that value of &PART becomes 00000 for partitioned by growth tablespaces on the template's DSN. The response on PMR 27187,999,838 is that this needs to be a RFE. As you can see in PMR 27187,999,838, we have processes that does a f...
over 5 years ago in Db2 High Performance Unload for z/OS 1 Not under consideration

Use of access path to decide whether to use NATIVE / SQL mode

We have several unloads that use HPUs with SUPPORTED select that download UTS PBG.Queries are unfortunately written by programmers who can change them independently and often don't know how many rows they will have to download and therefore they d...
over 5 years ago in Db2 High Performance Unload for z/OS 1 Not under consideration