Skip to Content
0
Former Member
Jan 18, 2011 at 05:24 PM

Long seq read times on sender sys for tables DPAYH and DPAYP

62 Views

Experts,

I'm doing a ERP initial package for time based reduction . My sender and receiver ECC systems are at ECC6.0 EHP3. My TDMS packages for sender/receiver are at this level:

DMIS_CNT 2006_1_700 0013 SAPK-61713INDMISCNT

DMIS_EXT 2007_1_700 0007 SAPK-71707INDMISEXT

DMIS_HR 2008_1_700 0004 SAPK-81704INDMISHR

My controller/Central system is at this level for TDMS packages:

DMIS 2006_1_700 0013 SAPK-61713INDMIS

DMIS_CNT 2006_1_700 0013 SAPK-61713INDMISCNT

DMIS_BSC 2008_1_700 0005 SAPK-81705INDMISBSC

DMIS_EXT 2007_1_700 0007 SAPK-71707INDMISEXT

DMIS_HR 2008_1_700 0004 SAPK-81704INDMISHR

Like I said, I'm doing a time based reduction with 1 years worth of data. I am including HR/payroll tables.

I'm at the step in the data transfer section:

Start Data Selection for Header Tables PC002_MT_CLUSTER_FILL_HEADER_TABLES

On the sender system, it is doing a sequential read on tables DPAYH and DPAYP. These have been running for days.

SELECT

*

FROM

"DPAYP"

WHERE

"MANDT" = :A0 AND "LAUFD" = :A1 AND "LAUFI" = :A2 AND "ORIGN" = :A3 AND "XVORL" = :A4 AND "PAYNO" =

:A5#

SELECT

*

FROM

"DPAYH"

WHERE

"MANDT" = :A0 AND "LAUFD" = :A1 AND "LAUFI" = :A2 AND "ORIGN" = :A3 AND "XVORL" = :A4 AND "PAYNO" =

:A5#

I've done many successful TDMS copies before, but usually I exclude HR. But this time I need it.

Do you guys have any tips on what I should be doing on this step?

Many thanks,

NICK