What happens at 3AM?

Sean F (1.3k●2●32●132) | asked Apr 02 '21, 12:19 p.m.

My standalone 702 server always jumps to life at 3AM and the processor starts thrashing for over an hour and the server becomes difficult to use.

I checked the schedule for DW and all the DW jobs are scheduled to run at 00.00 so it is not DW I don't think.

is there some other scheduled database activity that kicks off at 3AM and can it be changed to a different time?

Accepted answer

permanent link

Davyd Norris (2.0k●1●17) | answered Apr 03 '21, 9:59 p.m.

Normally the DW has two sets of jobs - the core ones at the top run at midnight and the more intensive ones run at 3 from memory.

Check the schedule for the second set of jobs and see if that's it

Sean F selected this answer as the correct answer

One other answer

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Carol Watson (710●15) | answered Apr 02 '21, 12:29 p.m.

Hi Sean,

We're on 6.0.6.1, so not sure this applies, but we run this task nightly during the early hours (see RM Advanced Properties).. Could it be something like that?

com.ibm.team.jfs.indexing.service.internal.CleanUpUnusedIndexesVersionsTask

Carol

Comments

Sean F commented Apr 02 '21, 2:33 p.m.

Thanks Carol

That is disabled on my server value = -1

It's all about the answers!

Related questions

What happens at 3AM?

Accepted answer

One other answer

Your answer