Skip to Content
avatar image
Former Member

Job RSDB4UPG running long time

Group,

we found the background job RSDB4UPD on our system running longer time than normal and effect system performance. The system is ECC5.0 runing on V5R4M0.

Anyone has experience on it ? Thanks...

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jul 17, 2006 at 03:52 PM

    Has the size of your DBSTATHDB4 and/or DBSTAIHDB4 tables grown? IIRC this job normally cleans them out and there have been problems in the past with it not working correctly. How long does it take to run? Has it steadilly increased over time or was there an abrupt change?

    Andy

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 18, 2006 at 07:33 AM

    The program RSDB4UPD just clean up the ff files: DBSTATHDB4 and DBSTAIHDB4 and MONI

    You can manually cleanup the files by splliting up the dates from the OS level like initially cleaning up the files in 2004 , then 2005 and so on via STRSQL or if you prefer to do it one command, try using clrpfm.

    Add comment
    10|10000 characters needed characters exceeded