Re: Any table function or view out there for listing subsystem descriptions?

just add b.memory_pool to the initial select

SELECT DISTINCT CAST(A.Objlongschema AS CHAR(10)) AS "Library"
,A.Objname AS "Subsystem"
,CASE
WHEN B.Subsystem IS Null THEN 'Inactive'
ELSE 'Active'
END AS "Status"
, b.memory_pool
FROM TABLE (
Qsys2.Object_Statistics('*ALL', 'SBSD')
) A
LEFT OUTER JOIN TABLE (
Qsys2.Active_Job_Info()
) B
ON A.Objname = B.Subsystem
AND A.Objlongschema = B.Subsystem_Library_Name
ORDER BY 4 ;

not necessarily all the configured pools for the sbsd, but the "main" pool for the sbs is there

Bryan


Rob Berendt wrote on 2/10/2020 2:25 PM:

Those do not drill down and tell me what pools they use. But thank you for looking though.

Rob Berendt