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 updateson 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,
Post an idea
Upvote ideas that matter most to you
Get feedback from the IBM team to refine your idea
Specific links you will want to bookmark for future use
LOAD utility support for removable media / TAPE for WORKDDN, SYSUT1 and SORTOUT
"... The LOAD utility WORKDDN data sets, SYSUT1 and SORTOUT, are multi-use datasets. When a very large table is loaded, it is sometimes necessary to use a tape device for these datasets. The problem is if error or discard processing is invoked, th...
Allow for Multiple Columns on LOAD INTO TABLE WHEN Criteria
We recently converted from BMC to IBM Db2 utilities. It would be very useful if multiple column names could be specified on the WHEN criteria for the Db2 LOAD utility. This would also make the functionality similar to the WHEN criteria of REORG WI...
Allow COPY with Templates to pick TAPE or DASD based on RTS
We are creating intraday Image Copy jobs that may contain a mix of small and large tables. We use Templates and Include/Exclude to determine which objects should go to TAPE and which should go to DASD. The threshold for what determines large or sm...
Load Utility: Extension of field selection criterion option by AND conditions
The Db2 for z/OS LOAD utility offers a field selection criterion for the INTO TABLE option via WHEN( ... = ...). Since increasingly complex data structures are used application developers want to specify more complex conditions for selection of to...
MODIFY with DELETEDS and DSN not cataloged printing message as ERROR... and completing with RC4. Should be WARNING instead of ERROR.
Reviewing the output, it is concerning seeing a message with ERROR in the text.
DSNU1323I ERROR DELETING IMAGE COPY DATA SET FOR object-type.object-qualifier.object-name DSNUM part-number DSN=dataset-name
This is not an ERROR but a fact of...
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 Y...
IBM Unload doesn't support parameter AT LOCAL for UTC Timestamp columns
In a SELECT statement the parameter AT LOCAL is supported, for example:
SELECTDCOLLID ,-- =' ' --CHAR(18)DNAME ,-- =' ' --CHAR(8)TIMESTMP ,-- =' '--TIMESTMPKOMMENTAR -- =' '--CHAR(50)FROM DB2YD0XD.YD01TQR0WHERE TIMESTMP AT LOCAL < '2019-09-26-...
Do not place IBM confidential, company confidential, or personal information into any field.