Equivalent Sysmaster queries
select "BR = ", ((bu.value * 100.0)/(pr.value + bw.value * 1.0)),%
from sysprofile bu, sysprofile bw, sysprofile pr
where bu.name = 'buffwts'
and bw.name = 'bufwrites'
and pr.name = 'pagreads';
select "RAU = ",((ru.value * 100.0) / ((rd.value + ri.value + rid.value) * 1.0)), %
from sysprofile ru, sysprofile rd, sysprofile ri, sysprofile rid
where ru.name = 'rapgs_used'
and rid.name = 'btradata';
select "BTF = ",((sm.sh_curtime - sm.sh_pfclrtime)/60.0)/(((pr.value + bw.value) * 1.0)/c.cf_effective), Min
from sysprofile bw, sysprofile pr, sysshmvals sm, sysconfig c
where bw.name = 'bufwrites'
and c.cf_name = 'BUFFERS';