CMD : SY L

Ever wondered how can you list out the maintenance job details, logs, Job run time, job name for a tablespace present in your subsystem using CA Platinum ? Here are some simple steps that you need to perform to gather information from the DB2 catalog.

1. List the tablespace in Platinum using RC Query as shown below - 


2. Issue the '' SY L '' command against the tablespace -


3. Platinum displays the information from SYSIBM.SYSCOPY table for the tablespace. Press the PF11 key to see more details as per your requirement

If your shop possesses CA Database Management Solutions for DB2 for z/OS then you need not run any queries in SPUFI to analyze maintenance activities on the tablespaces instead you can use the above method to get your work done