In other words - where does the ITPA look for in the Database - to get the data and render this.
Here,I will try to delve into just 1 attribute of the UNIX agent - i.e Unix_Memory, and one ITPA task "Available Memory' and connected to DB2 data base.
Requirements : Historical collections for UNIX agent has to be configured first.
Next, the Summarization and Pruning for the Unix Attribute has to be configured.
The UNIX agent has these columns for "Available Memory ".
If you look at the DB2 Database, and the Historical colleciton for the UnixOS agent is configured and active.
Unix_Memory ITMUSER T 2013-06-26-12.19.15.589568
Unix_Memory_D ITMUSER T 2013-06-26-12.20.50.073287
Unix_Memory_DV ITMUSER V 2013-06-26-12.20.53.727654
Unix_Memory_H ITMUSER T 2013-06-26-12.20.45.292147
Unix_Memory_HV ITMUSER V 2013-06-26-12.20.49.760437
Unix_Memory_W ITMUSER T 2013-06-26-12.20.54.066615
Unix_Memory_WV ITMUSER V 2013-06-26-12.20.58.156429
Unix Memory_D means the daily sumarization is configured.
_H and _W - are the Hourly and the Weekly.
// lists all the records.
select count(*) from itmuser."Unix_Memory" <== typically will have 245 records for example.
// lists summarized data.
Summarized data:
select count(*) from itmuser."Unix_Memory_D" <== will have 2 - since we have had daily - and its two days since the agent was started.
select count(*) from itmuser."Unix_Memory_H" <== will have based on the hours - for 2 hours it will have 7 or 8 entries.
7 <========= This is what we will focus in this blog.
Since we have set the ITPA task to forecast based on the Hourly - the TEP GUI will show 7 entries. ( and it has been close to 2 hours since I started monitoring the agent.
and at 15 minutes each, there will be 7 summarized entries)
describe table itmuser."Unix_Memory"
Data type Column
Column name schema Data type name Length Scale Nulls
------------------------------- --------- ------------------- ---------- ----- ------
TMZDIFF SYSIBM INTEGER 4 0 No
WRITETIME SYSIBM CHARACTER 16 0 No
System_Name SYSIBM VARCHAR 64 0 No
Timestamp SYSIBM CHARACTER 16 0 Yes
Total_Virtual_Storage_MB SYSIBM INTEGER 4 0 Yes
Used_Virtual_Storage_MB SYSIBM INTEGER 4 0 Yes
Avail_Virtual_Storage_MB SYSIBM INTEGER 4 0 Yes
Virtual_Storage_Pct_Used SYSIBM DECIMAL 31 1 Yes
Virtual_Storage_Pct_Avail SYSIBM DECIMAL 31 1 Yes
Total_Swap_Space_MB SYSIBM INTEGER 4 0 Yes
Used_Swap_Space_MB SYSIBM INTEGER 4 0 Yes
Avail_Swap_Space_MB SYSIBM INTEGER 4 0 Yes
Used_Swap_Space_Pct SYSIBM DECIMAL 31 1 Yes
Avail_Swap_Space_Pct SYSIBM DECIMAL 31 1 Yes
Total_Real_Mem_MB SYSIBM INTEGER 4 0 Yes
Used_Real_Mem_MB SYSIBM INTEGER 4 0 Yes
Avail_Real_Mem_MB SYSIBM INTEGER 4 0 Yes
Used_Real_Mem_Pct SYSIBM DECIMAL 31 1 Yes
Avail_Real_Mem_Pct SYSIBM DECIMAL 31 1 Yes
Page_Faults SYSIBM INTEGER 4 0 Yes
Page_Reclaims SYSIBM INTEGER 4 0 Yes
Page_Ins SYSIBM INTEGER 4 0 Yes
Page_Outs SYSIBM INTEGER 4 0 Yes
Page_In_Reqs SYSIBM INTEGER 4 0 Yes
Page_Out_Reqs SYSIBM INTEGER 4 0 Yes
Page_In_KB_S SYSIBM INTEGER 4 0 Yes
Page_Out_KB_S SYSIBM INTEGER 4 0 Yes
Page_In_1Min SYSIBM INTEGER 4 0 Yes
Page_In_5Min SYSIBM INTEGER 4 0 Yes
Page_In_15Min SYSIBM INTEGER 4 0 Yes
Page_In_60Min SYSIBM INTEGER 4 0 Yes
Page_Out_1Min SYSIBM INTEGER 4 0 Yes
Page_Out_5Min SYSIBM INTEGER 4 0 Yes
Page_Out_15Min SYSIBM INTEGER 4 0 Yes
Page_Out_60Min SYSIBM INTEGER 4 0 Yes
Page_Scan SYSIBM INTEGER 4 0 Yes
Page_Scan_KB SYSIBM INTEGER 4 0 Yes
Page_Scan_1Min SYSIBM INTEGER 4 0 Yes
Page_Scan_5Min SYSIBM INTEGER 4 0 Yes
Page_Scan_15Min SYSIBM INTEGER 4 0 Yes
Page_Scan_60Min SYSIBM INTEGER 4 0 Yes
ARC_Size_MB SYSIBM INTEGER 4 0 Yes
Net_Memory_Used SYSIBM INTEGER 4 0 Yes
Net_Memory_Avail SYSIBM INTEGER 4 0 Yes
Net_Memory_Used_Pct SYSIBM DECIMAL 31 1 Yes
Net_Memory_Avail_Pct SYSIBM DECIMAL 31 1 Yes
Non_Comp_Memory SYSIBM INTEGER 4 0 Yes
Comp_Memory SYSIBM INTEGER 4 0 Yes
Decay_Rate SYSIBM INTEGER 4 0 Yes
Repaging_Rate SYSIBM INTEGER 4 0 Yes
Pages_Read_per_Sec SYSIBM INTEGER 4 0 Yes
Pages_Written_per_Sec SYSIBM INTEGER 4 0 Yes
Paging_Space_Free_Pct SYSIBM INTEGER 4 0 Yes
Paging_Space_Used_Pct SYSIBM INTEGER 4 0 Yes
Paging_Space_Read_per_Sec SYSIBM INTEGER 4 0 Yes
Paging_Space_Write_per_Sec SYSIBM INTEGER 4 0 Yes
56 record(s) selected.
these 7 records are what will be visible to the user in the TEP GUI panel.
On the ITPA side this is what was configured.
--
Now, what if I change the ITPA to change the forecast granularity from Hourly to Daily ? will it change the TEP GUI measurement count ? to number of days.
Let's see.
Yes, the number of measurements = 2 - ( its; almost 2 days I started the monitoring - the first day - I had it on and off for a bit )
Note, that the ITPA task config changed to Daily.
This tells me that the ITPA configuration from Hourly, Daily, Weekly , Monthly, Quarterly, will depend on the number of summarized data in the DB2 for UNIX OS Agent.
i.e
Unix_Memory ITMUSER T 2013-06-26-12.19.15.589568
Unix_Memory_D ITMUSER T 2013-06-26-12.20.50.073287 <=== for Daily. ( in this case we have 2 records -since its 2 days since I started it on/off )
Unix_Memory_DV ITMUSER V 2013-06-26-12.20.53.727654
Unix_Memory_H ITMUSER T 2013-06-26-12.20.45.292147 <== For hourly ( in this case I have 7 entries, one for every 15 mins, and its been close to 2 hrs )
Unix_Memory_HV ITMUSER V 2013-06-26-12.20.49.760437
Unix_Memory_W ITMUSER T 2013-06-26-12.20.54.066615 <== for weekly
Unix_Memory_WV
Now, lets look at ITPA Forecast and Status tables.
Memory Overall tables
Mem_Utilization_LT_Fcast ITMUSER T 2013-06-26-12.23.33.169192
Mem_Utilization_LT_Status ITMUSER T 2013-06-26-12.23.31.573179
Memory Forecast Summarized tables.
Mem_Utilization_LT_Fcast ITMUSER T 2013-06-26-12.23.33.169192
Mem_Utilization_LT_Fcast_D ITMUSER T 2013-06-26-12.35.23.324907
Mem_Utilization_LT_Fcast_DV ITMUSER V 2013-06-26-12.35.25.954956
Mem_Utilization_LT_Fcast_H
Memory Status Summarized tables.
Mem_Utilization_LT_Status_D ITMUSER T 2013-06-26-12.35.40.951635
Mem_Utilization_LT_Status_DV ITMUSER V 2013-06-26-12.35.43.587620
Mem_Utilization_LT_Status_H ITMUSER T 2013-06-26-12.35.37.870105
Mem_Utilization_LT_Status_HV ITMUSER V 2013-06-26-12.35.40.716305
Mem_Utilization_LT_Status_M ITMUSER T 2013-06-26-12.35.46.
No comments:
Post a Comment