Objects missing in the database
I just completed a system copy for a BW3.1C system on AS400(version v5r3) from production. The system is back up after the refresh. But when i go to Db02->consistency check
>DB & ABAP dictionary check>new check
It shows me Objects missing in Database and beneath the table header it shows me *084 tables missing and in views shows me 2084 views missing.
I checked in the DB at the OS level. These table and views all of these exist in the Databse library R3<SID>DATA. Just to confirm, i also tried creating these from DB02 by clicking on "create in DB" and it came back with the error "table already exists in database.
While restoring I used the normal restore commands "RSTLIB SAVLIB(<source_database_library>) DEV(SAVF) SAVF(<lib>/<file>) OPTION(NEW) RSTLIB(R3<target_SID>DATA) OUTPUT(PRINT) MBROPT(ALL) ALWOBJDIF(*ALL)"
What am I doing wrong? Is there a way i can fix this or what other options do i have??
Does it look like what Note 66985 describes? If yes (SYS* views still point to the previous R3SIDDATA library), just do
CALL PGM(QSYS2/QSQXRLF) PARM('DLT' 'R3<SID>DATA')
CALL PGM(QSYS2/QSQXRLF) PARM('CRT' 'R3<SID>DATA')