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 12

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

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

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...
about 5 years ago in Db2 High Performance Unload for z/OS 1 Not under consideration

HPU V5.1 - Keep the connection in TSO / DB2 CALL / BATCH / UTILITY / CAF instead of ODBC/RRSAF (the same as HPU V4.3 version) RFE 123074

http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=123074 Communication switches to ODBC / RRSAF instead of DB2CALL. Our environment has the 'Exit' DSN3@ATH (Conections = TSO / DB2CALL / BATCH / UTILITY / CAF) which changes t...
over 6 years 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...
over 2 years ago in Db2 High Performance Unload for z/OS 1 Not under consideration

DB2 HPU should honour AUTH_COMPATIBILITY

Db2 High Performance Unload does not honour Db2 v12 zparm AUTH_COMPATIBILITY when it is set to Null. There has long been the need to lock down the Unload utility to minimise data leakage risks. This capability was delivered in Db2 v12, but it has ...
almost 6 years ago in Db2 High Performance Unload for z/OS 1 Not under consideration

Add GROUP BY and DISTINCT to HPU RFE 118682

http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=118682 The request is to allow HPU tool to support GROUP BY and DISTINCT SQL statement (be part of the hpu syntax diagram ) so that message INZU063I UNSUPPORTED SELECT wont o...
over 6 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

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