I am new to iseries. I apologize if I have posted to the wrong forum.
I would like to use SQL to determine which files in a library are or are not being journaled. I know how to check an individual file in System Navigator, but I want to check all files using SQL. I don't think the DISPLAY_JOURNAL table function helps me because there may not be something in a journal for a file that hasn't been changed in a very long time. The OBJECT_STATISTICS table function doesn't provide me the info because we are on V7.1. Does anyone know of a way using SQL I can accomplish what I am trying to do?
Thanks in advance!
Scott
I would like to use SQL to determine which files in a library are or are not being journaled. I know how to check an individual file in System Navigator, but I want to check all files using SQL. I don't think the DISPLAY_JOURNAL table function helps me because there may not be something in a journal for a file that hasn't been changed in a very long time. The OBJECT_STATISTICS table function doesn't provide me the info because we are on V7.1. Does anyone know of a way using SQL I can accomplish what I am trying to do?
Thanks in advance!
Scott
Comment