Re: SYSPARTITIONSTAT

Hello Rob

Thanks for refering me to SYSPARTITIONSTAT
I surly need to evaluate No. of writes when considering SSDs

But SYSPARTITIONSTAT looks incomplete,

The following SQL shows 0's (zero) for the number of inserts, updates,
deletions
(open an close are not zero)

select table_schema, table_name, sum(OPEN_OPERATIONS) as Open,
sum(CLOSE_OPERATIONS) as close,sum(INSERT_OPERATIONS) as wrt,
sum(UPDATE_OPERATIONS) as upd, sum(DELETE_OPERATIONS) as dlt
from QSYS2.SYSPARTITIONSTAT
where table_schema = 'PRFLIBD' and table_name = 'DSTACTBF'
group by table_schema, table_name

(DSTACTBF is a Multi-Member file)

I tested it on a 7.2 machine and on a 7.3 machine as well.

Any thoughts ?

Gad

date: Tue, 21 Nov 2017 15:41:19 -0500
from: Rob Berendt <rob@xxxxxxxxx>
subject: RE: Emails from IBM Announcement Letters <gasm@xxxxxxxxxx>

Hmm, a Db2 for i Service which combines the detail of
QSYS2.DISKSTAT -
https://www.ibm.com/developerworks/community/wikis/home/wiki/IBM%20i%
20Technology%20Updates/page/Add%20QSYS2.SYSDISKSTAT%20catalog
with performance detail such as the I/O's since last IPL kind of stuff in
SYSPARTITIONSTAT -
https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_
73/db2/rbafzcatsyspstat.htm
With the goal being "If I replace my spinning disks with SSD's will my
number of writes blow through them in a year?"


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