Tuesday, February 2, 2016

1783937 - SMIGR_CREATE_DDL enhancements for Suite On Hana

Symptom
You want to create a heterogeneous system copy using an SAP HANA database as the target database.
The system to be migrated is a Business Suite system or ERP system.


Other Terms
Table classification, estimated row count, partitioning, ERP, heterogeneous system copy, SMIGR_CREATE_DDL, SoH, Suite On Hana


Reason and Prerequisites
Suite on HANA


Solution
The SAP HANA-specific parameter "Suite on HANA" (parameter name P_SOH) was added to the report SMIGR_CREATE_DDL. If you set this parameter, the number of table lines is determined for the tables of the type
  • Transparent table
  • Cluster table
  • Table pool
The results are saved to the file ESTIMATED_ROW_COUNT.TXT. SAPINST or SAP HANA landscape reorg uses this file for an optimal distribution of the tables in the SAP HANA database.
For tables that exceed a certain size (the threshold value is 500 million by default), additional DDL commands are created that are saved to the SQL files. Very large tables must be partitioned for heterogeneous system copies.

You can find the enhancement of SMIGR_CREATE_DDL in SAP Basis Support Packages 740 SP2, SAPKB74002. The Support Package SAPKB74003 specified in the section "Support Packages & Patches" is incorrect.

In urgent cases, you can implement the correction instructions as an advance correction.



Header Data

Released On 13.11.2013 10:18:46
Release Status Released for Customer
Component BC-DB-HDB-POR DB Porting for SAP HANA
Priority Correction with medium priority
Category Modification

No comments:

Post a Comment