DSODB queries

vamsi_4a6 · Post by **vamsi_4a6** » Wed Feb 03, 2016 9:22 am

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

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

rkashyap · Post by **rkashyap** » Wed Feb 03, 2016 10:34 am

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.

vamsi_4a6 · Post by **vamsi_4a6** » Thu Feb 04, 2016 1:40 am

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

rkashyap · Post by **rkashyap** » Thu Feb 04, 2016 8:03 am

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.

qt_ky · Post by **qt_ky** » Thu Feb 04, 2016 8:28 am

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

chulett · Post by **chulett** » Thu Feb 04, 2016 8:50 am

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

ray.wurlod · Post by **ray.wurlod** » Thu Feb 04, 2016 3:49 pm

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.

vamsi_4a6 · Post by **vamsi_4a6** » Fri Feb 05, 2016 2:37 am

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?

rkashyap · Post by **rkashyap** » Fri Feb 05, 2016 5:29 pm

If you have an id on the DataStage server with necessary permissions, then following command will give you location of database hosting DSODB:

Code: Select all

/opt/IBM/InformationServer/ASBServer/bin/RepositoryAdmin.sh -displayRepository -rn DSODB

However in order to run the queries, you would also need credentials with necessary permissions on the database.