7.8.01.18 - R3szchk needs hours (homogeneous copy)

[Former Member]

During an R3load export (Maxdb --> MaxDB) the R3szchk runtime is way too long, it needs almost 2,5 hours to estimate the tables sizes although it uses the database specific method:

/usr/sap/BIP/SYS/exe/run/R3szchk -p /edvinst/sap/BIP_SHELL/ABAP/DATA \
-l R3szchkExport.log -s DB -t ada BIP 700 \
-f /edvinst/sap/BIP_SHELL/ABAP/DATA/SAPAPPL2.STR \
 /edvinst/sap/BIP_SHELL/ABAP/DATA/SAPPOOL.STR \
 /edvinst/sap/BIP_SHELL/ABAP/DATA/SAPSSRC.STR \
 /edvinst/sap/BIP_SHELL/ABAP/DATA/SAPSLOAD.STR \
/edvinst/sap/BIP_SHELL/ABAP/DATA/SAPSDOCU.STR \
/edvinst/sap/BIP_SHELL/ABAP/DATA/SAPSDIC.STR \
 /edvinst/sap/BIP_SHELL/ABAP/DATA/SAPAPPL1.STR \
/edvinst/sap/BIP_SHELL/ABAP/DATA/SAPDFACT.STR \
/edvinst/sap/BIP_SHELL/ABAP/DATA/SAPCLUST.STR \
 /edvinst/sap/BIP_SHELL/ABAP/DATA/SAPDDIM.STR \
 /edvinst/sap/BIP_SHELL/ABAP/DATA/SAP0000.STR \
/edvinst/sap/BIP_SHELL/ABAP/DATA/SAPSSEXC.STR \
/edvinst/sap/BIP_SHELL/ABAP/DATA/SAPUSER.STR \
 /edvinst/sap/BIP_SHELL/ABAP/DATA/SAPAPPL0.STR \
/edvinst/sap/BIP_SHELL/ABAP/DATA/SAPDODS.STR \
/edvinst/sap/BIP_SHELL/ABAP/DATA/SAPSPROT.STR \
 /edvinst/sap/BIP_SHELL/ABAP/DATA/SAPSLEXC.STR

<...>
(STARt)
INFO       2010-12-22 00:22:22.575
<...>
(END)
INFO       2010-12-22 02:56:44.021
<...>

I would understand that runtim if the dictionary method would be used - but I see no reason why the DB method is taking that long.

x_cons reports on UKT as "running" for all that time so there's no I/O taking place.

$ R3szchk -v
$Id: //bas/701_REL/src/R3ld/R3szchk/R3szchk.c#1 $
Compiled Sep 18 2010 00:05:05

Any idea what may cause that runtime?

Markus

[markus_doehr2]

And just to add - the file counters are current:

sqlcli BIP=> select count(*) from SYSUPDATECOUNTERWANTED
| EXPRESSION1                    |
| ------------------------------ |
|                              0 |
1 row selected (1095 usec)

Markus