NO OF PE's in SYSTEM

Database
Enthusiast

NO OF PE's in SYSTEM

Hi All,

how to find out no of PE's(parsing engines) in td sys? do we have any Sql othr than monitoring tools?

2 REPLIES
Senior Apprentice

Re: NO OF PE's in SYSTEM

Some of the ResUsage tables got that info, e.g.

SELECT NodeId, VProc1 AS "AMPs", VProc2 AS "PEs" FROM dbc.ResUsageSpma 
WHERE TheDate = DATE
QUALIFY
RANK() OVER (PARTITION BY NodeId ORDER BY TheTime) = 1

If you don't have acccess to ResUsage, IFPNo in dbc.LogonOff is the PE number:

SELECT MAX(ifpno) - MIN(ifpno) + 1 FROM dbc.LogonOffV 
WHERE LogDate = DATE

or less accurate when there are just a few sessions logged in
SELECT MAX(ifpno) - MIN(ifpno) + 1 FROM dbc.SessionInfoV

And ProcID in dbc.QryLogV is also the PE number...

Dieter

Dieter

Enthusiast

Re: NO OF PE's in SYSTEM

thank you Dieter....