System > Settings > System Name & Affected node: where is this stored

General
,
1

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

2

@Anthony_Gourtay

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

3

@SUMAN_GUMUDAVELLY

Arf, forgot this table :slight_smile:

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

4

@Anthony_Gourtay

Do you see any side effect of cleaning old nodes ? → No. I would actually recommend to perform House keeping on a regular basis.

5

@SUMAN_GUMUDAVELLY

Thanks.

House keeping is done, only this old non problematic part was still there :slight_smile: