Re: Missing SYSIBM.SYSDUMMY1 object

On 21-Sep-2016 10:08 -0600, Maassel, John R. wrote:

I'm trying to refresh our development partition with a restore of
production. It's failing to create one view because of a join against
SYSIBM.SYSDUMMY1, which is apparently missing. Is there an easy way
to recreate it? Can I just restore the one from production?

The file is apparently created vs restored as part of the installation [i.e. per Created By User of QLPINSTALL is typically seen], such that probably there is a program that [re]creates the object. Thus the file could easily be restored from another system or created locally; the owner is QSYS and the authority AUT(*READ *OBJOPR), and I am unsure if any Check Product Option (CHKPRDOPT) might verify either of those attributes [without correcting the condition, and thus possibly mark an option in error; best to maintain the expected ownership and authority].

If that specific object is missing, then there may be others missing, so probably best to call the program that rebuilds a number of such created-vs-restored objects. By recollection and results from the request "chkobj qsys/qsqsysibm *pgm aut(*NONE)" I expect that calling that named program is likely corrective to many possibly missing [non-shipped\restored] objects for the SYSIBM library -- some past topics may reference that program name and give more information, such as to preface the CALL request with a Change Job (CHGJOB) request that [re]sets the CCSID value of the requesting\calling job to match the system default SBCS or Mixed CCSID.