× 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.



Bryan,

You asked whether you should be concerned about a profile using over a
Gigabyte of storage.  Because the profile owns no objects then you're
looking at a very large amount of temporary storage.  I would say yes,
you should be concerned enough to figure out where the storage is being
used.  The degree of concern would relate directly to your amount of
available storage.  Are you measuring this storage when the system is
relatively calm?  If the system is very active (lots of database
activity) at the time you measure, then you are probably viewing normal
activity.

The quote below is from the OS/400 maximum capabilities reference.

"(9) OS/400 maintains internal user profiles that own objects that are
shared or cannot be assigned to a single individual user (for example,
QDBSHR owns shared database objects such as database formats, access
paths, and so on). These internal user profiles are subject to the same
limits as any other user profile on the system."

Regards,
Andy Nolen-Parkhouse

> On Behalf Of Burns, Bryan
> Subject: RE: What accounts for storage used by QDBSHR?
> 
> Yes, I have tried WRKOWNOBJ before but it comes up with "(The user does
> not
> own any objects.)"
> 
> Bryan,
> 
> Have you tried the WRKOBJOWN command?  Unless this is all temporary
> storage, you should be able to get a good indication of the objects
> involved.
> 
> Regards,
> Andy Nolen-Parkhouse
> 
> > On Behalf Of Burns, Bryan
> > Subject: What accounts for storage used by QDBSHR?
> >
> > User QDBSHR was using 227,420 kb of storage on 2/10/03. Today, QDBSHR
> > is
> > using 1,355,560 kb of storage.  This is based on a daily report I run
> > on
> > users who have more than 100mb DASD.
> >
> > Is this something I should be concerned about?
> >
> >
> > Bryan Burns



As an Amazon Associate we earn from qualifying purchases.

This thread ...

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.