nathalielim
Programmer
Hi,
Problem:
Currently my livelink database in my project environment seems to have a high number of locks, 2134994 when i use execute the master.sys.dm_tran_locks sql statement in my db.
When run the top 20 high cpu utilization statement, one of them is related to Livelink:
select OwnerID,ParentID,DataID,Name,OriginOwnerID,OriginDataID,UserID,GroupID,UPermissions,GPermissions,WPermissions,SPermissions,ACLCount,PermID,DataType,Reserved,SubType,CreatedBy,CreateDate,ModifyDate,MaxVers,ReservedBy,ReservedDate,VersionNum,DComment,DCategory,ExAtt1,ExAtt2,Ordering,Major,Minor,ReleaseRef,ChildCount,AssignedTo,DateAssigned,DateEffective,DateDue,DateExpiration,DateStarted,DateCompleted,Status,Priority,GIF,ExtendedData,Catalog,CacheExpiration from DTree where DataID=@P1
TOT_DURATION_MS|total_physical_reads|total_logical_writes|total_logical_reads
1428082|89073|0|53134777
Question:
1) how can i reduce the locks/ release the locks hold by livelink ? I am worried the database will run out of locks for other databases.
2) what could have causes this huge locking without releasing ?
3) I am using LAPI to import files to Livelink using java. Do i need to use transactions in my code? the sample Lapi codes do not have though?
Thanks.
Problem:
Currently my livelink database in my project environment seems to have a high number of locks, 2134994 when i use execute the master.sys.dm_tran_locks sql statement in my db.
When run the top 20 high cpu utilization statement, one of them is related to Livelink:
select OwnerID,ParentID,DataID,Name,OriginOwnerID,OriginDataID,UserID,GroupID,UPermissions,GPermissions,WPermissions,SPermissions,ACLCount,PermID,DataType,Reserved,SubType,CreatedBy,CreateDate,ModifyDate,MaxVers,ReservedBy,ReservedDate,VersionNum,DComment,DCategory,ExAtt1,ExAtt2,Ordering,Major,Minor,ReleaseRef,ChildCount,AssignedTo,DateAssigned,DateEffective,DateDue,DateExpiration,DateStarted,DateCompleted,Status,Priority,GIF,ExtendedData,Catalog,CacheExpiration from DTree where DataID=@P1
TOT_DURATION_MS|total_physical_reads|total_logical_writes|total_logical_reads
1428082|89073|0|53134777
Question:
1) how can i reduce the locks/ release the locks hold by livelink ? I am worried the database will run out of locks for other databases.
2) what could have causes this huge locking without releasing ?
3) I am using LAPI to import files to Livelink using java. Do i need to use transactions in my code? the sample Lapi codes do not have though?
Thanks.