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
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
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.
Thank you for submitting this request. I am declining it at this time because of the potential performance concerns and other alternatives available.
Hi Guys
You both raise some good points, the problem seems to be that no matter what IBM adds to the command line, there is always a trade off in performance or data. The good news is this is one of the thought processes behind IBM i Services. So, today you can create a customer SQL statement that will give you the information you are asking for in exactly the sequence you choose and with the data included that you want.
For example, you could use a statement like:
SELECT X.Objname, X.Objtype, X.Objowner, X.Objcreated, X.Objsize, X.Objtext, X.Last_Used_Timestamp
FROM TABLE(qsys2.object_statistics('YourLib', '*ALL', 'P*'))
AS x
Order By X.Objtype, X.Objname
;
Note the three paramaters on the qsys2.object_statistics
The first is the library name you are interested in
The seconds the Object Type, this can be specific like *PGM or *FILE or generic like *ALL
The third is the object names you want, again this can be specific, *all or a partial match like the P* I used giving me all objects starting with a P
I hope this helps
Best wishes, Brad
Steve Bradshaw
IBM Champion, Member of CEAC, TD of i-UG.co.uk
and Friendly Techie Bloke at RowtonIT.com
I also wish for the this function, but this will significantly slow down the command while the system counts and adds object sizes (each file member is processed individually so this is particularly bad on libraries with many source members).
I DO NOT want to live with the slowness. If IBM does this, they will need to add a parameter with the default of no-totals.