Question
3
Replies
42
Views

Capgemini Technological Services
IN
Posted: July 8, 2022
Last activity: 2 days 22 hours ago
Last activity: 12 Aug 2022 12:21 EDT
Slow SQL on table PEGADATA.PR_DATA_OP_SESSION.
I am getting this error in PDC constantly.
SQL Analysis
SQL Statement
UPDATE pegadata.pr_data_op_session "PC0" SET "pxstate" = ?, "pxupdatedatetime" = ?, "pxnodeid" = ? WHERE (pzRequestorId = ? AND pxState <> ? AND "PC0"."pxclusterid" = ?)
REFERENCED COLUMNS IN WHERE CLAUSE
PR_DATA_OP_SESSION.PXCLUSTERID, PR_DATA_OP_SESSION.PXSTATE, PR_DATA_OP_SESSION.PZREQUESTORID
REFERENCED TABLES
PEGADATA.PR_DATA_OP_SESSION
Does anyone have idea how to resolve this issue.