Table splitting of REPOSRC for system copy

[benoit-schmid]

Hello,

I would like to use table splitting on table REPOSRC, during an R3Load export (on Source System).

I have provided a file, to swpm, with the following:

# cat /var/tmp/splitTable.txt

REPOSRC%10

But the file is ignored as the following is generated:

cat /var/tmp/sapinst_instdir/BS2008/ERP604/LM/COPY/ORA/EXP/CENTRAL/AS-ABAP/EXP/REPOSRC.cmd

tsk: "/var/tmp/sapinst_instdir/BS2008/ERP604/LM/COPY/ORA/EXP/CENTRAL/AS-ABAP/EXP/REPOSRC.TSK"

icf: "/usr/local/sap/Export/ABAP/DATA/REPOSRC.STR"

dcf: "/usr/local/sap/Export/ABAP/DB/DDLORA_LRG.TPL"

dat: "/usr/local/sap/Export/ABAP/DATA/" bs=1k fs=1000M

dir: "/usr/local/sap/Export/ABAP/DATA/REPOSRC.TOC"

Could you please provide me the file structure for table splitting?

Thanks in advance for your answers.

[benoit-schmid · Accepted solution]

[former_member188883 · Accepted solution]

Hi Benoit,

Please copy the splitTable.txt to export directory and retry.

Regards,

Deepak Kori

[benoit-schmid · Accepted solution]

Hello Deepak,

Is it mandatory to do so?

Regards,

[former_member188883 · Accepted solution]

Hi Benoit,

It is looking for abap folder which shall exists in export directory only.

If I run the task Table Splitting Preparation only task, ti complains with:
Error cannot createDirectory /var/tmp/splitTable.txt/ABAP.

Hence suggested you to copy the file to export directory.

Regards,

Deepak Kori

[benoit-schmid · Accepted solution]

Hello Deepak,

If I put /usr/local/sap/Export/ instead of /usr/local/sap/Export,

it seems to be ok but do not ask me why there is this bug 🙂

It looks much nicer:

ps -ef | grep -i r3load | grep -v grep | awk '{print $2}' | xargs pargs | grep '\[2\]' | sort -n

argv[2]: APQD.cmd

argv[2]: BKPF.cmd

argv[2]: BPCG.cmd

argv[2]: BPCJ.cmd

argv[2]: BSAK.cmd

argv[2]: BSAS.cmd

argv[2]: BSIS.cmd

argv[2]: CDCLS-1.cmd

argv[2]: CDCLS-10.cmd

argv[2]: CDCLS-4.cmd

argv[2]: CDCLS-5.cmd

argv[2]: CDCLS-6.cmd

argv[2]: CDCLS-7.cmd

argv[2]: CDCLS-8.cmd

argv[2]: CDCLS-9.cmd

argv[2]: COEP.cmd

argv[2]: D010INC.cmd

argv[2]: D010TAB.cmd

argv[2]: DBTABLOG-1.cmd

argv[2]: DBTABLOG-10.cmd

argv[2]: DBTABLOG-2.cmd

argv[2]: DBTABLOG-3.cmd

argv[2]: DBTABLOG-4.cmd

argv[2]: DBTABLOG-5.cmd

argv[2]: DBTABLOG-6.cmd

argv[2]: DBTABLOG-7.cmd

argv[2]: DBTABLOG-8.cmd

argv[2]: DBTABLOG-9.cmd

argv[2]: DD03L.cmd

argv[2]: DOKCLU.cmd

argv[2]: DYNPLOAD.cmd

argv[2]: DYNPSOURCE.cmd

argv[2]: E071K.cmd

argv[2]: EDI40.cmd

argv[2]: EDIDS.cmd

argv[2]: FMIFIIT.cmd

argv[2]: FPLAYOUTT.cmd

argv[2]: INDTEXT.cmd

argv[2]: PCL2.cmd

argv[2]: PCL4.cmd

argv[2]: PPDIT.cmd

argv[2]: PPOIX.cmd

argv[2]: REGUC.cmd

argv[2]: REGUH.cmd

argv[2]: REPOSRC-1.cmd

argv[2]: REPOSRC-10.cmd

argv[2]: REPOSRC-2.cmd

argv[2]: REPOSRC-3.cmd

argv[2]: REPOSRC-4.cmd

argv[2]: REPOSRC-5.cmd

argv[2]: REPOSRC-6.cmd

argv[2]: REPOSRC-7.cmd

argv[2]: REPOSRC-8.cmd

argv[2]: REPOSRC-9.cmd

argv[2]: REPOTEXT.cmd

argv[2]: RFBLG.cmd

argv[2]: SAPAPPL0_1.cmd

argv[2]: SAPAPPL0_2.cmd

