I have a client with this table growing at a rate of 15G per day and its already over 300G
There is no documentation as to what this table does can we truncate this table using a batch task is there any implications?
I have a client with this table growing at a rate of 15G per day and its already over 300G
There is no documentation as to what this table does can we truncate this table using a batch task is there any implications?
Hi Nzou:
Although the table has no assigned activity code, I think that TMPSRPT table is related to the KPO activity code (Portuguese localization).
If you are not using the Portuguese localization, you can decativate the KPO activity code.
The TMPSRPT table is very similar to the AREPORTM table. It is used to print Crystal Reports documents. I usually delete all the AREPORTM records from time to time without any problem. But I don't know what impact it will have to delete records from the TMPSRPT table.
Maybe some Portuguese colleague can help us.
Regards,
Nacho Alférez.
Hey Nacho,
How do you delete records from the AREPORTM table?
Hello,
You could use the History/purge function (GESAHI) to purge data from the ATMP (Temporary tables). AREPORTM is included in this this purge function. On the right hand side of the screen you can select Purge parameters to enter specific criteria as to what to purge.
Attempt this in a Test environment prior to attempting in a production environment, of course.
Thanks,
Rafael
how would i execute this?
*Community Hub is the new name for Sage City