IBM Power Ideas Portal


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 updates on them if they matter to you. If you can't find what you are looking for,

Post your ideas

  1. Post an idea.

  2. Get feedback from the IBM team and other customers to refine your idea.

  3. Follow the idea through the IBM Ideas process.


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.

ADD A NEW IDEA

Db2 for i

Showing 183

GENERATE_SQL_OBJECTS() procedure IFS support enhancement

It would be very helpful if the generated SQL scripts could be generated as streamfile in the IFS. The scripts in the source physical file are not so easy to handle and read because our generated scripts are very extensive.At the moment we save ou...
over 6 years ago in IBM i / Db2 for i 5 Delivered

API or SQL view for WRKCMTDFN

Create an API or SQL view corresponding to the command WRKCMTDFN JOB (* ALL) STATUS (* PENDING). Use Case: We need to identify jobs that are waiting of commit validation. The goal is to stop jobs that are likely to prevent the synchronization poin...
over 6 years ago in IBM i / Db2 for i 2 Delivered

Change defaults on CRTSQLxxxI commands for cross reference

On CRTSQLxxxI commands, the default is OPTION(*XREF), but this does nothing. The precompiler only generates a cross reference when OUTPUT(*PRINT) and OPTION(*XREF) is specified. here should be a command dependency for OUTPUT(*PRINT) when OPTION(*X...
over 7 years ago in IBM i / Db2 for i 2 Delivered

Create SQL Service that produces a list simliar tp dsppgmref

develop sql service that does a similar role to dsppgmref. Use Case: In modernizing our system, I wrote a program that uses this command, populating a file with program references, display files, files etc. For a report. I was surprised to see tha...
about 8 years ago in IBM i / Db2 for i 3 Delivered

SQL Services view for IFS shares

Have need for an SQL view to list share and path information on an IBM i server. Use Case: SOX auditors want us to monitor for /ROOT shares created on the system, because they see these as a security threat. I've created a homegrown view utilizing...
about 8 years ago in IBM i / Db2 for i 1 Delivered

SQL Scalar function to check access to an IFS file or folder

IFS_ACCESS - SQL Scalar function to check access to an IFS file or folder It returns: 0=If the file or folder Exists and you have access -1=No access or file does not exists use case: -- returns 0 for the home folder - it exists values IFS_ACCESS ...
11 months ago in IBM i / Db2 for i 3 Delivered

Extending more IBM i Alerts for OS system limits

I am proposing an enhancement to our current IBM i alert system to improve our system monitoring capabilities and enable proactive management of potential issues. Current IBM i alerts are limited to monitoring only 8 predefined events. https://www...
11 months ago in IBM i / Db2 for i 4 Delivered

Additional Information from QSYS2.PTF_INFO

For those PTFs that have special instructions it would be useful to include this information via a NULL capable column of type CLOB, for example call PTF_SPECIAL_INSTRUCTIONS, so that it can be queried via the QSYS2.PTF_INFO view. Currently there ...
almost 2 years ago in IBM i / Db2 for i 3 Delivered

Add view or udtf JOB_QUEUE_ENTRIES

Because the view JOB_QUEUE_INFO already exist, so similar to the output_queue_xxx views the job_queue_entries view is missing select * from qsys2.job_queue_entrieswhere job_queue_name = 'QBATCH'
almost 2 years ago in IBM i / Db2 for i 3 Delivered

change RESPONSE_HTTP_HEADER for QSYS2.HTTP_GET_VERBOSE when we want cookie

The HTTP functions do not handle the multiple use of the "set-cookie" headers within an HTTP response. The root issue is that JSON keys should be unique and multiple instances of the "set-cookie" key are not permitted in JSON. Here is a possible a...
about 2 years ago in IBM i / Db2 for i 2 Delivered

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.