Topic
  • 1 reply
  • Latest Post - ‏2012-12-11T15:52:09Z by SystemAdmin
Littlepace
Littlepace
2 Posts

Pinned topic Can you please explain how the availability reports for ITM work?

‏2009-07-29T07:39:52Z |
Can someone please explain how the availability reports calculate system availability?

Here is an example below of the SQL query utilised in the availability report:

(select substr("WRITETIME", 2, 6) as dt,
cast(substr("WRITETIME", 8, 2) as int) as hr,
(avg("TOT_Up_Time")*100/3600) as avgAttr
from "System_HV"
where "System_Name" = ?
and "WRITETIME" between '0000000000000000'
and
'9999999999999999'
group by substr("WRITETIME", 8, 2), substr("WRITETIME", 2, 6)
),

Can some one please explain the purpose of the column "TOT_Up_Time"?

For example if a server is available for a full 24 hour period shouldn't it have a 100% score? I include output from the
DB below based on the query and also the uptime from the AIX server, any help/explanations appreciated:

db2 => select substr("WRITETIME", 2, 6) as dt, cast(substr("WRITETIME", 8, 2) as int) as hr, (avg("TOT_Up_Time")*100/3600) as avgAttr from "System_HV" where "System_Name" = '<hostname>:KUX' group by substr("WRITETIME", 8, 2), substr("WRITETIME", 2, 6) order by dt, hr
Do you want to execute the above command ? (y/n) y

DT HR AVGATTR

