Question
Proximus
BE
Last activity: 8 Sep 2023 4:17 EDT
System > Settings > System Name & Affected node: where is this stored
Hello,
I'm in PEGA 8.6.+
In Configure > System > Settings > System Name page, we can see at the bottom "All Affected Nodes"
After several years, I've got a long list of old "Affected nodes" in Prod and I don't find where this information is stored.
It's neither in pr_sys_statusnodes nor locally stored.
Any idea where this list/information is stored?
When I add new nodes, it's well updated, but old ones are never removed by the system.
Thank you
Regards
Anthony
Accepted Solution
Updated: 8 Sep 2023 4:17 EDT
Ford Motor Company
US
pr_sys_statusnodes represents the current state or health of the jvms. But System Node's are the instances of Data-Admin-Nodes
Class Data-Admin-Nodes is mapped to table dbo.pr_data_admin in PegaDATA.
Pega usually updates/deletes/adds the pr_sys_statusnodes table but not pr_data_admin table with pxObjClass= Data-Admin-Nodes
Proximus
BE
Arf, forgot this table :)
select t.pynodename, t.pysystemname, t.pylabel, t.pxcreatedatetime from pr_data_admin t where t.pxobjclass = 'Data-Admin-Nodes'
Do you see any side effect of cleaning old nodes ?
Thank you
Regards
Anthony
Ford Motor Company
US
Do you see any side effect of cleaning old nodes ? --> No. I would actually recommend to perform House keeping on a regular basis.
Proximus
BE
Thanks.
House keeping is done, only this old non problematic part was still there :)