Spoolusage from DBQL for failed SQLs

Database
Teradata Employee

Spoolusage from DBQL for failed SQLs

When a user SQL fails with 2646 error(No more spool space error), Which is the best place to look at the requested spool space by the user for that transaction?

Queried DBQLogtbl, but that doesnt seem to give the exact requested spoolusage for failed SQLs.

Any thoughts?