26) How to find the AWT UTILIZATION FOR PARTICULAR TIMEFRAME ?
Answer >
SELECT
T1.TheDate( FORMAT ‘yy/mm/dd’ , TITLE ‘// // Date’ ) DATE_1,
T1.TheTime( FORMAT ’99:99:99′ ) TIME_1,
MAXIMUM ( T1.inusemax ) AWT_MAX_USE
–MAXIMUM ( 100 * ( T2.cpuuexec + T2.cpuuserv ) / ( T2.cpuuexec + T2.cpuuserv + T2.cpuidle + T2.cpuiowait ) ) AS CPU_PCT_MAX
FROM PDCRINFO.ResUsageSAWT AS T1
LEFT OUTER JOIN PDCRINFO.ResUsageSPMA AS T2
ON T1.TheDate=T2.TheDate and T1.TheTime=T2.TheTime
WHERE T1.TheDate =’2014-03-28′ — CHANGING THE DATE AS REQUIRED
AND T1.TheTime BETWEEN 224500 AND 235900
GROUP BY 1,2