This portal is to open public enhancement requests against IBM Power Systems products, including IBM i. 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 an idea.
Get feedback from the IBM team and other customers to refine your idea.
Follow the idea through the IBM Ideas process.
Specific links you will want to bookmark for future use
Improve tracking of what job is the client job for QSQSRVR jobs with ability to review over time
Today, a CPF9898 message is logged to the QSQSRVR job log with the server mode connecting job information. This is useful while the client is actively using the job, but it is insufficient to assess the overall workload on QSQSRVR jobs by the vari...
Require QIBM_DB_SECADM or similar to perform set session authorization
Today any user with *ALLOBJ is able to do the equivalent to sudo in Linux without the need of any password to become another user using set session authorization via SQL. Any user with *ALLOBJ can become Qsecofr by open strsql and run: “Set sessio...
Allow variable number of arguments on SQL CONCAT function
The current implementation of CONCAT only allows two parameters, for example CONCAT('hello', 'world') which makes concatenating multiple values cumbersome. This would for example result in CONCAT(CONCAT('hello', 'world'), 'again') for 3 strings. I...
Trace usage of External SQL functions (linked to an external program) in OBJECT_STATISTICS or somewhere else
There is no IBMi object for External SQL Functions (linked to an external program). These functions are only knows and identified in DataBase level. It is impossible to know the last usage date for these functions. You can get the last usage date ...
A UUID is a Universally Unique Identifier, meaning that these identifiers are unique over your whole DB; even better unique" across space and time". UUID's are stored in 128bit format and follow a standarized format (rfc4122) This makes the type a...
I think then the new sql function for http_get are really interesting, fast and above all there isn't java! I started use it instead of systools funcion, but I need an http_get that allow me download binary files like .zip . Please implement it! M...
Create SQL Functions ("IBM Services") that retrieve the Problems database information (QASX* files and WRKPRB command)
Using WRKPRB we can see some of the information related to hardware and software problems. That info is stored in the QAXS* database files in QUSRSYS. I would like a set of SQL Table functions or VIEWS that can be used to access that information v...
Implementation of restore function that does not change the state of the access path
We would like you to implement the restore function that does not change the state of the access path by implicitly shared access paths. Our customers are having trouble getting their program to do something unexpected by save and restore.
The function ADD_DAYS, ADD_HOURS, ADD_MINUTES, ADD_SECONDS, ADD_YEARS exist on DB2 LUW, but not on DB2 for i.
However the function ADD_MONTHS is implemented on DB2 for i.
Adding those missing functions on DB2 for i would be very useful to manage t...
DB2 on z/OS offers the FINAL TABLE with the MERGE statement, however on IBM i this is limited to INSERT only.
Please change DB2 for i to also support FINAL TABLE combined with MERGE.
Use case :
in the query below, which increments a counter...
Do not place IBM confidential, company confidential, or personal information into any field.