While testing a BRMS recovery, QSYS2 had 1 object not restored.
File SYSLIMITS in library QSYS2 deferred.
SYSLIMITS is a LF with 3 PF dependencies, one if which is in library SYSIBM/SYSDUMMY1.
Based on file . . . . . . . . . . . . . . : SYSLIMTBL
Library . . . . . . . . . . . . . . . . : QSYS2
Member . . . . . . . . . . . . . . . . : SYSLIMTBL
Based on file . . . . . . . . . . . . . . : SQL_SIZING
Library . . . . . . . . . . . . . . . . : QSYS2
Member . . . . . . . . . . . . . . . . : SQL_SIZING
Based on file . . . . . . . . . . . . . . : SYSDUMMY1
Library . . . . . . . . . . . . . . . . : SYSIBM
What is Sysibm sysdummy1?
SYSDUMMY1 catalog table. ... It is used for SQL statements in which a table reference is required, but the contents of the table are not important. The schema is SYSIBM. Unlike the other catalog tables, which reside in Unicode table spaces, SYSIBM.SYSDUMMY1 resides in table space SYSEBCDC, which is an EBCDIC table space.
SYSIBM will not be restored till near the end, sequence 684.
At that point the deferred object should restore SYSLIMITS from QSYS2.
I'm assuming this is normal behavior, but why would IBM do this and cause extra confusion during a recovery.
Why would they not create SYSDUMMY1 in QSYS2, then all would be good.
No X-LIB LF.
Do others in the group see this same behavior on their LPARs, SYSDUMMY1 in library SYSIBM?
Thank You
_____
Paul Steinmetz
IBM i Systems Administrator
Pencor Services, Inc.
462 Delaware Ave
Palmerton Pa 18071
610-826-9117 work
610-826-9188 fax
610-349-0913 cell
610-377-6012 home
psteinmetz@xxxxxxxxxx
http://www.pencor.com/
midrange.com
