You can configure a DB2 database for vCenter Server locally on the same Microsoft Windows machine as vCenter Server.

Before you configure the database to work locally, perform the following tasks:

Configure a user and group for the database.

Add the database instance registry variables.

Add the client instance registry variable.

Create the database with the required buffer pools, table spaces, and privileges.

On the vCenter Server machine, catalog the server node and the database.


To catalog the server node to TCP/IP, run the following command in the command window:

db2 catalog tcpip node <New_Node_Name> remote <IP_Address_of_vCenter_Server_Machine> server <Port_Number_Used>


To catalog the database to the newly created TCP/IP node, run the following command in the command window:

db2 catalog db <DBNAME> as <DBALIAS> at node <NEW_NODE_NAME> authentication SERVER

Here<DBALIAS> is not the same as <DBNAME>. For example, db2 catalog db VCDB as VCDB1 at node DB2NODE authentication SERVER


Ensure that the database directory entry type is Remote, and not Indirect.

You can verify this by running the following command in the command window:

db2 list db directory

If the database directory entry type is Indirect, repeat the previous step.


On the Microsoft Windows machine that will host vCenter Server, open the Microsoft ODBC Administrator utility by clicking Start > Run and entering odbcad32.exe.


On the System DSN tab, click Add.


Select the driver that corresponds to your database (for example, IBM DB2 ODBC Driver - VCDB2Add) and click Finish.


Enter a name for the DSN (for example, VCDB2) and select your database from the menu.


To make sure that the database connection works, select the DSN and click Configure.


Enter the database user name (for example, vcx) and password, and click Connect.

You do not need to save the user name and password.

The DB2 database is configured.

You can now install vCenter Server. When the vCenter Server installer prompts you for a DSN, point to the DSN that you created in this procedure.