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

modifying the distinct portion

SELECT DISTINCT CAST(A.Objlongschema AS CHAR(10)) AS "Library"
,A.Objname AS "Subsystem"
, b.memory_pool
,CASE
WHEN B.Subsystem IS Null THEN 'Inactive'
ELSE 'Active'
END AS "Status"

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,2,1 ;

will show what pools are in use for given sbs.
this works if the sbs has an active job running in it.

in this case QSPL is configured like:
Total -----------Subsystem Pools
Subsystem Storage (M) 1 2 3 4 5 6 7
QSPL .00 2 3

where 2 = *base and 3=*spool (on my system)

library sbsd pool active
QSYS QSPL BASE Active
QSYS QSPL SPOOL Active

if there are no jobs in the given sbs then you cannot see the other pools being used.


seems a little closer to what I think you are asking for, without a new SQL service for outputting the entire subsystem description and selecting from that table/view.

Bryan

Rob Berendt wrote on 2/10/2020 1:35 PM:

I don't suppose there's a service out there listing subsystem descriptions, active or not, is there? I'd like to be able to do something like
Select subsystem_name, subsystem_schema, pool_name
Where pool_name = '*SHRPOOL2';

See also:

Retrieve Subsystem Information (QWDRSBSD) retrieves information about a specific subsystem.
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_74/apis/qwdrsbsd.htm

IBM i Services
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_74/rzajq/rzajqservicessys.htm

IBM i Services (SQL)
https://www.ibm.com/support/pages/node/1119123


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com