Skip to Content
Author's profile photo Eason Chen

系统迁移HANA 示例及问题诊断(三)

2.2. 导入目标系统 (BW on HANA)


2.2.1 设置OS环境变量

在使用SWPM进行导入前,需要设置如下变量。

HDB_MASSIMPORT, 此参数参考Note 1775293及link:Migration to SAP HANA: Latest News about SAP Note 1775293

_JAVA_OPTIONS,此参数参考link:RUNNING WITH JAVA

/wp-content/uploads/2015/09/2_2_1png_784572.png


2.2.2 设置HANA系统参数

建议将log_mode在进行import时临时修改为overwrite,以避免在导入过程中生成大量log backup文件。

/wp-content/uploads/2015/09/2_2_2png_784573.png


2.2.3 设置Table Placement

此处需要按照您HANA系统架构(单机或是集群;集群中包含多少worker节点)解压出Note1908075中对应的HdbTablePlacementParameters.SQL 文件。

/wp-content/uploads/2015/09/2_2_3_1_784604.png

/wp-content/uploads/2015/09/2_2_3_2_784605.png

/wp-content/uploads/2015/09/2_2_3_3_784606.png


2.2.4 执行SWPM

/wp-content/uploads/2015/09/2_2_4_1_784607.png

/wp-content/uploads/2015/09/2_2_4_2_784609.png

/wp-content/uploads/2015/09/2_2_4_3_784610.png

/wp-content/uploads/2015/09/2_2_4_4_784611.png

/wp-content/uploads/2015/09/2_2_4_5_784612.png

/wp-content/uploads/2015/09/2_2_4_6_784613.png

/wp-content/uploads/2015/09/2_2_4_7_784615.png

/wp-content/uploads/2015/09/2_2_4_8_784618.png

/wp-content/uploads/2015/09/2_2_4_9_784619.png

/wp-content/uploads/2015/09/2_2_4_10_784620.png

这里将路径设置为在之前步骤2.1.2中导出媒介所在路径。

/wp-content/uploads/2015/09/2_2_4_11_784621.png

/wp-content/uploads/2015/09/2_2_4_12_784622.png

/wp-content/uploads/2015/09/2_2_4_13_784623.png

/wp-content/uploads/2015/09/2_2_4_14_784624.png

/wp-content/uploads/2015/09/2_2_4_15_784628.png

将路径设置为先前解压文件HdbTablePlacementParameters.SQL所在路径。

/wp-content/uploads/2015/09/2_2_4_16_784629.png

下载Note1958346中附件HdbLandscapeReorgCheckProcedure.SQL,并设置对应路径。

/wp-content/uploads/2015/09/2_2_4_17_784630.png

/wp-content/uploads/2015/09/2_2_4_18_784631.png

/wp-content/uploads/2015/09/2_2_4_19_784632.png

/wp-content/uploads/2015/09/2_2_4_21_784637.png

此处需要指定SAPEXE.SAR以及SAPEXEDB.SAP路径到下载的kernel 文件路径。

在解压从service market place后,这两个文件的文件路径如下:

SAPEXE.SAR:/DATA_UNITS/K_7XX_U_LINUX_X86_64/DBINDEP/

SAPEXEDB.SAP:/DATA_UNITS/K_7XX_U_LINUX_X86_64/HDB/


/wp-content/uploads/2015/09/2_2_4_20_784633.png

/wp-content/uploads/2015/09/2_2_4_22_784639.png

/wp-content/uploads/2015/09/2_2_4_23_784640.png

/wp-content/uploads/2015/09/2_2_4_24_784641.png

/wp-content/uploads/2015/09/2_2_4_25_784642.png

导入完成。







Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.