Skip to Main Content
IBM Data Platform Ideas Portal for Customers


This portal is to open public enhancement requests against products and services offered by the IBM Data Platform 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

Search results: Db2 High Performance Unload for z/OS

Showing 13 of 5235

Providing a new HPU parameter so that we can chose the number of BSAM buffers for SORTIN.

When unloading and sorting data due to ORDER BY option, HPU reads data from tablespace and write it to DFSORT SORTIN dataset via QSAM with BUFNO=60, that is a default. In the environment where zHPF is enabled, DFSORT has used BSAM for SORTIN since...
almost 6 years ago in Db2 High Performance Unload for z/OS 4 Delivered

HPU 'FASTU-DELIMITED' output format delimiter issue

We are in the process of converting CA DB2 Fast Unload jobs to IBM HPU and got the below issue for atleast 16 Batch jobs and impacting the migration to IBM DB2 tools. Faced the delimiter issue with IBM HPU as below :- CA Fast Unload output - '000R...
8 months ago in Db2 High Performance Unload for z/OS 2 Planned for future release

Read and Write partitions in parallel with only one OUTDDN dataset

Recently, during some tests, we observed that using a single dataset for each part in the OUTDDN with &PART drastically improves the elapsed time of the HPU job (with benefits for data availability, reduced contention probability, etc.). Howev...
6 months ago in Db2 High Performance Unload for z/OS 2 Functionality already exists

Fixed column List for a Select * based on a timestamp

It can be very useful if we could input a timestamp in the Unload cards which results in any column that were added to the table post the timestamp to be excluded from the column list to be unloaded. This will give a nice mechanism so that a SELEC...
7 months ago in Db2 High Performance Unload for z/OS 0 Planned for future release

HPU should has issued LOCK TABLE statement in SQL mode.

Db2 High Performance Unload for z/OS V5.1 documentation says that when we specify LOCK YES, the table can be accessed only in read-onlymode. But according to PMR: 00483,6V5,760, HPU can not issue LOCK TABLE in the case of SQL mode. <>Db2 Hig...
over 6 years ago in Db2 High Performance Unload for z/OS 0 Delivered

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,https://bigblue.aha.io/ideas/ideas/ZHPUL-I-31 it gets unloaded like this: " 12345"~"SMA ""O"" DRAIN TILE CO. LT...
about 2 years ago in Db2 High Performance Unload for z/OS 2 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 5 years ago in Db2 High Performance Unload for z/OS 0 Not under consideration

LISTDEF support for DB2 Views in HPU RFE 101390

https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=101390 HPU supports to generate a list of objects - 'LISTDEF listname INCLUDE TABLESPACES TABLE owner.tbname' - that is later used in the UNLOAD. But, there is no support t...
over 8 years ago in Db2 High Performance Unload for z/OS 0 Delivered

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