• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1666
  • Last Modified:

iSeries list of objects changed.

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?.
0
Apolo Victores
Asked:
Apolo Victores
1 Solution
 
Dave FordSoftware Developer / Database AdministratorCommented:
Greetings!

First, run the following command:
DSPFD FILE(MySchema/*ALL)
      TYPE(*MBRLIST)
      OUTPUT(*OUTFILE)
      FILEATR(*PF)
      OUTFILE(myLib/allPFs)

Then, run the following SQL to identify the objects that have changed.

SELECT MLLIB,        
       MLFILE,       
       MLUDAT,       
       MLCHGD        
  FROM myLib/allPFs  
 order by MLCHGD desc

HTH,
DaveSlash

Open in new window

0
 
tliottaCommented:
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.

Tom
0
 
tliottaCommented:
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.

Tom
0
 
Gary PattersonVP Technology / Senior Consultant Commented:
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
0
 
Apolo VictoresAuthor Commented:
I would need also for all other objects different of ยจ*files
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now