How to create a DDLORA.TPL template for Migration Monitor

[Former Member]

Hi,

I'm trying a optimize a EXPORT database (SAP ERP 5.0, SAP Kernel 640, Oracle 9i and RHEL 4), and I want to use the template DDL<db>.TPL for "sorted" unpacking and DDL<db>_LRG.TPL for "unsorted" unpacking.

I followed the recommendation of notes 1040674 and 954268 (latest sap kernel patch, and Migration Monitor 700)

Note 1040674 - R3ta in combination with unsorted unload

Explanation wich tables can not be exported without ORDER BY is documented in SAP Note 954268.

Follow chapter 6.1.2 "Assigning DDL Files to Packages" in the SAP System Copy Guide. You may copy the DDLDB2.TPL file and remove the ORDER_BY_PKEY literal for all packages that should use unsorted unload.

Note 954268 - Optimization of export: Unsorted unloading

Table type:

Kernel or R3load lower than 6.40:

Tables of the 'Report' type (R), 'Nametab' type (N) and 'Screen' type (D) must always be unloaded sorted. The table type is part of the STR file. It is stored in the fifth column of the 'att:' line of the relevant table.

Migration Monitor

    You can use the new Migration Monitor to assign different DDL<db>*TPL templates to the packages.

     MIGMON.SAR 7.00, as of patch level 1

The Migration Monitor is downward-compatible. As new features and bug fixes are only implemented in the latest version,SAP urgently recommends that you always use the latest version available.

On the Migration Monitor Guide, this is a example to use template

# DDL mapping file ddl_mapping.txt

# !!! line with [GROUP_NAME] can be skipped

# used for documentation purposes only

[ SORTED UNLOAD ]

# DDL file for sorted unload

ddlFile = /export_dump/ABAP/DB/ORA/DDLORA.TPL

# package names

SAPAPPL0

SAPAPPL1

SAPSDIC

SAPSSEXC

[ UNSORTED UNLOAD ]

# DDL file for unsorted unload

ddlFile = ./DDLORA_LRG.TPL

# table names

BKPF

BSAD

BSAK

BSID

FAGLFLEXA

I followed this example but all the tables  are still unloaded with "ORDER BY" sentence.

Some one has a example how to create a DDL templates for use Unsorted and Sorted  Unload?

[Former Member · Accepted solution]

Hi Jorge,

Use two different export_monitor_cmd.properties file and execute from two different location.

Use one exclusively for sorted and another one for unsorrted export.

Also copy DDLORA.TPL and DDLORA_LRG.TLP file to executable directory from where you will execute export_monito.sh, and specify full path( ddlFile ).

Good luck.

Regards,

Dipam

[Former Member]

Hi,

Thanks for your recommendations and finally could finish with this issue.

Before to configure migration monitor parameters, I backup the Export Directory.

For Extraction of Tables with SORT UNLOAD I executed with the next parameters (installation directory)

export_monitor_cmd.properties

ddlFile=/export/QASEXP/DB/DDLORA.TPL

ddl_mapping.sorted.txt

[ SORTED UNLOAD ]

# DDL file for sorted unload

ddlFile = /export/QASEXP/DB/ORA/DDLORA.TPL

# package names

SAPSDIC

SAPSSEXC

For Extraction tables with UNLOAD UNSORTED I executed with the next parameters (copy of installation directory)

export_monitor_cmd.properties

ddlFile=/export/QASEXP/DB/DDLORA_LRG.TPL

ddl_mapping.unsorted.txt

[ SORTED UNLOAD ]

# DDL file for sorted unload

ddlFile = ./DDLORA_LRG.TPL

SAPAPPL0

SAPAPPL1

SAPAPPL2

SAPCLUST

SAPDDIM

SAPDFACT

SAPDODS

SAPPOOL

SAPSDOCU

SAPSLEXC

SAPSLOAD

SAPSPROT

SAPSSRC

SAPUSER

For the process of Import I did the next configuration:

SORTED LOAD:

export_monitor_cmd.properties

ddlFile=/export/QASEXP/DB/DDLORA.TPL

# Optional path of R3load executable

r3loadExe=

# Generation of task files: yes | no

tskFiles=yes

# Inclusion of extent files: yes | no

extFiles=yes

# DB code page for the target database

dbCodepage=1100

# Migration key

migrationKey=

# R3load omit value, can contain only 'DTPIV' letters

omit=

# Additional R3load arguments for TASK phase

taskArgs=

# Additional R3load arguments for LOAD phase

loadArgs=-loadprocedure fast  -merge_bck -nolog -stop_on_error

# Number of parallel import jobs

jobNum=3

ddl_mapping.sorted.txt

[ SORTED UNLOAD ]

# DDL file for sorted unload

ddlFile = /export/QASEXP/DB/ORA/DDLORA.TPL

# package names

SAPSDIC

SAPSSEXC

UNSORTED LOAD

export_monitor_cmd.properties

ddlFile=/export/QASEXP/DB/DDLORA_LRG.TPL

# Optional path of R3load executable

r3loadExe=

# Generation of task files: yes | no

tskFiles=yes

# Inclusion of extent files: yes | no

extFiles=yes

# DB code page for the target database

dbCodepage=1100

# Migration key

migrationKey=

# R3load omit value, can contain only 'DTPIV' letters

omit=

# Additional R3load arguments for TASK phase

taskArgs=

# Additional R3load arguments for LOAD phase

loadArgs=-loadprocedure fast  -merge_bck -nolog -stop_on_error

# Number of parallel import jobs

jobNum=8

ddl_mapping.unsorted.txt

[ SORTED UNLOAD ]

# DDL file for sorted unload

ddlFile = ./DDLORA_LRG.TPL

SAPAPPL0

SAPAPPL1

SAPAPPL2

SAPCLUST

SAPDDIM

SAPDFACT

SAPDODS

SAPPOOL

SAPSDOCU

SAPSLEXC

SAPSLOAD

SAPSPROT

SAPSSRC

SAPUSER

[Former Member]

Just a guess but could you specify the full path here and retry?

ddlFile = ./DDLORA_LRG.TPL

Cheers Michael