Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

how to debug QM database access problems.. help

 We have our applications deployed on different servers

JTS
CCM
RM
QM

and this is mirrored in DR.

this is using a common Oracle provided database service. both Prod and DR  access the same DB. 

or DBAs created ADMIN level userids for database setup (during CLM install)
and USER level userids for daily operation. 

to go to full production, access to the ADMIN level userids is removed.  
but it appears the database schema was labeled with the ADMIN user userid.

we are using Websphere for the data sources. 

we cannot rename the schema (as far as I know)
and for some reason cannot access the ADMIN schema from the USER context..(altho the DBA's tell us we should be able to)

we would like to take a DB access error log to our DBAs to fix this problem, but can't seem to find a way to get that level of detail from the clm apps.. (we are using QM to debug, cause we don't yet have any users)..

any guidance welcomed..

0 votes


Accepted answer

Permanent link
If I understand correctly what you said, I believe a mistake has been made with regard to the database configuration.

You cannot use two user accounts in the way that you describe - one to create the tables and the other to access the tables' content, because the user and the schema can be considered as the same thing in Oracle. It can be made possible if we can specify the schema name for all the SQL statements - say, with user "clmadmin" creating all the tables, we specify the schema name "clmadmin" for all SQL statements when logging on as user "clmuser", so we will look for "clmadmin.table" instead of "clmuser.table". BUT, I don't think we have this option in CLM.

To fix the problem, you just ignore the "USER level userids", and remove the DBA privileges from the "ADMIN level userids" to make them "USER level". In other words, you need to use the same set of user account all the way through.

More details can be found in this document.
https://jazz.net/wiki/bin/view/Main/MoreControlOverTheOracleDataWarehouseSetup
sam detweiler selected this answer as the correct answer

0 votes

Comments

thank you. we will see. the standards here are pretty strict, user level userids are not allowed to create tables, etc.. and using admin level userids on  a production platform for a runtime is not allowed. whether they will allow the admin rights to be removed and retain the admin user name is questionable

I think you can show the document to your DBA and see what can be done. If an application is custom-built with this restriction in mind, it should not have any problems with specifying where to get the tables. But CLM is just not such an application.


One other answer

Permanent link
 Thank you again for the detailed info.

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Jan 17 '14, 10:40 a.m.

Question was seen: 6,489 times

Last updated: Jan 19 '14, 9:33 p.m.

Confirmation Cancel Confirm