In DBC.sessioninfo table what is the IFPno represents?

Database

In DBC.sessioninfo table what is the IFPno represents?

Hi ,

I am new to Teradata DBA concepts and started working on few of the basic things. I came accross the below query
SELECT UserName, IFPNo FROM DBC.SessionInfo
WHERE Partition = 'MONITOR';

I am curioius to know what is this IFPNo?

Thanks in advance.

1 REPLY
N/A

Re: In DBC.sessioninfo table what is the IFPno represents?

IFPNo field is the PE Vproc number of the PE to which the session was assigned.

For any column definition , you can try doing:
HELP OBJECT - such as :

HELP VIEW DBC.SESSIONINFO;

which in turn provide additional information pertaining to the the object.
Hope, it'll help.