Question

1
Replies
135
Views
gcv01 Member since 2017 1 post
PEGA
Posted: December 25, 2019
Last activity: December 25, 2019

Is there any known issue with PEGADATA.PR_SYS_LOCKS table queries ?

H,

I could see there are DB alerts on PR SYS LOCKS table and since this is an OOTB table any know issues or hotfix available.

I know that Lock management is controlled through the database table PR_SYS_LOCKS and because of the high volume of entries inserted into and deleted from this table during case processing, the data in the PR_SYS_LOCKS table.

Slow SQL on table PEGADATA.PR_SYS_LOCKS

INSERT INTO pegadata.pr_sys_locks (pxCreateDateTime, pxCreateOpName, pxCreateOperator, pxCreateSystemID, pxExpireDateTime, pxLockHandle, pxObjClass, pxOwnerId, pxSystemName, pxSystemNode, pxUpdateDateTime, pxUpdateOpName, pxUpdateOperator, pxUpdateSystemID, pxUserHost, pyLabel, pzInsKey) VALUES (?, ?, ?, ?, ?, ?, 'literal', ?, ?, ?, ?, ?, ?, ?, ?, 'literal', ?)

DELETE FROM pegadata.pr_sys_locks WHERE pxOwnerId = ?

Regards

Data Integration
Share this page LinkedIn