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.
Subscribe and follow us for all the latest information directly on your social feeds:
|
|
|
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 |
UID
ibm11084899