Component : DB/OS Migrations -

Solution : https://service.sap.com/sap/support/notes/954268 (SAP Service marketplace login required)

Summary :
During a system copy, accelerating the export process by unloading data unsorted may depend on several factors, including the database types involved and specific table types. For Oracle and MSSQL databases, certain conditions and specific R3ldctl patch levels allow for unsorted data unloading. However, sorted unloading is mandated for tables like report, screen, and nametab types, as well as during codepage conversions for cluster tables. Configuration settings in the DDL.TPL file primarily govern these processes, with additional manual adjustments possible through R3ldctl generation or DDL*TPL templates manipulation. SAP recommends using the latest tools and patches from SAP Service Marketplace to ensure optimal implementation of these procedures, particularly when configuring the 'unsorted unload' feature available from SAP NetWeaver 2007 onwards.

Key words :
patch levels support unsorted unloading, -unicode --> unicode mdmp --> unicode unicode, patch level 1the migration monitor, d010 d02 ddntf            kernel, ddntf code page conversionif, patch level 9 db2 luw, ddl<db> tpl templates, patch level 5 db2, patch level 6            alternatively, patch level 55 oras

Related Notes :

1461056	Creating secondary index for R3ta table splitting
1319517	Unicode Collection Note
1066404	R3load, ORDER BY, Unicode conversion of cluster tables
1043380	Efficient Table Splitting for Oracle Databases
1040674	R3ta in combination with unsorted unload
1014782	FAQ: MaxDB system copy
806554	FAQ: I/O-intensive database operations