obdqueryapp is not running on my dev etl server.Actually OS upgrade was requirend so infra team has restarted the services.After restart datastage Engine is working fine but operation console is having issue of obdqueryapp not running.
Then i tried to debug by looking at the log file at /opt/IBM/InformationServer/Server/DSODB/logs/ODBQueryApp.err and found DSODB database is not getting connected.
Code: Select all
<string>Unable to connect to the DSODB database.</string>
db2 => connect to DSODB user xmetasr using *****
Code: Select all
SQL1013N The database alias name or database name "DSODB" could not be found.
SQLSTATE=42705