Jazz Register Log in
Jazz Forum Welcome to the Jazz Community Forum

Welcome to the Jazz Community Forum

Connect and collaborate with IBM Engineering experts and users

What is triggering execution of specific SQL statement against RTC backen db?

Hi,

I see the following SQL statement being executed several times a day on the RTC backend db.  What is the action that triggers this SQL statement to run?  Is it a user accessing specific source code in their RTC Project?

SELECT SEQUENCE_COL, STORED_SIZE, EXPANDED_SIZE, STORAGE_METHOD, DELTA_PREDECESSOR, CONTENT_BYTES FROM SCM.CONTENT WHERE HASH_CODE = ? ORDER BY SEQUENCE_COL ASC

-1 votes



One answer

Permanent link
This is the query used by the server to fetch content from the db.

User actions that retrieve file contents from the server would hit this:  loading workspaces, accepting changesets into a loaded workspace, doing compares, etc.

I don't think a user accessing specific source code in their RTC project would necessarily trigger this since the user should have the content locally in their sandbox. 

1 vote

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
× 12,046

Question asked: Jun 04 '12, 3:19 a.m.

Question was seen: 4,993 times

Last updated: Jun 05 '12, 11:25 a.m.

Confirmation Cancel Confirm