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 of 15437

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

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

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

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