iSeries list of objects changed.

Posted on 2011-05-09
Last Modified: 2012-06-27
I need to have a list of changed objects from an user library , this is an audit requirement , but I need  to filter this list by a specific dates, I mean  I need all the objects changed from January to uptodate. Is there any help?.
Question by:Apolo Victores
    LVL 18

    Accepted Solution


    First, run the following command:
    DSPFD FILE(MySchema/*ALL)
    Then, run the following SQL to identify the objects that have changed.
    SELECT MLLIB,        
      FROM myLib/allPFs  
     order by MLCHGD desc

    Open in new window

    LVL 26

    Expert Comment

    Note that DSPFD TYPE(*MBRLIST) FILEATR(*PF) refers specifically to physical file members. It misses some changes to the *FILE object itself as well as to logical file definitions, programs and all other types of objects. Changes to physical file data is separate from object changes that might affect how data is accessed or viewed.

    LVL 26

    Expert Comment

    Also be aware that MLCHGD is 'Last Change Date'. For physical file data that changes regularly, this will only reflect the last date of change -- perhaps today's date. To track dates of multiple data changes, journalling is required.

    If multiple changes occur to objects and those dates are needed, then object auditing needs to be enabled. The change dates (and times) could then be retrieved from the system audit journal.

    LVL 34

    Expert Comment

    by:Gary Patterson
    As Tom indicated, the best way to do this is to query the audit journal.  This requires, of course, that you configure auditing and maintain the audit journal entries for the period in question.  If that's not an option, then your best alternative is to use the DSPOBJD command OUTPUT(*OUTFILE).  Specify a file, and then you can run a query or write a program to filter the output.  You could also use Client Access to transfer the file to Excel or the PC tool of your choice and manipulate it or manually select our the records you want.

    Note that you are probably interested in objects with a Change Date or Restore Date in the desired date range.

    You should read the Security Reference for your version to understand how these fiends get updated.  It may not always be when you think it is.

    - Gary Patterson

    Author Closing Comment

    by:Apolo Victores
    I would need also for all other objects different of ¨*files

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    Suggested Solutions

    Digital marketing agencies have encountered both the opportunities and difficulties that emerge from working with a wide-ranging organizations.
    If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now