Hi,
We're using ESXi 5 HA cluster made of 3 hosts. It's managed by Vcenter Appliance based on SLES 11.
Recently I've seen that performance charts disappeared showing "no data available" message. Looking for reasons I discovered a few KB articles but all of them regard older Vcenters and don't know if somebody experienced similar problems with newer ones.
To summarize :
Our Vcenter utilizes embedded DB2 database and it hasn't been upgraded.
(KB: 1030819)
Tables VPX_HIST_STAT1, VPX_HIST_STAT2, VPX_HIST_STAT3 contain data.
Tables VPX_SAMPLE_TIME(1,2,3) are empty.
(KB: 2011523)
Stored procedures process_temptable(0,1,2)_proc exist.
(KB: 1020903)
Stored procedure load_stats_proc doesn't exist (but is it needed in this version?)
(KB: 1030819)
Schema for VPX_HIST_STAT(1,2,3) tables - should type be changed to BIGINT ?
Column Information
Number of columns: 3
SQL type Type length Column name Name length
-------------------- ----------- ------------------------------ -----------
484 DECIMAL 31, 0 COUNTER_ID 10
484 DECIMAL 31, 0 TIME_ID 7
484 DECIMAL 31, 0 STAT_VAL 8
Every 30sec. in the vpxd.log following error message appears : "Failed to get a table to insert raw stats. Perf data will be lost".
Definitely something isn't going well but I don't know what and how to safely set db to let the performance data be collected again. Any ideas ?
Regards,
admm