Is there a way to stop the system writing into table TMPSRPT (Temporary print key table)?

SOLVED

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? 

Parents
  • +1
    verified answer

    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.

  • 0 in reply to Nacho_Alferez

    Hey Nacho,

    How do you delete records from the AREPORTM table?

  • +1 in reply to ChrisCC
    verified answer

    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

Reply
  • +1 in reply to ChrisCC
    verified answer

    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

Children