Skip to Main Content
IBM Z Software


This portal is to open public enhancement requests against IBM Z Software products. 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.

Status Under review
Created by Guest
Created on Aug 20, 2025

Increase options for XDB2READ to produce more granular reports in DB2READ

DB2READ supports parm DB2DAYS=nnn to set the breakpoint for what is concidered a current backup. And XDB2READ can be used to exclude on database and/or tablespace name. 

Within a Db2 system, there can be many different databases that have different way of working. And they can be managed by different devops teams. 
For many databases, a DB2DAYS= value could be the same, i.e. equal to the number of days that logcopy files are retained. 
But other databases can work with partition rotation by month. This means that in month 1 partition 1 is written into. At start of month 2 partition is written into. Partition 1 becomes a read-only partition, so a final imagecopy is taken. The imagecopy file for this partition can be 10 years old, but it still is the last/valid imagecopy of that partition. 

So there is a need to run DB2READ with DB2DAYS=nnn for database AA, BB, CC, etc, but a different DB2DAYS=nnn for database XX,YY,ZZ.
And DEVOPS would run the report on the databases they are responsible for. So devops team 1 wants the report for database AA and ZZ, devops team 2 for database BB, XX and YY. 
Now XDB2READ can eliminate on the database/tablespace you do not want to see, but it cannot be used to run the utility on selected databases that you do want to see. 
So when devops team 1 wants the report for database AA and ZZ, it will have to use drop statements for all databases on the system
And devops team 2 will have to do similar for their report. And all devops would have to adjust XDB2READ every time someone adds a new database. 

It needs some kind of INCLUDE method (drop *, include AA and ZZ). Adding support for a test on "not equal" would be ok too, if supported with and/or function. 
IF DBNAME <not equal> 'AA' & DBNAME <not equal> 'ZZ' THEN DROP = 1 

Additionally it will need wildcard processing. 
i.e. Devops team 1 is responsible for payrolls. This payroll system has many databases. PAYDB001 - PAYDB999
They would need to be able to run the report using IF DBNAME <not equal> 'PAYDB*' THEN DROP = 1 (or drop *, include PAYDB*)
 

Idea priority Medium