× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



It has either *NO or *ERR depending on the line. So now I see I don't collect object level info.

TY!

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Tuesday, February 10, 2015 9:01 AM
To: Midrange Systems Technical Discussion
Subject: RE: "Work with Saved Objects " to restore a single object

WRKCTLGBRM
5=Display
What do you have in this column?
Retain
Object
Detail


IDK if turning this on can change the disk consumption.
select sum(objsize) from table (qsys2.object_statistics('QUSRBRM','*ALL')
) AS X
SUM ( OBJSIZE )
41,113,997,312


select objname, objtype, objsize
from table (qsys2.object_statistics('QUSRBRM','*ALL') ) AS x
order by objsize desc

OBJNAME OBJTYPE OBJSIZE
QA1ALI2 *FILE 13,092,950,016
QA1AOD *FILE 12,602,519,552
QA1ADI2 *FILE 5,822,910,464
QA1A2DI2 *FILE 2,168,528,896
QA1A5OD *FILE 1,007,747,072
QA1A3OD *FILE 944,832,512
QA1A1OD *FILE 935,395,328
QA1A8OD *FILE 828,440,576
QA1A4OD *FILE 596,705,280
QA1A6OD *FILE 444,661,760
QA1A7OD *FILE 437,321,728
QA1A1LI2 *FILE 353,452,032
QA1A1DI2 *FILE 268,509,184
QA1ANET2 *FILE 249,131,008
QJR1A30559 *JRNRCV 221,577,216
QA1A9OD *FILE 204,537,856
...


Rob Berendt

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.