090525 19 33
090525 20 92
090525 21 92
090525 22 92
090525 23 92
090526 0 92
090526 1 92
090526 2 92
090526 3 92
090526 4 92
090526 5 92
090526 6 92
090526 7 84
090526 8 92
090526 9 92
090526 10 92
090526 11 92
090526 12 92
090526 13 92
090526 14 92
090526 15 92
090526 16 92
090526 17 92
090526 18 83
090526 19 92
090526 20 92
090526 21 92
090526 22 92
090526 23 92
090527 0 92
090527 1 92
090527 2 92
090527 3 92
090527 4 92
090527 5 92
090527 6 92
090527 7 84
090527 8 92
090527 9 92
090527 10 92
090527 11 92
090527 12 92
090527 13 92
090527 14 92
090527 15 92
090527 16 92
090527 17 92
090527 18 92
090527 19 84
090527 20 92
090527 21 92
090527 22 92
090527 23 92
090528 0 92
090528 1 92
090528 2 92
090528 3 92
090528 4 86
090528 5 92
090528 6 92
090528 7 92
090528 8 92
090528 9 92
090528 10 92
090528 11 92
090528 12 92
090528 13 92
090528 14 92
090528 15 92
090528 16 83
090528 17 92
090528 18 92
090528 19 92
090528 20 92
090528 21 92
090528 22 92
090528 23 92
090529 0 92
090529 1 92
090529 2 92
090529 3 92
090529 4 83
090529 5 92
090529 6 92
090529 7 92
090529 8 92
090529 9 92
090529 10 92
090529 11 92
090529 12 92
090529 13 92
090529 14 92
090529 15 92
090529 16 92
090529 17 83
090529 18 92
090529 19 92
090529 20 92
090529 21 92
090529 22 92
090529 23 92
090530 0 92
090530 1 92
090530 2 92
090530 3 92
090530 4 92
090530 5 83
090530 6 92
090530 7 92
090530 8 92
090530 9 92
090530 10 92
090530 11 92
090530 12 92
090530 13 92
090530 14 92
090530 15 92
090530 16 92
090530 17 83
090530 18 92
090530 19 92
090530 20 92
090530 21 92
090530 22 92
090530 23 92
090531 0 92
090531 1 92
090531 2 92
090531 3 92
090531 4 92
090531 5 83
090531 6 92
090531 7 92
090531 8 92
090531 9 92
090531 10 92
090531 11 92
090531 12 92
090531 13 92
090531 14 92
090531 15 92
090531 16 92
090531 17 84
090531 18 92
090531 19 92
090531 20 92
090531 21 92
090531 22 92
090531 23 92
090601 0 92
090601 1 92
090601 2 92
090601 3 92
090601 4 92
090601 5 83
090601 6 92
090601 7 92
090601 8 92
090601 9 92
090601 10 92
090601 11 92
090601 12 92
090601 13 92
090601 14 92
090601 15 92
090601 16 92
090601 17 84
090601 18 92
090601 19 92
090601 20 92
090601 21 92
090601 22 92
090601 23 92
090602 0 92
090602 1 92
090602 2 92
090602 3 92
090602 4 92
090602 5 83
090602 6 92
090602 7 92
090602 8 92
090602 9 92
090602 10 92
090602 11 85
090602 12 92
090602 13 92
090602 14 92
090602 15 92
090602 16 92
090602 17 92
090602 18 92
090602 19 83
090602 20 92
090602 21 92
090602 22 92
090602 23 92
090603 0 92
090603 1 92
090603 2 92
090603 3 92
090603 4 92
090603 5 92
090603 6 92
090603 7 92
090603 8 83
090603 9 92
090603 10 92
090603 11 92
090603 12 92
090603 13 92
090603 14 92
090603 15 85
090603 16 92
090603 17 83
090603 18 92
090603 19 92
090603 20 92
090603 21 92
090603 22 92
090603 23 92
090604 0 92
090604 1 92
090604 2 92
090604 3 92
090604 4 92
090604 5 92
090604 6 83
090604 7 92
090604 8 92
090604 9 92
090604 10 92
090604 11 92
090604 12 92
090604 13 92
090604 14 92
090604 15 92
090604 16 92
090604 17 92
090604 18 83
090604 19 92
090604 20 92
090604 21 92
090604 22 92
090604 23 92
090605 0 92
090605 1 92
090605 2 92
090605 3 92
090605 4 92
090605 5 92
090605 6 83
090605 7 92
090605 8 92
090605 9 92
090605 10 92
090605 11 92
090605 12 92
090605 13 92
090605 14 92
090605 15 92
090605 16 92
090605 17 92
090605 18 83
090605 19 92
090605 20 92
090605 21 92
090605 22 92
090605 23 92
090606 0 92
090606 1 92
090606 2 92
090606 3 92
090606 4 92
090606 5 92
090606 6 84
090606 7 92
090606 8 92
090606 9 92
090606 10 92
090606 11 92
090606 12 92
090606 13 92
090606 14 92
090606 15 92
090606 16 92
090606 17 92
090606 18 83
090606 19 92
090606 20 92
090606 21 92
090606 22 92
090606 23 92
090607 0 92
090607 1 92
090607 2 92
090607 3 92
090607 4 92
090607 5 92
090607 6 83
090607 7 92
090607 8 92
090607 9 92
090607 10 92
090607 11 92
090607 12 92
090607 13 92
090607 14 92
090607 15 92
090607 16 92
090607 17 92
090607 18 83
090607 19 92
090607 20 92
090607 21 92
090607 22 92
090607 23 92
090608 0 92
090608 1 92
090608 2 92
090608 3 92
090608 4 92
090608 5 92
090608 6 83
090608 7 92
090608 8 92
090608 9 92
090608 10 92
090608 11 92
090608 12 92
090608 13 92
090608 14 92
090608 15 92
090608 16 92
090608 17 92
090608 18 84
090608 19 92
090608 20 92
090608 21 92
090608 22 92
090608 23 92
090609 0 92
090609 1 92
090609 2 92
090609 3 92
090609 4 92
090609 5 92
090609 6 92
090609 7 83
090609 8 92
090609 9 92
090609 10 92
090609 11 92
090609 12 92
090609 13 92
090609 14 92
090609 15 92
090609 16 92
090609 17 92
090609 18 83
090609 19 92
090609 20 92
090609 21 92
090609 22 92
090609 23 92
090610 0 92
090610 1 92
090610 2 92
090610 3 92
090610 4 92
090610 5 92
090610 6 92
090610 7 83
090610 8 92
090610 9 92
090610 10 92
090610 11 92
090610 12 92
090610 13 92
090610 14 92
090610 15 92
090610 16 92
090610 17 92
090610 18 92
090610 19 83
090610 20 92
090610 21 92
090610 22 92
090610 23 92
090611 0 92
090611 1 92
090611 2 92
090611 3 92
090611 4 92
090611 5 92
090611 6 92
090611 7 83
090611 8 92
090611 9 92
090611 10 92
090611 11 92
090611 12 92
090611 13 92
090611 14 92
090611 15 92
090611 16 92
090611 17 92
090611 18 92
090611 19 83
090611 20 92
090611 21 92
090611 22 92
090611 23 92
090612 0 92
090612 1 92
090612 2 92
090612 3 92
090612 4 92
090612 5 92
090612 6 92
090612 7 83
090612 8 92
090612 9 92
090612 10 92
090612 11 92
090612 12 92

426 record(s) selected.

root@<hostname>:/opt/IBM/ITM/tip/products/tcr/data/database/design/Customised_Reports $ date
Fri Jun 12 15:25:23 BST 2009

root@<hostname>:/opt/IBM/ITM/tip/products/tcr/data/database/design/Customised_Reports $ uptime
03:25PM up 8 days, 23:52, 3 users, load average: 1.05, 1.16, 1.17
Updated on 2012-12-11T15:52:09Z at 2012-12-11T15:52:09Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    373 Posts

    Re: Can you please explain how the availability reports for ITM work?

    ‏2012-12-11T15:52:09Z  
    Hi,
    Did you get any idea about this issue? While I am trying to reach some knowledge about backstage of this type of ITM OS agent reports I saw your thread.

    If you've got any idea Can you please advice me.
    any info. will be appreciated.

    Thanks.