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
Document the client_prdid for each Fix Pack release of db2jcc.jar and db2jcc4.jar drivers
When Java applications connect to DB2 via the JDBC Type 4 JCC driver, the only version-specific identifier visible from the DB2 server (via an application snapshot) is the client product ID of the driver, such as JCC03000. This value is currently ...
Add Transaction Application lock types to the DBMS_LOCK package
We understand that there is an implementation of a version of the Oracle DBMS_LOCK package (minus transaction type and various modes) available on Db2 for LUW. While we can make some use of the session application lock type, we also have a need fo...
Add more debug information for error  [IBM] [DB2/NT64] SQL0302N
Ticket TS003868349 In a real-life application, I had a headache with error  [IBM] [DB2/NT64] SQL0302N "The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use." Namely, in an application which de...
Your DB2 Entity Framework Core driver does not support value convertors. https://docs.microsoft.com/en-us/ef/core/modeling/value-conversions Value convertors are really useful with databases to do things like: Translate Y/N fields to proper boolea...
Enhance functionality of WITH clause to operate with DELETE and UPDATE in DB2 SQL statements like others flavours of SQL
Our team uses IBM DB2 18.104.22.168 Database Server for development activities. We see limitations of DB2 SQL WITH clause to work with only SELECT unlike other flavors of SQL like T-SQL which operates other DML operations.
Just like how WITH simplif...
Default of for read only for all select statements
As you might have noticed, the "for read only" clause of the select statement in DB2 is not widely known nor used. Most standards select statements going through the DB2 engine have the risk of becoming an ambiguous cursor with sub-optimal perform...
use of SET CURRENT APPLICATION COMPATIBILITY for ONLINECHECK in db2sqljcustomize command
The SQLJ Profile Customizer command db2sqljcustomize (described in the DB2 11 for z/OS Application Programming Guide and Reference for Java) with the options -onlinecheck YES and -genDBRM is used to create a DB2 z/OS DBRM for a SQLJ Java program. ...
UTL_ENCODE.BASE64_ENCODE and BASE64_DECODE support
Request for official support of UTL_ENCODE module and.BASE64_ENCODE procedure, that is not documented in Infocenter 10.5 but is available in DB2 LUW. Request for creation and support of UTL_ENCODE.BASE64_DECODE procedure.
Add the ability to control db2sqljcustomize behavior on untyped host variables and prevent silent data type conversion
We modernize a banking database application originally written in COBOL by migrating the functionality into a new written Java application.
During this application migration we noticed that there is an issue with unexpected/unwanted data type con...
Do not place IBM confidential, company confidential, or personal information into any field.