No doubt you were expecting me to chime in... ;-) Indeed, your performance monitor will show you that. And if your performance monitor also supports setting alerts for any performance metric being reported, you can get them as soon as you want. And it shows you not only the actual spool utilization (as you get from Q ALLOC SPOOL) but performance history data also reveals how quick you got to that percentage, and which users were creating the files that filled up spool (as opposed to where they are now, as Q RDR EXP shows you).
When you're doing alerts, it is very important to do so also on page space usage above 50%. Spool I/O is relatively slow and takes a lot of time to fill a large spool area. On all real systems where I have seen the 90% spool message, it was because paging space was full and overflowed into spool. That goes very quick and rarely gives you time to respond. Rob -- Rob van der Heij Velocity Software http://velocitysoftware.com/
