Database Reference
In-Depth Information
29. Delete orphaned job logs with report RSTS0024.
30. Delete BW RSTT traces with report RSTT_TRACE_DELETE.
31. Check entries of RSZ tables with report ANALYZE_RSZ_TABLES. Check the res-
ults and correct any errors.
32. Delete unused master data.
Deleting unused master data…
Look for objects with the largest master data tables. Go to the D ATA
W AREHOUSING W ORKBENCH . Choose I NFO O BJECT . Choose D E -
LETE M ASTER D ATA from the right-click (context) menu.
33. Delete old PSA data. Check the size of the PSA and delete old data via the process
chain. Run program ZBW_DISP_PSA_REQ_OLD_N_DAYS with the parameter of
PSA requests older than 15 days. Then run program ZBW_MASS-
DEL_PSA_CLEANSING with the parameter to delete PSA requests older than 15 days.
34. Purge intermediary results from APD with report
RSAN_UT_RESULT_DROP_RESULTS.
35. Cleanse change logs, as permitted. Check the timeline to ensure the delta is not affec-
ted. Check the size of the change logs and delete old data via process chain.
36. Check RS* tables (the row store list) using transaction code DB20 to analyze the
tables.
37. Delete old spool requests with report RSPO1041.
38. Reorganize SNAP table and delete short dumps with report RSSNAPDL.
39. Delete statistics data from job runtime statistics with report RSBPSTDE.
40. Delete update requests with report RSM13002.
41. Delete old tRFC entries with report RSARFCER.
42. Delete old ST03N source system data with report
SWNC_COLLECTOR_CLEAN_SWNCMONI.
43. Delete authorization logs and disable log recording for all users with RSECADMIN.
Search WWH ::




Custom Search