PROCESS SUBTREE FAILED WITH RETURN CODE -1 AND ERRNO 3524 FOR OBJECT
Returns a directory. Not always the same directory.

create table qtemp.Trashed_Files as (
select path_name, max(data_change_timestamp, object_change_timestamp) as
last_update_timestamp,
'del objlnk(''' concat path_name concat ''')' as Command
from table (qsys2.ifs_object_statistics (
START_PATH_NAME => '/',
SUBTREE_DIRECTORIES => 'YES',
OMIT_LIST =>'/bin /dev /etc /fixes /home /java /lib /lib64 /temp /tmp /usr
/var /InstallShield /QDLS /QFileSvr.400 /QIBM /QNTC /QOpenSys /QOPT /QSR
/QSYS.LIB /QTCPTMM /QTEMP'))
where (((path_name like '%DATA/logs/%') or (path_name like
'%DATA/IBM_TECHNICAL_SUPPORT/console%')
or (path_name like '%DATA/IBM_TECHNICAL_SUPPORT/debug%')
or ((path_name like '/www/%') and path_name like '%/logs/%') )
and days(current timestamp) - days(max(data_change_timestamp,
object_change_timestamp)) > 14)
) with data
;

Opened up a case with IBM. I was given some useless trivia about them
often seeing this with directories that are not threadsafe, like /QDLS.
The directory shown in the case was obviously not /QDLS. I even omit that
in the OMIT_LIST above.
Oh, I was also told that the SQL statement works for him. Which, I
suppose, I should give him credit for trying. So many times I give
recreates and the vendor won't try it.

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.