Spool File Expiration

[daniellee789]

Hello,

I was looking into making spool files expire, since the system I manage creates hundreds of spool files daily.
My only concern is that doing so would mark open files as expired, which would cause them to be deleted when I run DLTEXPSPLF.
I tried searching on Google and couldn't find much so I'm hoping someone here knows.

Any help would be greatly appreciated!

[MFisher]

How about dumping all non-OPEN spool files info to a temp table, then read those records in a loop and mark them expired based on some criteria ?

INSERT INTO MyTempTable
SELECT * FROM TABLE(QSYS2.SPOOLED_FILE_INFO(USER_NAME => '*ALL'))
where STATUS <> 'OPEN'