Tweet
We are duplicating our entire production environment into new libraries based on a software release from a vendor. All programs, PFs, DSPFs and PRTFs should exist in the new system, but may have changes based on the new release.
I want to verify that all the objects in the "Old" environment also exist in the "New" environment.
I can run many DSPOBJD *OUTFILE *REPLACE commands, refreshing periodically and then compare, but thought it might be simpler to run SQL queries against QSYS and QSYS2 to get "Live" data and compare. But I am having trouble finding all the system files I need.
QSYS2.PROGRAM_INFO and QSYS2.SYSTABLES got me started, but I can't find where *PRTF and *DSPF file information is stored.
Does anyone have a list of the most common or useful system files I can query ?
Or thoughts of a better way ?
I want to verify that all the objects in the "Old" environment also exist in the "New" environment.
I can run many DSPOBJD *OUTFILE *REPLACE commands, refreshing periodically and then compare, but thought it might be simpler to run SQL queries against QSYS and QSYS2 to get "Live" data and compare. But I am having trouble finding all the system files I need.
QSYS2.PROGRAM_INFO and QSYS2.SYSTABLES got me started, but I can't find where *PRTF and *DSPF file information is stored.
Does anyone have a list of the most common or useful system files I can query ?
Or thoughts of a better way ?
Comment