argv[2]: SAPAPPL0_3.cmd

argv[2]: SAPAPPL0_4.cmd

argv[2]: SAPAPPL1_1.cmd

argv[2]: SAPAPPL1_2.cmd

argv[2]: SAPAPPL1_3.cmd

argv[2]: SAPAPPL1_4.cmd

argv[2]: SAPAPPL2_1.cmd

argv[2]: SAPAPPL2_2.cmd

argv[2]: SAPAPPL2_3.cmd

argv[2]: SAPAPPL2_4.cmd

argv[2]: SAPAPPL2_5.cmd

argv[2]: SAPNTAB.cmd

argv[2]: SAPSSEXC_1.cmd

argv[2]: SAPSSEXC_2.cmd

argv[2]: SCPRSVALS.cmd

argv[2]: SCPRVALS.cmd

argv[2]: SEOCOMPODF.cmd

argv[2]: SEOSUBCODF.cmd

argv[2]: SEOSUBCOTX.cmd

argv[2]: SOFFCONT1.cmd

argv[2]: SWW_CONT.cmd

argv[2]: SWWBINDEF.cmd

argv[2]: SWWLOGHIST.cmd

argv[2]: TADIR.cmd

argv[2]: TOA02.cmd

argv[2]: TODIR.cmd

argv[2]: TST03.cmd

argv[2]: WBCROSSGT.cmd

argv[2]: WDY_CTLR_COMPO.cmd

argv[2]: ZBC_PROT_ARCH-1.cmd

argv[2]: ZBC_PROT_ARCH-10.cmd

argv[2]: ZBC_PROT_ARCH-2.cmd

argv[2]: ZBC_PROT_ARCH-3.cmd

argv[2]: ZBC_PROT_ARCH-4.cmd

argv[2]: ZBC_PROT_ARCH-5.cmd

argv[2]: ZBC_PROT_ARCH-6.cmd

argv[2]: ZBC_PROT_ARCH-7.cmd

argv[2]: ZBC_PROT_ARCH-8.cmd

argv[2]: ZBC_PROT_ARCH-9.cmd

argv[2]: ZBC_SPB.cmd

argv[2]: ZENGDET.cmd

Is it mandatory to run table split preparation or can we run everything in the export same step?

Thanks in advance for your answer.

[former_member188883 · Accepted solution]

Hi Benoit,

Export step will only export the database. It is recommended to run table split to improvise migration performance.

Regards,

Deepak Kori

[benoit-schmid]

Hello,

If I run the task Table Splitting Preparation only task, ti complains with:

Error cannot createDirectory /var/tmp/splitTable.txt/ABAP.

As /var/tmp/splitTable.txt is the file that I have provided to do the split,

for sure, it cannot create this subdir.

Would you have an idea on what I am making wrong?

Thanks in advance for your answers.

[former_member188883]

Hi Benoit,

Please share screen shot of the screen where you define the path for table split file.

Also what is your export dump directory path ?

Regards,

Deepak Kori

[benoit-schmid]

Hello,

My export dir is /usr/local/sap/Export.

I will send a screenshot.

Basically you are not daring saying this guy is stupid enough

to put the split file instead of the export dir 🙂

Am I right?

Regards,

[Former Member]

Hello Benoit,

we have to give the location of the file which contain the tables to be splitted . Also it should be in this format: TNAME', 'CNAME', no of packages

SplitTables.txt (Name of the file used in the SAPINST)

CATF%2

E071%2

TNAME is the name of the table to be spitted

CNAME is the name of the column for which the ranges will be calculated.

If you do not know appropriate columns choose a column of the primary key index.

By specifying the special name ROWID for CNAME rowid splitting is activated.

Please check the snote:1043380

regards

alen

Message was edited by: Alen S

[Former Member]

also check out this post: http://scn.sap.com/thread/334951

[benoit-schmid]

Hello,

Alen S wrote:
 we have to give the location of the file which contain the tables to be splitted . Also it should be in this format: TNAME', 'CNAME', no of packages

I am not sure of having understood everything.

Is it ok, I a create the following file:

# cat /var/tmp/splitTable.txt

REPOSRC,PROGNAME,R3STATE,10

Thanks in advance for your answer.

[ashish_vikas]

Benoit, I hope you are using R3ta table splitting.

# cat /var/tmp/splitTable.txt

REPOSRC%10

What happens when you Run SAPINST > Table splitting ? Did it generated .WHR files ? It should generate around 10 .WHR files.

If it has generated .WHR file, Did you coped these to DATA directory under export ?

best regards

ashish

[benoit-schmid]

Hello,

Yes, I have tried to use R3ta.

No .WHR files were created.

Regards,