Objects missing in the database

[Former Member]

Hello,

I am trying to install a test system using homegenous system copy method from production system .

SAP version is ERP 6.0, Kernel Patch is 275. Using SR3 installation DVDs.

OS verion is iSeries V6R1M0.

Using IASP.

Unfortunately I got an error on Adjust name table step as follows (I did this copy procedure many times before but never got this error)

"CJS-30023 Process call '\usr\sap\URT\SYS\exe\run\dipgntab -rwr40 -srctt DDNTT -srctf DDNTF -dsttt DDNTT -dsttf DDNTF -ttonly TT' exits with error code 255. For details see log file(s) dipgntab.log."

dipgntab.log is as follow.

/usr/sap/URT/SYS/exe/run/dipgntab=>sapparam(9): environment variable $SAPSYSTEM format error.

ERROR in initialization (can't get R/3-version)

ERROR in initialization (can't get R/3-version)

I log on to the system and ran the command "/usr/sap/URT/SYS/exe/run/dipgntab -rwr40 -srctt DDNTT -srctf DDNTF -dsttt DDNTT -dsttf DDNTF -ttonly TT".

Output is as follows;

-

---

>> "69604" active nametabs found

>> "69604" active nametabs rewritten

>> "0" rewrites failed

End: Rewrite of active nametabs ("20110423225210")

-

---

Begin: 2011/04/23 22:39:32, rewrite of Shadow-Nametabs

End: 2011/04/23 22:52:10, rewrite of Shadow-Nametabs

"69604" Shadow-Nametabs rewritten

>> 69604 Nametabs found.

>> 69604 Nametabs rewritten.

>> 0 rewrites failed.

After this I thought that this step is okey and edited keydb.xml and skipped this phase of the installation and finished the installation without any error.

My system is up now and everthing seems normal except the tables and views in DB.

I ran SM28, SE06, SM37, SU01 and no error. No error on SM21 and ST22. Also no error on trace files in work folder.

When I run DB02 it shows me that there are missing objects in DB as follows. All objects are

Object Type Coumt Size(KB) Missing In DB Missing in Dictionary.

Tables 69782 5359755968 69707 0

Primary keys 69771 490744148 0 0

Indexes 13670 314557808 0 0

Views 9845 0

Question is what did I miss by running dipgntab command on OS using SIDADM user and skipping this phase from keydb.xml?

How can I solve the issue? How can I make objects are known by SAP?

Thanks and kind Regards,

Yuksel AKCINAR

[ralf_buescher]

Hi Yuksel,

I still recommend to use SAPinst for the homogeneous system copy on IBM i.

When using SAPinst, make sure you read and follow the related documentation and SAP Notes.

For the homogeneous system copy on IBM i based on SAV/RSTLIB, you have to follow SAP Note 585277.

As described in this SAP Note 585277, the RSTLIB command should always have the parameter OPTION(*NEW).

When doing the import of the system copy, SAPinst always creates an initial RSTLIB command with OPTION(*NEW).

You can check this command within the dialog phase of the SAPinst and you can change the command manually to adjust it to your own needs like for example using a tape.

If at the end the RSTLIB command is executed without the parameter OPTION(*NEW), you must fix your newly created SAP system database schema using the SAP Note 852158.

Good luck for your next system copy.

Kind regards, Ralf Büscher

SAP on IBM i porting team

[Former Member]

Hi Yuksel,

you are in pretty good shape ))

I don't know from here, what dipgntab to fail, but you did the correct thing

You just need to run the following at any time:(while SAP can be up)

CALL QSYS2/QSQXRLF PARM(DLT R3<sid>DATA)

CALL QSYS2/QSQXRLF PARM(CRT R3<sid>DATA)

The reason will be, that you used the RSTLIB option with *ALL instead of *NEW ... that is always a "well-known" error, because of this "unusual rstlib command" on the one hand and the missing CALL above in SAPinst ...

As I guess, you are doing a copy ABAP only, I can recommend you the following link:

http://www.4soi.de/homogenious-systemcopy.php

... just goit up as I'M in the states right now ...

Regards

Volker Gueldenpfennig, consolut international ag

http://www.consolut.com http://www.4soi.de http://www.easymarketplace.de