Question
Capgemini Technological Services
IN
Last activity: 16 Aug 2022 7:11 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.
***Edited by Moderator Marije to add Capability tags***
JPMorgan Chase
IN
Quick questions here.
What is your total operator base
which region are you seeing this error happening (DEV/QA/UAT/PROD) ?
At a given point in time how many operators will be active?
ING Bank NV
NL
@Abhishek_Pega Hi Abhishek,
we too seeing the same error,
did you got any fix for this , could you please help.
Thanks in Advance,
Tejas
Mphasis
US
@Abhishek_Pega I hope you have large amount of data in this table. Please create indexes on where clause columns used in above query. Problem will be solved automatically.
JPMorgan Chase
IN
@Abhishek_Pega It's just about data. this table frequently needs to be defragmented in regular maintenance window and an index added to this table would perform better.