Database Reference
In-Depth Information
44. Drop data from RSECLOG and RSECLOG_CL in SE14.
45. Reorganize tables from obsolete tablespaces (if any).
46. Set profile parameter rdisp/gui_auto_logout = 21600 and rdisp/max_wprun_time =
3600.
47. Run program RSAR_PSA_NEWDS_MAPPING_CHECK to check for any incon-
sistent PSA requests/tables.
48. Run report RSAR_PSA_NEWDW_MAPPING_CHECK with the REPAIR variant to
fix the PSA table mapping.
49. Identify all repartitioning shadow tables in the database using the following SQL
statements:
Select Table_name from dba_tables where table_name like '/BIC/4%';
Select Table_name from dba_tables where table_name like '/BI0/4%';
50. Delete all repartitioning shadow tables directly from the database.
51. Execute HANA sizing program (post-cleansing) /SDF/HANA_BW_SIZING.
52. Request and take backup. Confirm this with DB14.
6.3.11
Export preparation
Now that you have finished the housekeeping tasks for your DMO migration, you need
to know how to proceed with the preparations for the database export. These tasks are in-
cluded in this section.
1. Ensure adequate file system space is available for export dumps in the interim BW.
2. Check system directories (logical file names and file paths FILE = AL11).
3. Increase parameter lock_wait_timeout to 3600000 in indexserver.ini in the BW on
HANA database.
4. Set the parameter idle_connection_timeout to 0 in indexserver.ini in the BW on
HANA database.
5. Change the log_mode to overwrite in the BW on HANA database.
6. Grant the access required for table redistribution in the BW on HANA database:
Execute the following SQL as SYSTEM:
GRANT SELECT ON _SYS_RT.TABLE_PLACEMENT TO SAPBIW;
