Spool space is full and we are receiving message 040W. Is there a way to tell what user ID is taking up a lot of the spool space?
Yes, use the VMSPOOL OVERVIEW command.
The OVERVIEW command will display the OVERVIEW screen which provides a summary of the current state of your spooling system.
It presents a full screen of the "Largest Users" and Largest Files" which makes it easy to identify who is hogging up the spool.
If you determine that you need to purge files, you may then issue the PURGE command or start a backup job that purges files after they have been copied to tape.
If you want to read up on OVERVIEW or PURGE, they are documented in the VM:Spool Command Reference which can be accessed at:
https://docops.ca.com/ca-vm-spool/1-8/en/reference/command-reference