IBM Support

ITM Agent Insights: Configuring federation for the Capacity Planner for VMware FAILS

Technical Blog Post


Abstract

ITM Agent Insights: Configuring federation for the Capacity Planner for VMware FAILS

Body

This blog explains the steps to resolve the federation failure when you have a special character in your Tivoli Data Warehouse password. While configuring homogeneous federation for the Capacity Planner for VMware, you get the following error while executing the fed_admin.sh script. (federating TADFDCDB and WAREHOUS databases.)

TADFDCDB => Capacity planner database

WAREHOUS => Tivoli data warehouse

 

SQL0104N  An unexpected token "!" was found following "<identifier>".
Expected tokens may include:  "NEW".  SQLSTATE=42601

 

The link from the user guide which describes the configuration are as follows: http://www.ibm.com/support/knowledgecenter/SS9U76_7.2.0.2/com.ibm.tivoli.itmvs.doc_7.2.0.2/dashboards_reports/vmware_virtds_federationc.html

The execution of Step 5. and 6. fails when the password for WAREHOUS contains a special character e.g.: "!". The special characters cannot be handled by the fed_admin.sh script at this time. I have opened a Documentation APAR which references the following BLOG as a solution. The solution ONLY applies to WAREHOUS password with special character. For all other cases, the steps mentioned in the user guide should work.

 

To resolve the issue specify the password as follows in the fed_config.cfg

**********************************************************************************************
# instance owner of remote TDW database.
TDW_REMOTE_DB_INSTANCE_OWNER=db2inst1
# Password of instance owner of remote TDW database.
TDW_REMOTE_DB_INSTANCE_OWNER_PASSWORD=Pass!23

# instance owner name of capacity planner database.
CP_DB_INSTANCE_OWNER=db2inst1
# Password of instance owner name of capacity planner database.
CP_DB_INSTANCE_OWNER_PASSWORD='Pass!23'
********************************************************************************************

NOTE: There are NO quotes while specifying TDW_REMOTE_DB_INSTANCE_OWNER_PASSWORD.

 

Also, the following command fails outside the script with the error highlighted:
/home/db2inst1/AnalyticsDatabaseInstaller_powerVM/federation_power/./tadfdc_setup_fed.sh -CONFIGSERVER CREATE_SERVER CONNECTION:TADFDCDB/db2inst1/'Pass!23' WHSERVERP DB2/CS 9.7 db2inst1 Pass!23 DRDA//WHDB

SQL0104N An unexpected token "!" was found following "<identifier>".

 

In order to ensure the federation completed successfully you can check for the existence of views and data in respective views by connecting to ‘TADFDCDB’ database.

TADFDC.MES_VM_CPU_W (_W stands for weekly, similarly the other summarization view names would be suffixed with _D, _H, _Y as per summarization at ITM end)
TADFDC.MES_VM_DATA_STORE_W
TADFDC.MES_VM_NETWORK_W
TADFDC.MES_VM_MEM_W

 

This should also confirm the configuration for federation completed successfully.

 

 

 

Tutorials Point

 

Subscribe and follow us for all the latest information directly on your social feeds:

 

 

image

 

image

 

image

 

 

  

Check out all our other posts and updates:

Academy Blogs:https://goo.gl/U7cYYY
Academy Videos:https://goo.gl/FE7F59
Academy Google+:https://goo.gl/Kj2mvZ
Academy Twitter :https://goo.gl/GsVecH


image

[{"Business Unit":{"code":"BU004","label":"Hybrid Cloud"},"Product":{"code":"","label":""},"Component":"","Platform":[{"code":"","label":""}],"Version":"","Edition":""}]

UID

ibm11084899