Data Integration

Hello,

Some time ago I was asked to install a new DataStage engine in a cloud VM to an existing Information Server installation on premises. A few months ago the new engine was deemed not needed anymore and the cloud ops team deleted the VM without telling me, so I couldn't run the IIS uninstall program on the VM. Since then the Information Server service tier logs shows the following message every 5 minutes:

Could you help me with a way to disconnect / remove an engine that doesn't exist anymore from the service layer?

Best regards,

Hello Martin,
It is possible that this technote can help you. Or perhaps there is a clue in the article?
Unable to reinstall the Information Server DataStage engine tier after removing a previous installation

https://www.ibm.com/support/pages/unable-reinstall-information-server-datastage-engine-tier-after-removing-previous-installation

Thanks Emily, I'll look into it.

Hi again,
That article posted earlier might be helpful (or not). Found a case in our archive from 2021 that has the following as the resolution.  Details may differ depending on if your WAS is Network Deployment (ND) or Liberty.

- Go to /opt/IBM/(where InformationServer and WebSphere directories reside) and search for database.properties file.
- Make sure all the database.properties found have the correct details(especially serviceName). If not, correct them.
 
- Check /opt/IBM/InformationServer/ASBServer/conf/imam_staging_repository.properties  file for correct details(especially serviceName). If not, correct them.
 
- Run below command to correct com.ibm.iis.xmeta.repo.conn.POJO_STAGING property
 1. ./xmetaAdmin.sh setProperty -file ../conf/imam_staging_repository.properties -dbfile ../conf/database.properties com.ibm.iis.xmeta.repo.conn.POJO_STAGING

 
- Run below command to confirm that com.ibm.iis.xmeta.repo.conn.POJO_STAGING property has got updated properly
 1. ./xmetaAdmin.sh getProperty -dbfile ../conf/database.properties com.ibm.iis.xmeta.repo.conn.POJO_STAGING

 
- Update resources.xml file of Websphere Application Server to have correct serviceName in it. This file usually resides at below location.
/opt/IBM/WebSphere/AppServer/profiles/InfoSphere/config/cells/<CELLNAME>/nodes/<NODENAME>/servers/server1/resources.xml
 
Make sure to take the backup of resources.xml file before editing.
Search  for "serviceName" in it and make sure it has correct value. If not, correct it. Do it for all the occurrences of serviceName in resources.xml.