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.

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