VMware Cloud Community
admm
Contributor
Contributor

vCenter Appliance SLES 11 SP1 - No performance charts, real time only

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

Tags (1)
Reply
0 Kudos
0 Replies