Hi,
DSiM has five instance tables which need to cleansed to reflect new data deliveries in the system
/DDF/D_DDEL_INS -Data delivery instance table
/DDF/D_STEP_INS – Step instance table
/DDF/D_PROC_INS -Process instance table
/DDF/D_DSET_INS – Data set instance table
/DDF/D_FILE_INS -File Instance table
Schedular daemon program (SE38) – /DDF/ADU_DAEMON_SCHEDULAR, this program will initiate all jobs in the background with scheduled date and time
This program has various variants to run the jobs
/DDF/PFC_ALL – This process chain will load all SPRO settings data into SAP BW objects
Thanks
Madhu
Hi,
When we read this, we thought of simply deleting all entries in these tables i.e. via transaction se14. What we did on last Monday. But this caused serious problems in our system:
The first point could be resolved by executing the report “RSGENDUMP”. This report regenerates the programs and classes/interfaces mentioned in log entries in st22.
Finally we decided to restore the complete HANA database from a backup of past Wednesday. Now the system seems to work again but all the changes we made during the past days are gone.
Which ways are there to cleanse these tables? Is there a report etc.?
Best regards,
Erik
Hi Erik,
please have a look at DSiM application help. In chapter Process Flow Control -> Job Monitor -> Clean Archived Instances Job you find info how to delete entries from the instance tables.
Regards,
Patrick