IPv6 architecture an IP address length of 64 bytes. As the size of sysprocesses could not be increased, Adaptive Server needed a way to retrieve the full IP address. Adaptive Server version 12.5.4 introduces a new function to return information from the pss:
pssinfo(<spid | 0>, '<pss field>')
where:
spid – Process ID. When you enter 0, the current process is used.
pss field – valid values are:
ipaddr – Client IP Address
extusername – When using external authentication like (PAM, LDAP), it returns the external PAM or LDAP user name used.
dn – Distinguished Name when using LDAP authentication.
The pssinfo function also includes the option to display the external user name and the distinguish name.