reports that can be run (using the Datacom for CSM or other product) that would list all of the zFS datasets

Document ID : KB000073576
Last Modified Date : 17/08/2018
Show Technical Document Details
Question:
 Are there any reports that can be run (using the Datacom for CSM or other product) that would list all of the zFS datasets that are in use? 
Answer:
You can run the following DBSQLPR job to show all of the zFS datasets that are in use. 

//SQLEXEC EXEC PGM=DBSQLPR, 
// PARM='PRTWIDTH=133,INPUTWIDTH=72' 
//STEPLIB DD DSN=MSM.PT.V60R.CUSLIB, 
// DISP=SHR 
// DD DSN=MSM.PT.V60R.CAAXLOAD, 
// DISP=SHR 
//CAOESTOP DD SYSOUT=* 
//SYSPRINT DD SYSOUT=* 
//SYSOUT DD SYSOUT=* 
//STDOUT DD SYSOUT=* 
//SYSPUNCH DD DUMMY 
//DDSNAP DD SYSOUT=* 
//SNAPER DD SYSOUT=* 
//SYSUDUMP DD SYSOUT=* 
//THRSHOUT DD SYSOUT=* 
//SYSPRINT DD SYSOUT=* 
//OPTIONS DD * 
AUTHID=CASWMGT 
/* 
//SYSIN DD * 
select * from mountpoint; 
/*
Additional Information:

DBSQLPR Utility--Execute SQL through CA Datacom/DB - CA ...

https://docops.ca.com/ca.../15.../dbsqlpr-utility-execute-sql-through-ca-datacom-db