DSXchange

where to run the queries that are present in below article?

http://www.ibm.com/developerworks/data/ ... index.html

Is Operations Console configured in your shop?
Queries from the developerworks article linked in your post run against DSODB (DataStage and QualityStage Operations Database).

Also note that some of these queries need to be tuned/corrected. Schema diagrams in the article (mentioned above) showing relationship between tables will help in tuning/correcting them.

Thanks for reply. We are using operation console. Where can I run queries in operation console?

These queries do not run in "Operations Console" (which can be thought of a frontend/dashboard), but in the DSODB database.

Your DataStage Administrator will be able to provide information about the database where DSODB is installed.

I think newer versions store the data in XMETA instead of a separate DSODB.

So... use your query tool of choice for this, i.e. Toad as one popular example.

qt_ky wrote:I think newer versions store the data in XMETA instead of a separate DSODB.

It's always been possible to install DSODB as a separate schema within the XMETA database. Or you can install it in any other ODBC-accessible database.

My Datastage admin is not willing to give the information.I have access to Datastage administrator for my project and where can i check DSODB database details?

If you have an id on the DataStage server with necessary permissions, then following command will give you location of database hosting DSODB: However in order to run the queries, you would also need credentials with necessary permissions on the database.