RE: "Work with Saved Objects " to restore a single object

Just an FYI.

IBM does not recommend using Object Level detail.
Object Level detail adds overhead, plus you must also then save this detail from QUSRBRM, almost doubled my save window.
I would have liked to keep the detail turned on, but could not afford the overhead.

Paul

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

You're welcome.

It may be that *NO or *ERR is the default.
It may be their doing something stupid, like reusing the tapes outside of BRMS expiration and fighting the system so the detail wouldn't be of any use.
It may be they didn't want to lose the $1.95 worth of disk space this object detail would consume.
It may be they had no knowledge of WRKOBJBRM and how useful this was.

Granted, when we started using BRMS we had a consultant come onsite and give us training and installation. You buy machines on a somewhat regular basis and you get these free training and consulting credits you have to use up anyway...


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: "Lindstrom, Scott R." <Scott.Lindstrom@xxxxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 02/10/2015 10:31 AM
Subject: RE: "Work with Saved Objects " to restore a single object
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



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