cancel
Showing results for 
Search instead for 
Did you mean: 

Running r3szchk while system is online

0 Kudos

Hi all,

maybe it's quite a simple question but I didn't find any answer in these forums.

I want to migrate my database from MAXDB to ORACLE.

My customer wants to have as little downtime as possible. Since r3szchk runs about 16 hours under SAPDB 7.3 it would help a lot to have the system online during this time.

Is that possible or will I run into problems while importing the database?

During the export itself the system will be shutdown of course.

Kind regards,

Bastian

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Dear Bastian,

I'm performing the same issue, I'm exporting from Maxdb to Oracle with same OS (AIX)

I wish you could help with some problems I had, as I can't find the answers in the web.

Two errors happens during the export, the first one was during R3load.

After I couldn't correct it, I run it again, and another error appeared with R3szchk....

These are the log file for the Two errors.

For the first error with R3load I had the following

DBEXPORT.LOG

.

.

.

.

INFO 2007-12-19 14:22:25 DBEXPR3LOADEXEC_IND_ADA R3loadPrepare:0

Total number of processes: 15

0 process(es) finished successfully:

15 process(es) finished with errors: 0 1 2 3 4 5 6 7 8 9 10 11 12

13 14

0 process(es) still running:

ERROR 2007-12-19 14:22:25 DBEXPR3LOADEXEC_IND_ADA R3loadPrepare:0

Processes started: 15

Ended with error: 15

load tool ended with error.

See above SAP*.log errors.

ERROR 2007-12-19 14:22:25 DBEXPR3LOADEXEC_IND_ADA R3loadFork:0

RC code form SyChildFuncWait = 255 .

ERROR 2007-12-19 14:22:25 DBEXPR3LOADEXEC_IND_ADA R3loadFork:0

See logfiles SAPlog and EXlog for further information.

ERROR 2007-12-19 14:22:25 DBEXPR3LOADEXEC_IND_ADA InternalInstallationDo:0

R3loadFork erred

ERROR 2007-12-19 14:22:25 DBEXPR3LOADEXEC_IND_ADA InstallationDo:0

Phase failed.

ERROR 2007-12-19 14:22:25 InstController Action:0

Step DBEXPR3LOADEXEC_IND_ADA could not be performed.

ERROR 2007-12-19 14:22:25 Main

Installation failed.

ERROR 2007-12-19 14:22:25 Main

Installation aborted.

I don't have any EX""".log and the SAP""".log are all identical saying the following

START OF LOG: 20071219142222

R3load version @(#) $Id: //bas/46D/src/ins/R3load/R3load.c#16 $ SAP

R3load -e SAP""".cmd -p SAP""".log

start of syntax check

end of syntax check

(EXP) ERROR: DbSlControl failed

rc = 20

#STOP: 20071219142225

ONLY THAT

(The """ are for the different process)

.

.

.

.

The log from the second error (R3szchk) is the following

INFO 2007-12-20 16:32:15 R3SZCHK_IND_ADA R3ldctlDo:0

Error: Can not close lock

I need both solution if you have them

Thanks in advance

Roberto.

david_malinconici2
Participant
0 Kudos

Yes, it is possibile, but you must pay attention to the following extremely important point.

Since r3ldctl runs before r3szchk and no changes to tables definition must be done after starting r3ldctl.

Changing tables definition after running r3ldctl could lead to data loss or inconsistency!

To avoid this you must be sure that no change requests involving data dictionary (eg: add or delete table fields) are imported in the system during these steps.

The best way to ensure this is to stop all import of change request since you start R3SETUP/SAPINST.

Changing tables definition after running r3ldctl could lead to data loss or inconsistency!