Re: What is on our SSD's?

[Jack Kingsley <iseriesflorida@xxxxxxxxx>]

Rob, what is the defintion of a preferred disk unit.  So you have 15K disks
and SSD combined then.

On Wed, Jan 11, 2012 at 2:50 PM, <rob@xxxxxxxxx> wrote:

> We do not segregate our SSD's into a separate ASP.  We did put a
> 'preferred disk unit' on our ERP data to encourage that stuff to go there.
>
> How do I tell what other data may be there (if any)?  Not just /QSYS.LIB
> stuff, but other IFS data also.
>
> WRKDSKSTS shows our SSD's at 98+% while the system as a whole is at 72+%.
>
> I can get some space back by acting upon the data from this query:
> SELECT SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME, SYSTEM_TABLE_MEMBER,
> AVGROWSIZE, NUMBER_DELETED_ROWS, avgrowsize* number_deleted_rows as
> wastedSpace
> FROM syspartitionstat
> WHERE SYSTEM_TABLE_SCHEMA='ERPLXF'
> ORDER BY 6 DESC
>
> But that still doesn't tell me if other, non ERP type data is there.
>
> Rob Berendt
> --
> 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
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.