obdqueryapp is not running for Operation Console

[prasson_ibm]

Hi,
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>

Then i tried to connect to DSODB database,but i got below error :-

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

Can someone help me to debug this issue.

[SURA]

Did you checked this link?

http://www-01.ibm.com/support/docview.w ... wg1IY86277

[prasson_ibm]

Hi Sura,
I am getting only one db direcotryand i dont know why DSODB database is not showing...

Code: Select all

db2 => list db directory

 System Database Directory

 Number of entries in the directory = 1

Database 1 entry:

 Database alias                       = XMETA
 Database name                        = XMETA
 Local database directory             = /opt/IBM/InformationServer/Repos/xmeta
 Database release level               = d.00
 Comment                              =
 Directory entry type                 = Indirect
 Catalog database partition number    = 0
 Alternate server hostname            =
 Alternate server port number         =

[xinhuang66]

You can re-create DSODB schema and point to it.

All scripts are under dsodb folder.

[ray.wurlod]

Have you created the connection to DSODB ?

For example, can you import its table definition using the Connector Import Wizard (ODBC)?

[prasson_ibm]

Hi Ray,

I have not made connection to DSODB which is DB2 default database.Can you please help me to create the connection and use connector import wizard.

[prasson_ibm]

You can re-create DSODB schema and point to it.

Hi Thr,

First i want to investigate that what happened to DSODB database because it was create before and working fine.

[ray.wurlod]

OK we will await the result of your investigations.

Don't forget to check for expired password.

[prasson_ibm]

Hi Ray,

Should i look for db2inst1 password expire? If password would have expired,then xmeta database also should not have worked but it is working fine.

[prasson_ibm]

Hi Ray,
After investigation i found that xmetasr user is missing (/home/xmetasr) from the server.When i tried to login to server using xmetasr user i got below error:-

Could not chdir to home directory /home/xmetasr: A file or directory in the path name does not exist.
xmetasr@ait-etl01dev:/ $

Then i discussed with Unix admin guys and asked them to copy /home/xmetasr user from backup.

Later i stopped and start DSAppWatcher.sh script and all srevices braught up.

Thank you all for your help.