On 15-Jul-2014 23:11 -0500, Steinmetz, Paul wrote:

I used your example, simplified.

select * from qgpl/QASYJSJ5 where locate ('ARPINS2',JSLIBL ) <> 0

ARPINS2 is a library to be deleted.
SQL returns nothing found.

If there is any doubt or uncertainty with the result set of that specific query, then the effective equivalent could be performed also:

select * from qgpl/QASYJSJ5 where JSLIBL LIKE '%ARPINS2%')

There are also other similar non-SQL means to easily perform the "same" inquiry; e.g. further validation, to be more sure the token does not exist in that data:


DSPPFM qgpl/QASYJSJ5 /* F16=Find _after_ using F14=Find Options to specify that the search is case sensitive, the column positions for the JSLIBL field (are ¿729 to 1158?), and the search token is: 'ARPINS2' */


Based on this, library ARPINS2 has not been used in any job since
March 20, 2014.

Is my logic and findings conclusive?

Presuming first, that the audit journal output includes the T-JS entries do indeed span that era; perhaps.

I have not used that specific data before, but what I seem to recall about the T-JS, may not match your understanding; I infer that the empty result set of the query suggests only that the named library has never been part of the *LIBL within a job that has been *started* [or transitioned across a captured job status; e.g. CHG, HLD, RLS, DSC, etc.] on the system over that period. Do the effects of every EDTLIBL, ADDLIBLE, CHGSYSLIBL, and CHGLIBL request, also generate a T-JS with the updated Library List data appearing in the JSLIBL column of the DSPJRN [or deprecated DSPAUDJRNE, or CPYAUDJRNE] output? If not, using only that data and selection criteria, seems tenuous for considering the library eligible for deletion; though I suppose acceptable, if also the library is currently empty and has not /changed/ since then, such that no objects could have been inserted and removed [and thus seemingly /remained/ empty] over that period.?

Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2015 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact