db query table blocking issue on MSSQL Server with TS 6.6

keithbarnes

Hello

Not overly familiar with xCP so coming in as a DBA.

Performance issues being hunted down.

Ran a trace for 8 hours and got 298 blocks between 2 and 5 seconds. Most blocks were part of blocking chains.

Blocks affected the following:

update dm_workflow_s set i_vstamp = i_vstamp where r_object_id = @P1

1. What is the point of this statement?

2. This is a Documentum 6.6 xCP system running on Windows 2008R2. Are there any known issues or advice in regards to entire table blocking and in the context mentioned.

Many thanks

Keith

Find more posts tagged with

Documentum

Comments

lastnitescurry

The i_vstamp attribute is used to track modifications.

For example, if two users have write permit on a document then both could edit at the same time. This is allowed. The I_vstamp attribute is checked on save. In Webtop properties page the second user to save would be given a warning

PanfilovAB

Blocks affected the following:

update dm_workflow_s set i_vstamp = i_vstamp where r_object_id = @P1

1. What is the point of this statement?

To lock specific workflow object

Khaled_Farouk

Hi Keithbarnes
Have you managed to solve that problem?

Thank you for your help.