Knowledge Base

The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
 
Search the VMware Knowledge Base (KB)   View by Article ID
 

DB2 database issues after installing vCenter Server on DE locale (1021971)

Details

On a vCenter Server installed on DE locale with a DB2 database, adding a host with powered-on virtual machines to a cluster might result in the following issues:

  • DB2 reports runtime issues when vCenter Server tries to invoke the load_stats_proc store procedure.

    Errors similar to the following might be written to the vpxd log:

    [2010-04-08 05:35:08.249 01452 error 'App'] [Vdb::IsRecoverableErrorCode] Unable to recover from 22003:-413
    [2010-04-08 05:35:08.249 01452 error 'App'] [VdbStatement] SQL execution failed: call load_stats_proc(?, ?, ?, ?, ?, ?)
    [2010-04-08 05:35:08.249 01452 error 'App'] [VdbStatement] Execution elapsed time: 7156 ms
    [2010-04-08 05:35:08.249 01452 error 'App'] [VdbStatement] Diagnostic data from driver is 22003:1:-413:[IBM][CLI Driver][DB2/NT] SQL0413N Datenüberlauf während der Umsetzung numerischer Datentypen. SQLSTATE=22003
  • The item VM operations might not be listed in the advanced chart options for the cluster node.

Solution

To workaround the issue, replace the store procedure by running the following SQL statements against the vCenter Server database as follows:

// drop the existing store procedure
drop procedure load_stats_proc;

// run the revised logic in the file load_stats_proc_db2.sql to re-create the procedure.
load_stats_proc_db2.sql

For more details, see the attached file "load_stats_proc_db2.sql".

Keywords

DE with DB2;load_stats_proc store procedure

Attachments

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.

Feedback

  • 1 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.
What can we do to improve this information? (4000 or fewer characters)
  • 1 Ratings
Actions
KB: