QSYS2 SQL catalog files no longer restored with restore commands
In IBM i 7.4 with PTF SI71741, certain files in the QSYS2 library are not restored if they
already exist. The following physical files in the QSYS2 library (in *SYSBAS or on an independent
ASP) represent SQL catalog tables and are not restored if they already exist:
| SQL Table Name | System File Name |
|---|---|
| SYSJARCONTENTS | SYSJARCONT |
| SYSJAROBJECTS | SYSJAROBJ |
| SYSPARMS | SYSPARMS |
| SYSROUTDEP | SYSROUTDEP |
| SYSROUTINES | SYSROUTINE |
| SYSSEQOBJECTS | SYSSEQOBJ |
| SYSTYPES | SYSTYPES |
| SYSVARIABLEDEP | SYSVARDEP |
| SYSVARIABLES | SYSVARS |
| XSRANNOTATIONINFO | XSRANNOTAT |
| XSROBJECTCOMPONENTS | XSROBJCOMP |
| XSROBJECTHIERARCHIES | XSROBJHIER |
| XSROBJECTS | XSROBJECTS |
These physical files and any other logical files dependent on these physical files are not restored if the file already exists in the target library. The files are excluded from the restore. If one of these files must be restored from the save media, the target file must be deleted prior to the restore.
Prior to the application of the PTF, the QSYS2 SQL catalog tables would be restored which often caused SQL catalog problems.